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

Surnames > R > RO > ROI

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

ROI
ROIAS
ROIG
ROIGER
ROINESTAD
ROIS
ROISE
ROISUM
ROITER
ROITMAN
ROIX
ROIZ

Top 100 Surnames in the 2010 US Census starting with ROI

SurnameCountRankWiki?
ROIG 1433 19012 no
ROIZ 401 51830 no
ROIGER 354 57516 no
ROITMAN 281 69793 no
ROIS 201 91625 no
ROISUM 193 94730 no
ROI 160 110286 no
ROITER 144 120187 no
ROISE 107 152628 no
ROIAS 106 153769 no
ROINESTAD 104 156044 no
ROIX 101 159712 no