select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'GU' order by rank asc limit 0,100 Surnames > G > GU > GUV

Surnames > G > GU > GUV

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
GA GB GD GE GF GH GI GJ GL GM GN GO GR GS GU GW GY
GU GUA GUB GUC GUD GUE GUF GUG GUH GUI GUJ GUK GUL GUM GUN GUO GUP GUR GUS GUT GUV GUY GUZ

Full Surname List Starting with GUV(Alphabetical)

GUVARA
GUVEN

Top 100 Surnames in the 2010 US Census starting with GUV

SurnameCountRankWiki?
GUVEN 223 84136 no
GUVARA 112 147253 no