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 = 'LA' order by rank asc limit 0,100 Surnames > L > LA > LAA

Surnames > L > LA > LAA

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
LA LE LH LI LJ LL LN LO LU LW LY LZ
LA LAA LAB LAC LAD LAE LAF LAG LAH LAI LAJ LAK LAL LAM LAN LAO LAP LAQ LAR LAS LAT LAU LAV LAW LAX LAY LAZ

Full Surname List Starting with LAA(Alphabetical)

LAA
LAABS
LAACK
LAAK
LAAKE
LAAKER
LAAKKONEN
LAAKSO
LAAKSONEN
LAARMAN
LAAS
LAASE
LAATSCH
LAATZ

Top 100 Surnames in the 2010 US Census starting with LAA

SurnameCountRankWiki?
LAABS 1621 17406 no
LAATSCH 640 35203 no
LAAKSO 607 36788 no
LAAKE 513 42308 no
LAACK 412 50659 no
LAAS 299 66164 no
LAARMAN 190 95955 no
LAA 182 99378 no
LAAKSONEN 170 105079 no
LAAKER 159 110825 no
LAASE 144 120187 no
LAATZ 141 122314 no
LAAK 115 144141 no
LAAKKONEN 104 156044 no