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

Surnames > I > IC > ICE

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
ICA ICB ICE ICH ICK ICO ICZ

Full Surname List Starting with ICE(Alphabetical)

ICE
ICEDO
ICEMAN
ICENHOUR
ICENHOWER
ICENOGLE

Top 100 Surnames in the 2010 US Census starting with ICE

SurnameCountRankWiki?
ICE 3994 8295 no
ICENHOUR 803 29422 no
ICENOGLE 777 30165 no
ICENHOWER 545 40204 no
ICEMAN 277 70645 no
ICEDO 100 160975 no