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

Surnames > Z > ZW > ZWA

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
ZWA ZWE ZWI ZWO

Full Surname List Starting with ZWA(Alphabetical)

ZWAAN
ZWACK
ZWAGERMAN
ZWAHLEN
ZWAHR
ZWAK
ZWALD
ZWALLY
ZWANG
ZWANZIG
ZWANZIGER
ZWAR
ZWART
ZWAYER

Top 100 Surnames in the 2010 US Census starting with ZWA

SurnameCountRankWiki?
ZWART 1183 21940 no
ZWACK 487 44193 no
ZWAHLEN 469 45569 no
ZWALD 254 75799 no
ZWAHR 199 92358 no
ZWANZIGER 197 93125 no
ZWALLY 160 110286 no
ZWAYER 153 114424 no
ZWAK 153 114424 no
ZWAGERMAN 145 119508 no
ZWANG 130 130610 no
ZWAAN 128 132206 no
ZWAR 107 152628 no
ZWANZIG 102 158432 no