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

Surnames > B > BR > BRD

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
BRA BRD BRE BRH BRI BRK BRL BRN BRO BRT BRU BRY BRZ

Full Surname List Starting with BRD(Alphabetical)

BRDA
BRDAR

Top 100 Surnames in the 2010 US Census starting with BRD

SurnameCountRankWiki?
BRDAR 145 119508 no
BRDA 123 136449 no