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

251 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
deled7532654(None) 
deed65340901de_ed
deked115718531deked
dele56843081dele_
delead84112341delead
deles65139251deles
delved114112751delved
dewed105020301dewed
doled75430911doled
dueled84813661dueled
abled86926832abled
addled94112522addled
ailed66240282ailed
aneled74719282aneled
axled135315812axled
baled85436442baled
belied95022162belied
belled94626192belled
belted94020632belted
bled75729312_bled
bleed85019802bleed
ceded96118562ceded
ceiled94114952ceiled
celeb9314872celeb
celled94420322celled
cered85227442cered
coled85540762coled
dale55643982dale_
daledh1133742daledh
dales66439742dales
dared75935012dared
dated75530992dated
dawed106222812dawed
dazed165919362dazed
dead65434242de_ad
dealer74122142dealer
deaned84620452deaned
deaved114916552deaved
decked145217622decked
dee47665822de_e_
deeded94615542deeded
deeds75423762de_eds
deedy104315892de_edy
deem75432892de_em
deemed104713062deemed
deep76031882de_ep
deer56739022de_er
dees56356632de_es
deet57356582de_et
defend113910492defend
defer94619752defer
defied115016382defied
defiled124013102defiled
deflea1037442deflea
deiced104214482deiced
deke95228762deke_
dekes105224452dekes
del46752752del__
delated93722872delated
delay94820632delay
delayed123310762delayed
deleads9379702deleads
delete73620702delete
deleted93314912deleted
delf85436572del_f
delfs94918672delfs
delft95623322delft
deli55631292del_i
delimed11310722delimed
delis64928542delis
dell56938202del_l
dells66630942dells
delly96023872delly
dels56745472del_s
delt57855272del_t
delta66117772delta
delts65731792delts
delude81910672delude
deluded10158762deluded
deluged10167412deluged
delve96018262delve
delver104913492delver
delves104917082delves
deme76536282deme_
demes86032692demes
demoed103713442demoed
dene56643412dene_
denes65639722denes
denied84318632denied
denned84215632denned
dented84120512dented
depend103510922depend
dere56845902dere_
desex13311982desex
deter65028042deter
deuced104112122deuced
devel94217122devel
develed123611932develed
deviled124112182deviled
dexes135224512dexes
dialed84716452dialed
diced95824682diced
died66137852d_ied
dieted83115492dieted
diked115024682diked
dilled84122222dilled
dined76431992dined
dirled84514902dirled
dived106321372dived
doiled84817292doiled
dole56550002dole_
doles67843752doles
dolled83518072dolled
domed95423262domed
doped95326712doped
dosed76626912dosed
doted75227072doted
dowed104632612dowed
doweled12269772doweled
dozed165619352dozed
dreed75222842dreed
dried75321382dried
duded84417132duded
dueler74213682dueler
duelled9359752duelled
dueted84113592dueted
duked115218462duked
dulled84719422dulled
duped95118322duped
dured75025402dured
dwelled12337592dwelled
dyed96720762d_yed
dyked145310952dyked
edged85514532edged
eked96718022_eked
eld46733792_el_d
exed125420592_exed
eyed86623232_eyed
feed84538902fe_ed
felid94717172felid
felled103720302felled
felted103714652felted
feted94420932feted
feued94715662feued
filed95331902filed
fled85429772_fled
fueled104913602fueled
geed65435502ge_ed
geld65828432gel_d
gelded94512112gelded
gelee63626982gelee
gelid74916982gelid
gelled84718892gelled
gled65631142_gled
gleed75320572gleed
haled95335822haled
healed105121442healed
heed86437602he_ed
heeled104018412heeled
heiled104415612heiled
held85330402hel_d
helled104024702helled
helmed124513692helmed
helped124714152helped
helved134313702helved
hewed125619432hewed
hexed165615762hexed
holed95634132holed
idled74915212idled
isled64615992isled
jeed125428502je_ed
jelled144916062jelled
jewed165114832jewed
keeled114414272keeled
kelep116014562kelep
kelped13449552kelped
keyed1369392keyed
led46254552__led
meed74934702me_ed
meld75830472mel_d
melded104714712melded
melee73729102melee
melled95023022melled
melted94219062melted
meted85424432meted
mewed115218012mewed
mewled123710052mewled
modeled1139462modeled
muled85824432muled
naled65525052naled
need54934152ne_ed
ogled75915962ogled
oiled64429472oiled
paled85538722paled
pealed95322812pealed
peed76239182pe_ed
peeled94119712peeled
pele65539552pele_
peles75738082peles
pelted94617762pelted
piled85232992piled
pled75231432_pled
poled84934842poled
puled84926522puled
reded74829122reded
reed55549622re_ed
reeled74725532reeled
refed93921922refed
relend76116452relend
relet54749822relet
relied74926232relied
repled93319782repled
rewed95425452rewed
riled65833252riled
ruled65822522ruled
sealed74328362sealed
seed55549482se_ed
seeled73922092seeled
selfed10310912selfed
sered65737292sered
sewed95325162sewed
sexed136618542sexed
sled55334372_sled
soled65835172soled
teed55439262te_ed
tele45040872tele_
teledu737302teledu
teles54536002teles
telex125214822telex
tewed94718532tewed
tiled64832942tiled
toled65934922toled
unled64021072unled
vealed103916322vealed
veiled103714542veiled
veld85323202vel_d
vexed165713112vexed
voled95323722voled
waled94330992waled
wedeled1237782wedeled
weed85637512we_ed
weld84727732wel_d
welded114013382welded
welled103820212welled
welted103715822welted
wiled95231552wiled
wyled124611842wyled
yeld811423872yel_d
yelled104116252yelled
yelped12439362yelped
yodeled1236862yodeled

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538002511.82629463.3
3Display Results2512510.0803137.5
 (SQL Overall)1786912512.21980527.7
 
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.