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 = 'JO' order by rank asc limit 0,100 Surnames > J > JO > JOY

Surnames > J > JO > JOY

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
JA JB JE JH JI JN JO JU JY
JO JOA JOB JOC JOD JOE JOF JOG JOH JOI JOJ JOK JOL JOM JON JOO JOP JOR JOS JOU JOV JOW JOY JOZ

Full Surname List Starting with JOY(Alphabetical)

JOY
JOYA
JOYAL
JOYCE
JOYE
JOYER
JOYNER
JOYNES
JOYNT

Top 100 Surnames in the 2010 US Census starting with JOY

SurnameCountRankWiki?
JOYCE 34132 1022 no
JOYNER 29884 1177 no
JOY 13413 2684 no
JOYA 2821 11204 no
JOYAL 1614 17463 no
JOYE 1268 20818 no
JOYNES 827 28777 no
JOYNT 810 29231 no
JOYER 111 148347 no