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 = 'GY' order by rank asc limit 0,100 Surnames > G > GY > GYG

Surnames > G > GY > GYG

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
GYA GYD GYE GYG GYI GYL GYN GYO GYS GYU

Full Surname List Starting with GYG(Alphabetical)

GYGAX
GYGER
GYGI

Top 100 Surnames in the 2010 US Census starting with GYG

SurnameCountRankWiki?
GYGI 330 60960 no
GYGER 312 63873 no
GYGAX 149 116829 no