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 = 'FO' order by rank asc limit 0,100 Surnames > F > FO > FOA

Surnames > F > FO > FOA

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
FA FE FF FI FJ FL FN FO FR FU FY
FO FOA FOB FOC FOD FOE FOF FOG FOH FOI FOJ FOK FOL FOM FON FOO FOP FOR FOS FOT FOU FOW FOX FOY FOZ

Full Surname List Starting with FOA(Alphabetical)

FOARD
FOAT

Top 100 Surnames in the 2010 US Census starting with FOA

SurnameCountRankWiki?
FOARD 997 24934 no
FOAT 311 64054 no