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 = 'OL' order by rank asc limit 0,100 Surnames > O > OL > OLF

Surnames > O > OL > OLF

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
OA OB OC OD OE OF OG OH OI OJ OK OL OM ON OO OP OQ OR OS OT OU OV OW OX OY OZ
OL OLA OLB OLC OLD OLE OLF OLG OLH OLI OLK OLL OLM OLN OLO OLP OLR OLS OLT OLU OLV OLW OLY OLZ

Full Surname List Starting with OLF(Alphabetical)

OLFERS
OLFERT
OLFORD

Top 100 Surnames in the 2010 US Census starting with OLF

SurnameCountRankWiki?
OLFERT 131 129825 no
OLFERS 128 132206 no
OLFORD 104 156044 no