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

Surnames > D > DZ > DZA

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
DZA DZI DZU DZW DZY

Full Surname List Starting with DZA(Alphabetical)

DZAFEROVIC
DZAFIC
DZAMBA
DZANANOVIC
DZANIC

Top 100 Surnames in the 2010 US Census starting with DZA

SurnameCountRankWiki?
DZAFIC 228 82613 no
DZAFEROVIC 181 99845 no
DZANANOVIC 159 110825 no
DZANIC 140 123064 no
DZAMBA 100 160975 no