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

Surnames > A > AL > ALZ

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

ALZAGA
ALZAHRANI
ALZAMORA
ALZATE
ALZAYADI
ALZONA
ALZOUBI
ALZUBAIDI
ALZUBAIDY
ALZUBI
ALZUGARAY

Top 100 Surnames in the 2010 US Census starting with ALZ

SurnameCountRankWiki?
ALZATE 1800 16087 no
ALZAMORA 525 41426 no
ALZAGA 270 72105 no
ALZAHRANI 252 76275 no
ALZUBI 181 99845 no
ALZUBAIDI 178 101247 no
ALZAYADI 163 108734 no
ALZONA 158 111426 no
ALZOUBI 158 111426 no
ALZUGARAY 136 126018 no
ALZUBAIDY 103 157234 no