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 = 'RO' order by rank asc limit 0,100 Surnames > R > RO > ROF

Surnames > R > RO > ROF

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
RA RC RE RH RI RM RO RU RY RZ
RO ROA ROB ROC ROD ROE ROF ROG ROH ROI ROJ ROK ROL ROM RON ROO ROP ROQ ROR ROS ROT ROU ROV ROW ROX ROY ROZ

Full Surname List Starting with ROF(Alphabetical)

ROFAIL
ROFE
ROFF
ROFFE
ROFFERS
ROFFEY
ROFFLER
ROFFMAN
ROFFO
ROFKAHR
ROFRANO

Top 100 Surnames in the 2010 US Census starting with ROF

SurnameCountRankWiki?
ROFF 1339 19997 no
ROFFE 385 53667 no
ROFFMAN 368 55741 no
ROFFERS 316 63218 no
ROFE 176 102197 no
ROFFEY 167 106570 no
ROFRANO 156 112568 no
ROFKAHR 149 116829 no
ROFFLER 136 126018 no
ROFAIL 129 131379 no
ROFFO 106 153769 no