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 = 'BI' order by rank asc limit 0,100 Surnames > B > BI > BIW

Surnames > B > BI > BIW

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
BA BE BH BI BJ BL BO BR BS BU BY BZ
BI BIA BIB BIC BID BIE BIF BIG BIH BIJ BIK BIL BIM BIN BIO BIP BIR BIS BIT BIU BIV BIW BIX BIZ

Full Surname List Starting with BIW(Alphabetical)

BIWER

Top 100 Surnames in the 2010 US Census starting with BIW

SurnameCountRankWiki?
BIWER 349 58182 no