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

Surnames > Z > ZI > ZIZ

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
ZI ZIA ZIB ZIC ZID ZIE ZIF ZIG ZIH ZII ZIK ZIL ZIM ZIN ZIO ZIP ZIR ZIS ZIT ZIU ZIV ZIY ZIZ

Full Surname List Starting with ZIZ(Alphabetical)

ZIZAK
ZIZELMAN
ZIZUMBO
ZIZZA
ZIZZI
ZIZZO

Top 100 Surnames in the 2010 US Census starting with ZIZ

SurnameCountRankWiki?
ZIZZO 888 27228 no
ZIZUMBO 383 53913 no
ZIZZA 374 54990 no
ZIZZI 225 83541 no
ZIZELMAN 149 116829 no
ZIZAK 104 156044 no