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

Surnames > U > UG > UGL

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
UGA UGL UGO UGU UGW

Full Surname List Starting with UGL(Alphabetical)

UGLAND
UGLOW
UGLUM

Top 100 Surnames in the 2010 US Census starting with UGL

SurnameCountRankWiki?
UGLOW 226 83226 no
UGLAND 151 115639 no
UGLUM 105 154907 no