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 = 'ZD' order by rank asc limit 0,100 Surnames > Z > ZD > ZDA

Surnames > Z > ZD > ZDA

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
ZA ZB ZD ZE ZG ZH ZI ZL ZM ZN ZO ZR ZS ZU ZV ZW ZY
ZDA ZDE ZDI ZDO ZDR ZDU ZDY ZDZ

Full Surname List Starting with ZDA(Alphabetical)

ZDAN
ZDANCEWICZ
ZDANIS
ZDANOWICZ
ZDANOWSKI

Top 100 Surnames in the 2010 US Census starting with ZDA

SurnameCountRankWiki?
ZDANOWICZ 488 44109 no
ZDANOWSKI 287 68547 no
ZDAN 144 120187 no
ZDANIS 128 132206 no
ZDANCEWICZ 123 136449 no