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 “elms” 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.

225 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
elms6732270(None) 
alms65834921alms
elds56324851elds
elks85820031elks
ells46431351ells
elm57531741elm_
elmy95616791elmy
els37645721el_s
ems56435491e_ms
helms105619461helms
aims67738182aims
alas46358122alas
albs68628572albs
ales47067102ales
alls46740922alls
alma66333022alma
almas76629772almas
alme65832162alme
almes75126542almes
alps65529242alps
als36663022al_s
alts46639902alts
alums75720602alums
arms66137492arms
balms95723922balms
bams87044452bams
beams95328172beams
bells76432162bells
bels66142492bel_s
belts75931162belts
berms95323662berms
blams95023852blams
bums85934592bums
calms95222352calms
cams87047282cams
cells75428062cells
celoms10412122celoms
cels65534972cel_s
celts75325782celts
clams95127672clams
culms95314192culms
cwms11439572cwms
dams77444372dams
deems85421772deems
deles65139252deles
delfs94918672delfs
delis64928542delis
dells66630942dells
dels56745472del_s
delts65731792delts
derms85022892derms
dims75435022dims
doms76239572doms
ears46356592ears
eats47054872eats
ebbs82411992ebbs
ecus65421462ecus
edhs86212102edhs
eds46638922e_ds
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
eggs66516152eggs
egis56520652egis
egos55821652egos
ekes86726602ekes
el26745292el__
elan46734242elan
elans55527752elans
eld46733792el_d
elemi7312502elemi
elemis8312382elemis
elf66138522el_f
elhi7612402elhi
elk76726122el_k
ell36735682el_l
else45923082else
elves85118742elves
em49445152e_m_
eme55837182e_me
emes65434662emes
emmy116013242emmy
emmys12446022emmys
emu55929982e_mu
emus66821682emus
ends56528522ends
engs56121392engs
ens37245922e_ns
eons46638712eons
epos66723732epos
eras45441502eras
ergs55523812ergs
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282e_rs
es29048222e__s
eses45336102eses
ess36030882e_ss
etas46432272etas
eths76619522eths
eves76230462eves
ewes76328702ewes
exams14199082exams
exes116530812exes
eyas76427432eyas
eyes75837882eyes
fells85327382fells
felts85324542felts
fems96428702fems
films105617962films
flams105125012flams
flus75626542flus
gams76648882gams
gelds75118342gelds
gels56836102gel_s
gelts65924612gelts
gems75329112gems
germs85118872germs
geums85414112geums
glams85822932glams
glims87417672glims
gloms85219782gloms
glums84621422glums
gums75030942gums
gyms107514592gyms
halms105225212halms
hams96446132hams
hells85032042hells
helm95530022helm_
helos84928062helos
helps105219342helps
hems95534942hems
herms105626432herms
hims95230972hims
holms105117802holms
hums96831422hums
ilks87218572ilks
ills47030422ills
isms66213472isms
jams135231072jams
jells125522162jells
kelims1278912kelims
kelps115116422kelps
kelts95222632kelts
lams66552262lams
las37281472_las
leas45954182leas
lees45455882lees
legs56133692legs
leis45739602leis
leks85427602leks
lens46146492lens
les35663072_les
less45635102less
lets47147942lets
leys76430182leys
lis37162272_lis
lums65734242lums
malms95021552malms
melds84822382melds
mells75031332mells
mels65941532mel_s
melts74930102melts
mems85931502mems
moms86539482moms
mums85732772mums
neems77316292neems
neums75414252neums
nims66226882nims
noms65636402noms
ohms95514032ohms
olds55926572olds
oles46453472oles
oms56337512_oms
palms94921752palms
pams85641762pams
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
perms95524512perms
plums94619952plums
plus66324832plus
poms87037742poms
rams65950772rams
realms84913492realms
reams75729622reams
rems66237722rems
rims65936302rims
roms67038962roms
rums64833472rums
seams75731662seams
seems75525022seems
selfs85220242selfs
sells55134432sells
sels46345982sel_s
sims65737172sims
skelms12368022skelms
slams74927902slams
slims75423652slims
slums74623432slums
soms66239372soms
sums65837582sums
tams67247932tams
teams75726512teams
teems76019782teems
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692tel_s
terms75523472terms
toms68343492toms
ulus45622562ulus
velds95615582velds
vims95423312vims
welds94719162welds
wells85426192wells
welts85225192welts
whelms14377572whelms
yams95330732yams
yelks126413622yelks
yells85821942yells
yelps105712992yelps
ylems1039262ylems

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.0632836365.1
2DLD Change Limit298722250.95331345.2
3Display Results2252250.0464891.3
 (SQL Overall)1786912251.062168258.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.