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

250 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
editors83942(None) 
editor738661editor_
auditors947612auditors
coeditors1245802coeditors
creditors1245862creditors
debtors1038532debtors
editions9310402editions
edits65819032edit__s
eductors1135982eductors
evictors13276852evictors
excitors1746092excitors
genitors937422genitors
heritors11310902heritors
mediators1248922mediators
suitors73012492suitors
abators94413083abators
actors81016763_actors
adaptors1145253adaptors
additory1344263additory
adios65822863adi_o_s
adipous1037183adipous
adits66523713adit__s
advisors12143903advisors
aerators8315613aerators
auditor837313auditor_
auditory1245703auditory
aviators11169903aviators
bailors93212413bailors
baiters94619303baiters
bettors93312473bettors
biters83925243_biters
cantors94620753cantors
captors113914983captors
castors94919443castors
chitons122611913chitons
citers85022983_citers
clitoris1047873clitoris
coeditor1145723coeditor_
creditor1145893creditor_
daters74827373_daters
datos65222783_dato_s
debtor938333debtor_
decors94017773_decors
dedicators1447743dedicators
deicers103612733deicers
deiform1336683deiform
deities82621923deities
delators92314823delators
depictors1465943depictors
deters74724683_deters
detours858043_detours
deviators1358533deviators
devisors12347253devisors
diatoms1039073_diatoms
dicers94720743_dicers
dicots94915793_dicots
didoes85716963_didoes
didos76820813_dido_s
dieters83216433_dieters
dikers114418793_dikers
dilators93213193_dilators
dilutors9306653_dilutors
dimers94321093_dimers
dinars75417563_dinars
diners75525953_diners
dinos65428063_dino_s
diols65521013_di_ols
distort81120333_distort
distorts91112353_distorts
ditas65923673_dit_as
dites66339153_dit_es
dithers114016153_dithers
dits56450523_dit__s
dittos74111973_dittos
ditzes163212423_ditzes
divers105024963_divers
divots104712203_divots
doctors1039993doctors
dolors75115313_dolors
donors75115793_donors
doors65022133_d_oors
dors56747603_d__ors
doters74423913_doters
easters75125683easters
eaters65535953e_aters
ecotours1044463ecotours
eddoes8199143ed_does
edgers84413913ed_gers
edibles1048003edibles
edicts94911703edi_cts
edifiers12336673edifiers
edifies113012283edifies
ediles74016983edi_les
edit54934863edit___
edited83913673edit_ed
editing9313133editing
edition8310853edition
editorial1047313editorial
editorials1144523editorials
editorship1654143editorship
editress944933editress
editrix1543643editrix
educators1246993educators
eductor1035863eductor_
eiders74321363e_iders
eidos65817753e_ido_s
eikons1038503e_ikons
ejectors17328663ejectors
elaters74420193elaters
electors103013843electors
elicitors1145803elicitors
elites66027123elit_es
elixirs1443543elixirs
emirs76116163emi__rs
emits75421473emit__s
emitters10349643emitters
emoters94712873emoters
enactors1038453enactors
enamors939123enamors
endites83717063endit_es
enters64425643e_nters
ephors11311403e_phors
epigons1048183epigons
epilators1149433epilators
epilogs1076583epilogs
epimers11109493epimers
epitome1157743epitome
epitomes1257713epitomes
epitope1147053epitope
epitopes1246973epitopes
equators1737473equators
erectors103514253erectors
errors63311313e_rrors
esters64627733e_sters
estops84011223e_stops
evertors1138953evertors
evictor12346363evictor_
evites94916473evit_es
exactors1737013exactors
exciters1736323exciters
excitons1746043excitons
excitor1645993excitor_
exilers14419733exilers
exits125515913exit__s
expeditors2043643expeditors
expiators1846803expiators
extols1337683e_xtols
extort13513973e_xtort
extorts1447753e_xtorts
factors12912123factors
faitours1134263faitours
fetors91014473_fetors
foetors1039763foetors
gaiters83516543gaiters
gators74115833_gators
genitor837273genitor_
goiters84014443goiters
guitars8116863guitars
hectors123513263hectors
heritor10310563heritor_
idioms956413idi_oms
idiots768643idi_ots
ignitors9135513ignitors
indictors1247613indictors
inditers93311053inditers
jailors14328753jailors
janitors1536853janitors
kiters105218593_kiters
lectors93415763lectors
legators92811033legators
levators11249283levators
lictors93212593lictors
liters65429883_liters
loiters74116613loiters
mediator1139043mediator_
mediatory1546433mediatory
medicos12339833medico_s
meditators1346263meditators
mentors9314993mentors
minors85117103_minors
miters84328783_miters
monitors10310823monitors
motors84616603_motors
negators92411173negators
nestors73614973nestors
niters64624213_niters
nitons64614903_nitons
nitros64214123_nitros
odious749933odi_ous
odors64514283od__ors
orators7313823orators
pastors94119003pastors
pediform1645183pediform
pitons85319043_pitons
predators12310083predators
predictors1547263predictors
pretors9316803pretors
priors83914483pri_ors
quittors17155413quittors
radiators1049323radiators
raptors94213353raptors
reactors103212283reactors
realtors82811683realtors
reciters102613113reciters
rectors93520513rectors
redactors1247533redactors
redtops1037373red_tops
reductors1246523reductors
relators83316123relators
remittors11256283remittors
resistors947993resistors
revisors11379063revisors
rhetors1038513rhetors
rigors72813713_rigors
rotors64917953_rotors
sailors73213723sailors
sartors7314963sartors
sectors93116443sectors
seditions1039013seditions
seditious1046493seditious
seisors73212833seisors
seizors16329003seizors
senators8312953senators
seniors73413613seni_ors
servitors1245203servitors
sitars65417593_sitars
smiters93414363smiters
spinors939423spinors
stators73915583stators
subeditors1363313subeditors
suiters73618883suiters
suitor63311053suitor_
tailors73212393tailors
tedious838443tedi_ous
titers64526413_titers
tors46157383___tors
traitors8310793traitors
tritons73814883tritons
tutors6912333_tutors
uniters73814173uniters
vectors123212593vectors
verditers1344993verditers
viators102712023viators
victors123311183victors
vigors102911483_vigors
visitors1146433visitors
visors92912223_visors
vizors18328903_vizors
waiters104218623waiters
writers105513493writers

Search took 10 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 Filter1786911340270.186960704.3
2DLD Change Limit1340272508.82615185.5
3Display Results2502500.1261984.1
 (SQL Overall)1786912509.13819554.7
 
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.