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

Surnames > Y > YE > YEP

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
YE YEA YEB YEC YED YEE YEF YEG YEH YEI YEK YEL YEM YEN YEO YEP YER YES YET YEU YEV YEW YEZ

Full Surname List Starting with YEP(Alphabetical)

YEP
YEPA
YEPES
YEPEZ
YEPIZ
YEPREMIAN
YEPSEN

Top 100 Surnames in the 2010 US Census starting with YEP

SurnameCountRankWiki?
YEPEZ 6433 5411 no
YEPES 1355 19834 no
YEPIZ 689 33196 no
YEP 658 34427 no
YEPSEN 181 99845 no
YEPA 155 113155 no
YEPREMIAN 119 140157 no