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

Surnames > Z > ZA > ZAE

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
ZA ZAA ZAB ZAC ZAD ZAE ZAF ZAG ZAH ZAI ZAJ ZAK ZAL ZAM ZAN ZAO ZAP ZAR ZAS ZAT ZAU ZAV ZAW ZAY ZAZ

Full Surname List Starting with ZAE(Alphabetical)

ZAEBST
ZAEHRINGER
ZAENGLE
ZAENGLEIN
ZAEPFEL
ZAESKE

Top 100 Surnames in the 2010 US Census starting with ZAE

SurnameCountRankWiki?
ZAEHRINGER 209 88685 no
ZAESKE 208 89069 no
ZAEPFEL 186 97671 no
ZAENGLE 144 120187 no
ZAENGLEIN 125 134712 no
ZAEBST 119 140157 no