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

Surnames > A > AF > AFT

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
AFA AFD AFE AFF AFG AFI AFK AFL AFM AFO AFR AFS AFT AFU AFZ

Full Surname List Starting with AFT(Alphabetical)

AFTAB
AFTANAS
AFTON

Top 100 Surnames in the 2010 US Census starting with AFT

SurnameCountRankWiki?
AFTAB 493 43732 no
AFTON 244 78316 no
AFTANAS 120 139228 no