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

Surnames > A > AS > ASF

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

ASFAHA
ASFAR
ASFAW
ASFELD
ASFOUR

Top 100 Surnames in the 2010 US Census starting with ASF

SurnameCountRankWiki?
ASFAW 883 27354 no
ASFOUR 545 40204 no
ASFAHA 210 88336 no
ASFAR 167 106570 no
ASFELD 159 110825 no