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

Surnames > A > AJ > AJE

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
AJA AJD AJE AJI AJL AJM AJO AJP AJT AJU

Full Surname List Starting with AJE(Alphabetical)

AJELLO
AJEMIAN
AJERO
AJETI

Top 100 Surnames in the 2010 US Census starting with AJE

SurnameCountRankWiki?
AJELLO 299 66164 no
AJEMIAN 288 68345 no
AJERO 147 118185 no
AJETI 116 143149 no