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

Surnames > B > BY > BYW

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
BY BYA BYB BYC BYD BYE BYF BYG BYH BYI BYK BYL BYM BYN BYO BYR BYS BYT BYU BYW BYX BYZ

Full Surname List Starting with BYW(Alphabetical)

BYWATER
BYWATERS

Top 100 Surnames in the 2010 US Census starting with BYW

SurnameCountRankWiki?
BYWATER 1032 24305 no
BYWATERS 351 57914 no