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

Surnames > G > GW > GWY

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
GWA GWE GWI GWO GWY

Full Surname List Starting with GWY(Alphabetical)

GWYN
GWYNN
GWYNNE
GWYTHER

Top 100 Surnames in the 2010 US Census starting with GWY

SurnameCountRankWiki?
GWYNN 3268 9894 no
GWYN 2297 13278 no
GWYNNE 489 44034 no
GWYTHER 104 156044 no