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 = 'DW' order by rank asc limit 0,100 Surnames > D > DW > DWA

Surnames > D > DW > DWA

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
DA DC DE DH DI DJ DL DM DO DR DS DU DV DW DY DZ
DWA DWE DWI DWO DWY

Full Surname List Starting with DWA(Alphabetical)

DWAILEEBE
DWAMENA
DWAN
DWANE
DWARIKA
DWARKA
DWATER

Top 100 Surnames in the 2010 US Census starting with DWA

SurnameCountRankWiki?
DWAN 407 51176 no
DWARKA 216 86314 no
DWARIKA 143 120901 no
DWANE 115 144141 no
DWAMENA 110 149395 no
DWAILEEBE 110 149395 no
DWATER 103 157234 no