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

Surnames > Z > ZA > ZAJ

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

ZAJAC
ZAJACK
ZAJACZKOWSKI
ZAJCHOWSKI
ZAJDA
ZAJDEL
ZAJEC
ZAJIC
ZAJICEK
ZAJKOWSKI

Top 100 Surnames in the 2010 US Census starting with ZAJ

SurnameCountRankWiki?
ZAJAC 5270 6444 no
ZAJICEK 995 24982 no
ZAJDEL 539 40554 no
ZAJKOWSKI 531 41038 no
ZAJIC 353 57639 no
ZAJACZKOWSKI 315 63373 no
ZAJACK 198 92719 no
ZAJEC 129 131379 no
ZAJCHOWSKI 127 133048 no
ZAJDA 120 139228 no