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

Surnames > A > AF > AFF

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

AFFATATO
AFFELD
AFFELDT
AFFHOLDER
AFFHOLTER
AFFINITO
AFFLECK
AFFLERBACH
AFFLICK
AFFLITTO
AFFOLDER
AFFOLTER
AFFONSO
AFFRONTI
AFFRUNTI
AFFUL
AFFUSO

Top 100 Surnames in the 2010 US Census starting with AFF

SurnameCountRankWiki?
AFFOLTER 758 30735 no
AFFLECK 744 31184 no
AFFELDT 693 33036 no
AFFINITO 416 50275 no
AFFLERBACH 345 58735 no
AFFONSO 280 69996 no
AFFRUNTI 271 71886 no
AFFLICK 255 75564 no
AFFRONTI 240 79338 no
AFFUL 207 89403 no
AFFOLDER 185 98099 no
AFFATATO 171 104602 no
AFFLITTO 167 106570 no
AFFHOLTER 158 111426 no
AFFUSO 118 141140 no
AFFELD 115 144141 no
AFFHOLDER 103 157234 no