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

Surnames > L > LU > LUF

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
LU LUA LUB LUC LUD LUE LUF LUG LUH LUI LUJ LUK LUL LUM LUN LUO LUP LUQ LUR LUS LUT LUU LUV LUX LUY LUZ

Full Surname List Starting with LUF(Alphabetical)

LUFF
LUFFEY
LUFFMAN
LUFFY
LUFKIN
LUFRANO
LUFT
LUFTIG
LUFTMAN

Top 100 Surnames in the 2010 US Census starting with LUF

SurnameCountRankWiki?
LUFT 2548 12218 no
LUFF 1507 18378 yes
LUFFMAN 1216 21483 no
LUFKIN 1061 23817 no
LUFFY 218 85659 no
LUFTIG 178 101247 no
LUFRANO 175 102688 no
LUFFEY 154 113791 no
LUFTMAN 108 151532 no