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

Surnames > J > JO > JOF

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

JOFFE
JOFFRE
JOFFRION
JOFRE

Top 100 Surnames in the 2010 US Census starting with JOF

SurnameCountRankWiki?
JOFFE 974 25403 no
JOFFRION 654 34574 no
JOFRE 298 66371 no
JOFFRE 165 107669 no