Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hums” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

353 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hums9683142(None) 
bums85934591bums
chums125015831chums
gums75030941gums
hams96446131hams
hems95534941hems
hims95230971hims
hubs96027141hubs
hues75235231hues
hugs86129751hugs
hum85542931hum_
hump116228721hump
humps126322801humps
humus106215071humus
huns76136931huns
huts76737441huts
lums65734241lums
mums85732771mums
rums64833471rums
sums65837581sums
aims67738182aims
alms65834922alms
alums75720602alums
amus65529612amus
arms66137492arms
arums75517832arums
auks85525262auks
bams87044452bams
bhuts105812952bhuts
bubs86235502bubs
buds75235172buds
bugs76035912bugs
bum75342692bum_
bumf116126512bumf
bumfs125414052bumfs
bump106228242bump
bumps115921142bumps
buns66243722buns
burs65847422burs
bus56950972bu_s
buss65134912buss
buts67247692buts
buys95726792buys
cams87047282cams
chams126028502chams
chubs125412622chubs
chugs115511942chugs
chum116318002chum_
chump145315442chump
chumps154313822chumps
cubs85832382cubs
cuds76730472cuds
cues65438982cues
culms95314192culms
cum76440162cum_
cups85430822cups
curs65645542curs
cuss65430612cuss
cuts65841152cuts
cwms11439572cwms
dams77444372dams
dims75435022dims
doms76239572doms
doums85417642doums
drums85415872drums
dubs78432192dubs
duds65530142duds
dues56045502dues
dugs614832282dugs
duma75524452duma
dumas85420432dumas
dumb97124102dumb
dumbs105915752dumbs
dump95927092dump
dumps105220102dumps
duns55140432duns
duos56728132duos
dups75929512dups
elms67322702elms
ems56435492_ems
emus66821682emus
fems96428702fems
fubs96328792fubs
fuds86528562fuds
fugs85730692fugs
fume96727632fume
fumes105224702fumes
fumy127118582fumy
funs75235732funs
furs76735042furs
fuss76027932fuss
gams76648882gams
gaums86217072gaums
gems75329112gems
geums85414112geums
glums84621422glums
guls55930852guls
gum67439532gum_
guns55533482guns
guts56637252guts
guvs85816812guvs
guys85019642guys
gyms107514592gyms
haems105517012haems
haes77651022haes
hags86740842hags
hahs108333362hahs
halms105225212halms
ham86363282ham_
hame97043132hame
hames106138702hames
haps96443462haps
harms106829012harms
has67372652h_as
hats76858252hats
haulms11558502haulms
hauls86123732hauls
haws106439442haws
hays106138072hays
hehs106723962hehs
helms105619462helms
hem86148732hem_
heme95034412heme
hemes105031082hemes
hemp115725622hemp
hemps126917332hemps
hens75642572hens
herms105626432herms
hers75844872hers
hes66654202h_es
hets75547202hets
hews105631572hews
hies74842832hies
him86247662him_
hins76447992hins
hips96433702hips
his66359502h_is
hiss75629212hiss
hits75545132hits
hm78126732h_m_
hmm106218992h_mm
hobs97038982hobs
hods87239862hods
hoes75755732hoes
hogs87139662hogs
hokums1533922hokums
holms105117802holms
hols76946292hols
home98042442home
homes106938822homes
homo96126472homo
homos105921792homos
homy126623222homy
hons77350782hons
hops97942632hops
hos68364192h_os
hots78349332hots
hours85422392hours
hows106345602hows
hoys107733932hoys
hub86437482hu_b
huck135927632huck
hucks144322172hucks
hue66642302hu_e
hued86925852hued
huff135623842huff
huffs144514742huffs
hug76037362hu_g
huge86321652huge
huh96432012hu_h
huic94818052huic
hula74923752hula
hulas84920882hulas
hulk115321612hulk
hulks125715482hulks
hull75428782hull
hulls84923562hulls
human102716032human
humans112312432humans
humic124113242humic
humid114213762humid
hummus1336242hummus
humor101110512humor
humors11129632humors
humph155712212humph
humphs16528162humphs
humpy155115672humpy
hun65844712hu_n
hung86126352hung
hunh106323732hunh
hunk116029542hunk
hunks125321452hunks
hunt76445492hunt
hunts86826172hunts
hup86437812hu_p
hurds95219072hurds
hurl76029932hurl
hurls86522712hurls
hurst85527192hurst
hurt77142572hurt
hurts86922822hurts
hush105224112hush
husk116021952husk
husks125015452husks
hussy116812762hussy
hut66457292hu_t
hymn12311312hymn
hymns1337522hymns
hyps125418412hyps
isms66213472isms
jams135231072jams
jugs125525602jugs
jump156621722jump
jumps165116492jumps
jus106930222ju_s
juts115930162juts
khoums1594012khoums
kues86426772kues
kumys1435932kumys
lams66552262lams
lues45943552lues
lugs55233522lugs
lum55542932lum_
luma65527522luma
lumas75622912lumas
lump86531702lump
lumps95624982lumps
luvs75818502luvs
mems85931502mems
moms86539482moms
muds75530652muds
mugs76232042mugs
mum76643612mum_
mumm75718862mumm
mumms85513152mumms
mump105425722mump
mumps115619102mumps
mumu86022062mumu
mumus95517282mumus
muns65535922muns
mus55946752mu_s
muss64933762muss
muts64839982muts
neums75414252neums
nims66226882nims
noms65636402noms
nubs65927142nubs
numb85520612numb
numbs94913092numbs
nuns45228232nuns
nus37939392nu_s
nuts45032672nuts
ohms95514032ohms
oms56337512_oms
ouds56430102ouds
ours47237562ours
outs45746962outs
pams85641762pams
phuts104613502phuts
plums94619952plums
poms87037742poms
pubs85029212pubs
puds75630512puds
pugs76332772pugs
puls65437562puls
puma85424122puma
pumas95121562pumas
pump105726852pump
pumps115520602pumps
puns66641482puns
pups86032232pups
purs65641042purs
pus55547842pu_s
puss64830132puss
puts65641752puts
rams65950772rams
rems66237722rems
rheums1135462rheums
rhumb12438652rhumb
rhumbs13366772rhumbs
rhus75114052rhu_s
rims65936302rims
roms67038962roms
rubs66133492rubs
rues46044482rues
rugs56033682rugs
rum56644642rum_
rump86729082rump
rumps95922292rumps
runs46438082runs
ruts44541492ruts
scums95017422scums
shams105829412shams
shims104422552shims
shuls85319712shuls
shuns85018142shuns
shuts85622482shuts
sims65737172sims
slums74623432slums
soms66239372soms
stums75320082stums
subs66037122subs
suds56135292suds
sues46247652sues
suks85927122suks
sum56346012sum_
sumo67326312sumo
sumos75720092sumos
sump86331532sump
sumps95023432sumps
suns45841902suns
sups64834432sups
suqs134319652suqs
suss45229302suss
tams67247932tams
thrums11429122thrums
thuds95110132thuds
thugs95611992thugs
thumb124511282thumb
thumbs13377442thumbs
thump126211572thump
thumps13449352thumps
thus76721472thu_s
toms68343492toms
tubs65430062tubs
tugs56231672tugs
tuis44829642tuis
tump85927032tump
tumps95420792tumps
tuns45138662tuns
tups65628762tups
tuts45838452tuts
um47338832_um_
umm711921262_umm
ump76130442_ump
umps85721942_umps
uns35936762_uns
ups55629052_ups
us26937432_u_s
uts35534372_uts
vims95423312vims
vugs87022872vugs
vum85428652vum_
whams135515642whams
whims134515332whims
whump154910042whump
whumps16427092whumps
whups134210002whups
wuss75219332wuss
yams95330732yams
yuks116418022yuks
yum86132822yum_
yups96121602yups

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691298720.300595636.7
2DLD Change Limit298723530.86034734.9
3Display Results3533530.0903922.2
 (SQL Overall)1786913531.250142952.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.