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

155 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
enactor93803(None) 
enactors1038451enactors
enactory1346141enactory
exactor1636621exactor
actor71116072__actor
coactor1139122coactor
eductor1035862eductor
ejector16378602ejector
elector93313252elector
enact73525362enact__
enacted10310642enacted
enacts84012972enact_s
enamor838752ena_mor
erector93513812erector
evictor12346362evictor
exacter1637402exacter
exactors1737012exactors
factor11911452_factor
nonactor1047772nonactor
reactor93011652reactor
redactor1147022redactor
reenactor1184352reenactor
senator7313072sena_tor
tractor9311332tractor
abator84512713aba_tor
actors81016763__actors
adaptor1034943adaptor
aerator7314843aera_tor
alastor739653alastor
anaphor1245653anaphor
anatto6139913anatto_
anattos7138453anattos
anchor113911973an_chor
benefactor1752513benefactor
cantor85621523_cantor
captor104914603_captor
castor84418533_castor
chantor123710313chantor
coactors1239473coactors
cofactor1545753cofactor
contactor1348433contactor
defector14277953defector
delator83015023dela_tor
depictor1355513depictor
detector11278323detector
detractor12147213detractor
doctor938993_doctor
donator8310263dona_tor
easter65027983e_aster
eater54639843e_a_ter
editor738663e_ditor
educator1147153educator
eductors1135983eductors
effector1644873effector
ejectors17328663ejectors
elater64724203ela_ter
electors103013843electors
electro92810033electro
elicitor1045773elicitor
emanator1047293emanator
enabler9299363enabler
enacting11311363enacting
enactive1338513enactive
enamors939123ena_mors
enamour945433enamour
enate54428153ena_t_e
enates64026433ena_tes
enatic8317563ena_tic
enation73419233enation
encore8314773en_c_ore
enter54726383en__ter
epact94921533epact__
epacts105010393epact_s
equator1637483equator
erecter93113393erecter
erectors103514263erectors
evacuator14114933evacuator
evertor1038723evertor
evictors13276853evictors
evocator1346573evocator
exact143516933exact__
exacta15337393exact_a
exactas16336433exactas
exacted1737303exacted
exacters1736773exacters
exaction1738953exaction
exactly1953823exactly
exacts15359613exact_s
exalter1437563exalter
excitor1645993excitor
executor1744833executor
extractor1846723extractor
factors12912123_factors
factory15108343_factory
fractur12135563fractur
functor1235203functor
gator64416033_ga_tor
genitor837273gen_itor
grantor84010933grantor
hector113312653_hector
impactor14265003impactor
inaction1039623inaction
indictor1147463indictor
inductor1146333inductor
infector13478853infector
infractor1465943infractor
injector17236933injector
janitor1436483janitor
knacker12307913knacker
lector83514983_lector
legator83011133lega_tor
levator10298963leva_tor
lictor83610853_lictor
locator93110423locator
menacer112610883menac_er
mentor8414363men__tor
nacho105414383_nacho_
nachos115014183_nachos
natter64420743_natter
neater64424313nea_ter
nectar838853_nectar
negator83010673negator
nestor63713423_nestor
nonactors1147873nonactors
nonfactor1445273nonfactor
orator6314533ora_tor
pastor84817483_pastor
praetor938973praetor
proctor11310433proctor
rancor8810373ranc_or
raptor83912823_raptor
reactors103212283reactors
realtor73611353realtor
rector84019753_rector
redactors1247533redactors
reductor1156433reductor
reenactors1294383reenactors
refractor14156323refractor
rejector17237723rejector
relator74016363rela_tor
retractor11218513retractor
sartor6313883_sartor
sector83415933_sector
selector1048613selector
senators8312953sena_tors
snacker133112603snacker
stator64015483sta_tor
tractors10312563tractors
traitor7310123traitor
unacted10312733unacted
unanchor1343093unanchor
varactor1345683varactor
vector113212063_vector
viator93211833via_tor
victor113210673_victor

Search took 8 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.390458182.1
2DLD Change Limit1340271556.86019537.5
3Display Results1551550.0463369.6
 (SQL Overall)1786911557.29624491.6
 
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.