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

Surnames > O > OL > OLR

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

OLREE
OLRICH

Top 100 Surnames in the 2010 US Census starting with OLR

SurnameCountRankWiki?
OLRICH 188 96799 no
OLREE 147 118185 no