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 = 'AS' order by rank asc limit 0,100 Surnames > A > AS > ASW

Surnames > A > AS > ASW

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
AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ
ASA ASB ASC ASD ASE ASF ASG ASH ASI ASK ASL ASM ASN ASO ASP ASQ ASR ASS AST ASU ASW ASZ

Full Surname List Starting with ASW(Alphabetical)

ASWAD
ASWANI
ASWEGAN
ASWELL

Top 100 Surnames in the 2010 US Census starting with ASW

SurnameCountRankWiki?
ASWAD 321 62359 no
ASWEGAN 243 78567 no
ASWELL 212 87663 no
ASWANI 166 107134 no