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

Surnames > I > IB > IBU

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
IBA IBB IBE IBI IBO IBR IBS IBU

Full Surname List Starting with IBU(Alphabetical)

IBUADO
IBURG

Top 100 Surnames in the 2010 US Census starting with IBU

SurnameCountRankWiki?
IBURG 224 83834 no
IBUADO 142 121590 no