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

Surnames > A > AL > ALJ

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
AL ALA ALB ALC ALD ALE ALF ALG ALH ALI ALJ ALK ALL ALM ALN ALO ALP ALQ ALR ALS ALT ALU ALV ALW ALY ALZ

Full Surname List Starting with ALJ(Alphabetical)

ALJABER
ALJAHMI
ALJAMAL
ALJANABI
ALJETS
ALJIC
ALJOE

Top 100 Surnames in the 2010 US Census starting with ALJ

SurnameCountRankWiki?
ALJAHMI 392 52851 no
ALJETS 261 74141 no
ALJAMAL 241 79075 no
ALJOE 180 100302 no
ALJANABI 151 115639 no
ALJABER 114 145220 no
ALJIC 103 157234 no