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

Surnames > Z > ZI > ZIP

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

ZIPAY
ZIPF
ZIPFEL
ZIPKIN
ZIPP
ZIPPAY
ZIPPEL
ZIPPER
ZIPPERER
ZIPPERIAN
ZIPPILLI
ZIPPRICH
ZIPSE
ZIPSER

Top 100 Surnames in the 2010 US Census starting with ZIP

SurnameCountRankWiki?
ZIPPERER 1144 22481 no
ZIPP 1053 23957 no
ZIPFEL 552 39773 no
ZIPF 507 42720 no
ZIPPER 402 51723 no
ZIPPRICH 322 62189 no
ZIPAY 290 67943 no
ZIPKIN 289 68122 no
ZIPSE 259 74608 no
ZIPSER 187 97210 no
ZIPPEL 186 97671 no
ZIPPAY 140 123064 no
ZIPPILLI 121 138304 no
ZIPPERIAN 119 140157 no