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 = 'UR' order by rank asc limit 0,100 Surnames > U > UR > URL

Surnames > U > UR > URL

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
UB UC UD UE UF UG UH UI UJ UK UL UM UN UO UP UQ UR US UT UV UW UY UZ
UR URA URB URC URD URE URF URG URH URI URK URL URM URN URO URP URQ URR URS URT URU URV URW URY URZ

Full Surname List Starting with URL(Alphabetical)

URLACHER
URLAUB
URLING

Top 100 Surnames in the 2010 US Census starting with URL

SurnameCountRankWiki?
URLACHER 417 50196 no
URLAUB 270 72105 no
URLING 160 110286 no