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

Surnames > Z > ZI > ZIS

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

ZISA
ZISCHKE
ZISHKA
ZISK
ZISKA
ZISKIN
ZISKIND
ZISKO
ZISMAN
ZISS
ZISSER
ZISSLER

Top 100 Surnames in the 2010 US Census starting with ZIS

SurnameCountRankWiki?
ZISKA 500 43206 no
ZISA 440 48060 no
ZISK 344 58876 no
ZISMAN 290 67943 no
ZISKIND 277 70645 no
ZISKIN 262 73911 no
ZISCHKE 177 101737 no
ZISSLER 166 107134 no
ZISKO 129 131379 no
ZISSER 119 140157 no
ZISS 105 154907 no
ZISHKA 101 159712 no