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

Surnames > O > OL > OLH

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

OLHAUSEN
OLHEISER

Top 100 Surnames in the 2010 US Census starting with OLH

SurnameCountRankWiki?
OLHEISER 458 46487 no
OLHAUSEN 172 104156 no