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

Surnames > U > UP > UPT

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
UPA UPC UPD UPE UPF UPH UPK UPL UPM UPO UPP UPR UPS UPT UPW

Full Surname List Starting with UPT(Alphabetical)

UPTAGRAFFT
UPTAIN
UPTEGROVE
UPTERGROVE
UPTGRAFT
UPTHEGROVE
UPTMOR
UPTMORE
UPTON

Top 100 Surnames in the 2010 US Census starting with UPT

SurnameCountRankWiki?
UPTON 13769 2616 yes
UPTAIN 809 29261 no
UPTEGROVE 370 55505 no
UPTHEGROVE 341 59324 no
UPTMOR 274 71265 no
UPTERGROVE 197 93125 no
UPTAGRAFFT 158 111426 no
UPTMORE 145 119508 no
UPTGRAFT 109 150452 no