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 = 'IZ' order by rank asc limit 0,100 Surnames > I > IZ > IZZ

Surnames > I > IZ > IZZ

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
IA IB IC ID IE IF IG IH II IJ IK IL IM IN IO IP IQ IR IS IT IU IV IW IX IY IZ
IZA IZB IZE IZG IZL IZN IZO IZQ IZR IZS IZU IZW IZY IZZ

Full Surname List Starting with IZZ(Alphabetical)

IZZARD
IZZARELLI
IZZI
IZZO

Top 100 Surnames in the 2010 US Census starting with IZZ

SurnameCountRankWiki?
IZZO 4717 7098 no
IZZI 958 25725 no
IZZARD 882 27376 no
IZZARELLI 121 138304 no