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

Surnames > U > UL > ULL

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
ULA ULB ULC ULD ULE ULF ULH ULI ULL ULM ULN ULO ULR ULS ULT ULU ULV ULW ULY

Full Surname List Starting with ULL(Alphabetical)

ULLA
ULLAH
ULLAND
ULLE
ULLERICH
ULLERY
ULLMAN
ULLMANN
ULLMER
ULLO
ULLOA
ULLOM
ULLRICH
ULLRICK
ULLSPERGER
ULLSTROM
ULLUM

Top 100 Surnames in the 2010 US Census starting with ULL

SurnameCountRankWiki?
ULLOA 13133 2743 no
ULLRICH 3592 9093 no
ULLMAN 3213 10026 no
ULLAH 1974 14976 no
ULLOM 1603 17551 no
ULLERY 1251 21019 no
ULLMANN 1034 24260 no
ULLMER 473 45253 no
ULLAND 380 54296 no
ULLO 223 84136 no
ULLUM 153 114424 no
ULLE 140 123064 no
ULLERICH 122 137327 no
ULLA 121 138304 no
ULLSPERGER 105 154907 no
ULLSTROM 105 154907 no
ULLRICK 102 158432 no