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 “editor” with Change Limit: [1] [2] [3]

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

275 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
editor73866(None) 
editors839421editors
auditor837312auditor
coeditor1145722coeditor
creditor1145902creditor
debtor938332debtor
edit54934862edit__
edited83913672edited
edition8310852edition
edits65819032edit_s
eductor1035862eductor
evictor12346362evictor
excitor1645992excitor
genitor837272genitor
heritor10310562heritor
mediator1139042mediator
suitor63311052suitor
abator84512713abator
actor71116073_actor
adaptor1034943adaptor
additory1344263additory
adios65822863adi_os
adit56443653adit__
adits66523713adit_s
advisor11134163advisor
aerator7314843aerator
auditors947613auditors
auditory1245703auditory
aviator10229663aviator
bailor83412603bailor
baiter84422553baiter
bettor83612223bettor
biter75030033_biter
cantor85621523cantor
captor104914603captor
castor84418533castor
chiton112612393chiton
citer74827333_citer
coeditors1245803coeditors
creditors1245873creditors
dater65332313_dater
dato56129943_dato_
datos65222783_datos
debtors1038533debtors
decor84717573_decor
dedicator1348253dedicator
defter104215923defter
deicer94114413deicer
deiform1336693deiform
deity94316773deit_y
delator83015023delator
depictor1355513depictor
deter65028043_deter
detour778193_detour
detox13310953_detox
deviator1248313deviator
devisor11357043devisor
dexter143810893dexter
dextro1436123dextro
diatom939453_diatom
dicer85426423_dicer
dicot85429093_dicot
dido66528193_dido_
didos76820813_didos
dieter73516773_dieter
diker105524553_diker
dilator82712783_dilator
dilutor8256013_dilutor
dimer85625603_dimer
dinar66319893_dinar
diner65632903_diner
dino56036753_dino_
dinos65428063_dinos
diol57329133_di_ol
direr64927073_direr
distort81120333_distort
dit47071333_dit__
dita56032523_dit_a
ditas65923673_ditas
ditch115015093_ditch
dite55547553_dit_e
dites66339153_dites
dither104417683_dither
dits56450523_dit_s
ditsy95612563_ditsy
ditto65315603_ditto
dittos74111973_dittos
ditty95019293_ditty
ditz146929513_dit_z
ditzy186513283_ditzy
diver94827803_diver
divot95723073_divot
doctor938993doctor
dolor67617963_dolor
donor64418193_donor
door56928513_d_oor
dor47253923_d__or
doter65428623_doter
easter65027983easter
eater54639843e_ater
ecotour944363ecotour
eddo63411803ed_do_
edger75215953ed_ger
edgier8469733edgier
edible969353edible
edict84722283edi_ct
edictal1046993edictal
edicts94911703edicts
edifier11309263edifier
edify12308563edi_fy
edile64819493edi_le
ediles74016983ediles
editing9313133editing
editions9310403editions
editorial1047313editorial
editrix1543643editrix
educator1147153educator
eductors1135983eductors
eider64624743e_ider
eidos65817753e_idos
eikon939463e_ikon
either94517423e_ither
ejector16378603ejector
elater64724203elater
elector93313253elector
elicitor1045773elicitor
elite56230183elit_e
elites66027123elites
elixir1333703elixir
emir65918703emi__r
emit65438423emit__
emits75421473emit_s
emitter93211083emitter
emoter85415193emoter
enactor938033enactor
enamor838753enamor
endite73817593endit_e
endited93512913endited
endites83717063endites
enter54726383e_nter
ephor10310013e_phor
epigon937963epigon
epilator1049243epilator
epilog976463epilog
epimer10109153epimer
epitome1157743epitome
epitope1147053epitope
epizoa1745013epizoa
equator1637483equator
erector93513813erector
error53712233e_rror
ester54727713e_ster
estop74312103e_stop
evertor1038723evertor
evictors13276853evictors
eviler94811893eviler
evite85317683evit_e
evited104013143evited
evites94916473evites
exactor1636623exactor
exciter1637753exciter
exciton1646083exciton
excitors1746093excitors
exiler134712183exiler
exit114428673exit__
exited144712523exited
exits125515913exit_s
expeditor1943823expeditor
expiator1747043expiator
extol1247893e_xtol
extort13513973e_xtort
factor11911453factor
faitour1034883faitour
fetor81214533_fetor
foetor939563foetor
gaiter73819503gaiter
gator64416033_gator
genitors937423genitors
goiter74116203goiter
guitar7117443guitar
hector113312653hector
heritors11310903heritors
idiom899963idi_om
idiot6718863idi_ot
idiots768643idiots
ignitor8125263ignitor
indictor1147463indictor
inditer83514233inditer
jailor13418573jailor
janitor1436483janitor
kiter95523213_kiter
lector83514983lector
legator83011133legator
levator10298963levator
lictor83610853lictor
liter54736343_liter
loiter64619173loiter
mediators1248923mediators
mediatory1546433mediatory
medico113711163medico_
medicos12339833medicos
meditator1246593meditator
mentor8414363mentor
minor74920063_minor
miter75734793_miter
monitor9310723monitor
motor75317293_motor
negator83010673negator
nestor63713423nestor
niter55028973_niter
niton55418283_niton
nitro54914353_nitro
odor55718093od__or
orator6314533orator
pastor84817483pastor
pediform1645183pediform
piton76121583_piton
predator11310053predator
predictor1447093predictor
pretor8315753pretor
prior74316173pri_or
quittor16285603quittor
radiator949203radiator
raptor83912823raptor
reactor93011653reactor
realtor73611353realtor
reciter94117263reciter
rector84019753rector
redactor1147023redactor
redtop937973red_top
reductor1156433reductor
relator74016363relator
remittor10316553remittor
resistor847673resistor
revisor10388733revisor
rhetor938063rhetor
rigor62714053_rigor
rotor55519733_rotor
sailor63113753sailor
sartor6313883sartor
sector83415933sector
sedater83713623sedater
sedition939333sedition
seisor63712343seisor
seizor15428533seizor
senator7313063senator
senior63214053seni_or
servitor1145063servitor
sitar54820543_sitar
smiter83616413smiter
spinor839943spinor
stator64015483stator
subeditor1263083subeditor
suiter64121813suiter
suitors73012493suitors
tailor63412503tailor
titer55430613_titer
tor39261683___tor
traditor945943traditor
traitor7310123traitor
triter65120593triter
triton63914893triton
tutor5712493_tutor
uniter64619143uniter
vector113212063vector
verditer1236223verditer
viator93211833viator
victor113210673victor
vigor92612423_vigor
visitor1046203visitor
visor82512833_visor
vizor173010093_vizor
waiter94321253waiter
whiter124316393whiter
writer94416513writer

Search took 7 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 Filter1786911127160.436409841.7
2DLD Change Limit1127162756.34617761.7
3Display Results2752750.0932957.0
 (SQL Overall)1786912756.87525991.4
 
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.