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

192 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
eely7772521(None) 
eel37946841eel_
eels46536741eels
eery76129621eery
rely75428951rely
seely84522631seely
ably99725132ably
aery77231682aery
agly86821802agly
ally76935642ally
beefy135313832beefy
beery105220122beery
bel57148462bel_
belay105021522belay
bell66237182bell
belly104625492belly
bels66142492bels
belt65754032belt
bevy127115222bevy
bey86645422be_y
cel56040552cel_
cell65031722cell
cels65534972cels
celt65646712celt
coly96940532coly
deedy104315892deedy
deeply1257012deeply
defy114921262defy
del46752752del_
delay94820632delay
dele56843082dele
delf85436572delf
deli55631292deli
dell56938202dell
delly96023872delly
dels56745472dels
delt57855272delt
demy105422852demy
deny86027122deny
dewy115419022dewy
dexy156118552dexy
dey77243372de_y
duly85323032duly
early85324122early
easy76224492easy
eddy93912092eddy
edgy94713532edgy
eek77935102ee_k
eerily92913562eerily
eggy96611852eggy
el26745292_el_
eld46733792_eld
elegy939302elegy
elf66138522_elf
elk76726122_elk
ell36735682_ell
ells46431352ells
elm57531742_elm
elmy95616792elmy
els37645722_els
emery104814332emery
emmy116013242emmy
enemy1059992enemy
envy10411252envy
espy969372espy
evenly1236992evenly
every115215452every
eyry106315882eyry
feebly1436652feebly
feel75233842feel_
feels85223042feels
fell76833072fell
felly114922802felly
felt75146932felt
ferly115517352ferly
fey95940882fe_y
feyly14429512feyly
fley106626852fley
fly97124952_fly
freely12310962freely
geeky134710732geeky
gel45642432gel_
geld65828432geld
gels56836102gels
gelt56448012gelt
gey75738302ge_y
gley85724652gley
heel75034222heel_
heels85625532heels
held85330402held
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
hey96741062he_y
holy106333432holy
idly85617322idly
illy76925332illy
inly75622212inly
jell117125872jell
jelly154218252jelly
keel85729472keel_
keels94622412keels
keenly1336372keenly
kelly124617022kelly
kelp105322802kelp
kelpy145110682kelpy
kelt85343192kelt
key105833332ke_y
leery85919132leery
levy106418502levy
ley66246812le_y
lily76730182lily
mealy104422182mealy
meekly1535192meekly
meetly1138672meetly
mel56047482mel_
meld75830472meld
mell64935612mell
mels65941532mels
melt65752892melt
melty104918362melty
merely111312592merely
moly96031912moly
needy94614692needy
nelly84618812nelly
newly114610202newly
oily77932252oily
only75319722only
paly95835532paly
peel65535612peel_
peels75226422peels
peery105719442peery
pele65539552pele
pelf97031452pelf
pelt67651082pelt
pily96132732pily
ply86323552_ply
poly96235152poly
redly94217202redly
reedy910020292reedy
reefy114217702reefy
reeky125416262reeky
reel45240532reel_
reels55333262reels
refly113914562refly
relay84424672relay
reply104015852reply
ruly76323142ruly
seedy94821532seedy
seel45042982seel_
seels55632822seels
seemly1138432seemly
seepy104717972seepy
sel38253322sel_
self75138292self
sell45840612sell
sels46345982sels
sexy146418022sexy
sly66228562_sly
steely93612572steely
teel46335802teel_
teels55726372teels
teeny85417882teeny
tel35647902tel_
tela45532972tela
tele45040872tele
tell44934702tell
telly84920822telly
tels46841692tels
ugly86012382ugly
vealy115817772vealy
veery115816252veery
vela75725542vela
veld85323202veld
very108025642very
waly105830902waly
weedy125115002weedy
weekly1635312weekly
weel75834082weel_
weeny115316162weeny
weepy134212592weepy
weld84727732weld
well75832042well
welly114620012welly
welt75547862welt
wetly114511712wetly
wily106428812wily
yeld811423872yeld
yelk115320002yelk
yell76028322yell
yelp95621352yelp

Search took 5 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.610292936.1
2DLD Change Limit298721923.4208734.5
3Display Results1921920.0932064.5
 (SQL Overall)1786911924.12343340.0
 
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.