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

Surnames > I > IB > IBB

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

IBBERSON
IBBETSON
IBBITSON
IBBOTSON
IBBS

Top 100 Surnames in the 2010 US Census starting with IBB

SurnameCountRankWiki?
IBBOTSON 534 40856 no
IBBETSON 257 75069 no
IBBERSON 180 100302 no
IBBITSON 136 126018 no
IBBS 115 144141 no