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

Surnames > G > GW > GWI

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

GWIAZDA
GWIAZDOWSKI
GWIDT
GWILLIAM
GWILLIM
GWILT
GWIN
GWINN
GWINNER
GWINNUP
GWINUP
GWIRTZ
GWISDALLA
GWIZDAK
GWIZDALA

Top 100 Surnames in the 2010 US Census starting with GWI

SurnameCountRankWiki?
GWINN 4852 6915 no
GWIN 4781 7006 no
GWILLIAM 522 41657 no
GWINNER 415 50362 no
GWIZDALA 339 59603 no
GWILT 316 63218 no
GWIAZDOWSKI 291 67747 no
GWIAZDA 223 84136 no
GWILLIM 207 89403 no
GWINNUP 196 93513 no
GWIDT 144 120187 no
GWIZDAK 135 126765 no
GWIRTZ 113 146201 no
GWISDALLA 103 157234 no
GWINUP 100 160975 no