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

Surnames > U > UP > UPP

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

UPP
UPPAL
UPPALA
UPPALAPATI
UPPENCAMP
UPPER
UPPERMAN
UPPINGHOUSE
UPPOLE
UPPULURI

Top 100 Surnames in the 2010 US Census starting with UPP

SurnameCountRankWiki?
UPPAL 1305 20364 no
UPP 730 31656 no
UPPERMAN 457 46568 no
UPPALAPATI 312 63873 no
UPPER 180 100302 no
UPPALA 176 102197 no
UPPULURI 142 121590 no
UPPINGHOUSE 116 143149 no
UPPOLE 114 145220 no
UPPENCAMP 100 160975 no