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

Surnames > L > LI > LIW

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
LI LIA LIB LIC LID LIE LIF LIG LII LIJ LIK LIL LIM LIN LIO LIP LIQ LIR LIS LIT LIU LIV LIW LIY LIZ

Full Surname List Starting with LIW(Alphabetical)

LIWAG
LIWANAG

Top 100 Surnames in the 2010 US Census starting with LIW

SurnameCountRankWiki?
LIWANAG 819 28998 no
LIWAG 376 54752 no