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 > JOI

Surnames > J > JO > JOI

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 JOI(Alphabetical)

JOICE
JOINER
JOINES
JOINS
JOINT
JOINTER
JOINVILLE

Top 100 Surnames in the 2010 US Census starting with JOI

SurnameCountRankWiki?
JOINER 16349 2228 no
JOINES 2131 14105 no
JOICE 435 48530 no
JOINTER 378 54530 no
JOINT 332 60636 no
JOINS 148 117480 no
JOINVILLE 126 133863 no