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 > GUJ

Surnames > G > GU > GUJ

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 GUJ(Alphabetical)

GUJAR
GUJRAL

Top 100 Surnames in the 2010 US Census starting with GUJ

SurnameCountRankWiki?
GUJRAL 301 65782 no
GUJAR 101 159712 no