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 = 'YL' order by rank asc limit 0,100 Surnames > Y > YL > YLI

Surnames > Y > YL > YLI

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
YA YB YC YD YE YG YH YI YL YM YN YO YP YR YS YT YU YV YZ
YLA YLI YLL YLV

Full Surname List Starting with YLI(Alphabetical)

YLINEN
YLINIEMI
YLITALO

Top 100 Surnames in the 2010 US Census starting with YLI

SurnameCountRankWiki?
YLITALO 391 52970 no
YLINIEMI 186 97671 no
YLINEN 171 104602 no