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

Surnames > Z > ZI > ZIO

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

ZIOBRO
ZIOBRON
ZIOBROWSKI
ZIOGAS
ZIOLA
ZIOLKO
ZIOLKOWSKI
ZIOLO
ZIOMEK
ZION
ZIONS

Top 100 Surnames in the 2010 US Census starting with ZIO

SurnameCountRankWiki?
ZIOLKOWSKI 2281 13360 no
ZION 1318 20216 no
ZIOBRO 649 34801 no
ZIOMEK 647 34878 no
ZIOLA 256 75317 no
ZIOBROWSKI 188 96799 no
ZIOLKO 146 118853 no
ZIOGAS 144 120187 no
ZIOLO 134 127494 no
ZIOBRON 132 129047 no
ZIONS 101 159712 no