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

Surnames > A > AL > ALW

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

ALWAN
ALWANI
ALWARD
ALWARDT
ALWAY
ALWELL
ALWES
ALWIN
ALWINE
ALWOOD
ALWORTH

Top 100 Surnames in the 2010 US Census starting with ALW

SurnameCountRankWiki?
ALWARD 1461 18766 no
ALWINE 1085 23432 no
ALWAN 620 36154 no
ALWIN 510 42511 no
ALWOOD 365 56073 no
ALWARDT 341 59324 no
ALWORTH 336 60045 no
ALWAY 309 64388 no
ALWELL 202 91221 no
ALWES 154 113791 no
ALWANI 139 123796 no