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

142 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
reenact941301(None) 
preenact12410181preenact
reenacts1036991reenacts
coenact11311802coenact
enact73525362__enact
preenacts1345842preenacts
react74634332r_e_act
redact9419042r_edact
reeject16349622reeject
reelect911515632reelect
reenacted1236852reenacted
reenactor1184352reenactor
reerect92915882reerect
refract121311602refract
regnant8312842regnant
remnant9312642remnant
retract91318112retract
revenant11410282revenant
artefact1345183artefact
coenacts1246403coenacts
detract101414633detract
enacts84012973__enacts
epact94921533__epact
erect74129333ere__ct
exact143516933__exact
greenback1853443greenback
greenest9312623greenest
greenlet948513greenlet
greenlit945803greenlit
inexact1647413inexact
keenest11410963keenest
menace103216943_menace
overact12315043overact
pennant9312493pennant
preact103220393pre_act
preelect1249643preelect
preenacted1544973preenacted
preerect1259273preerect
pregnant1149883pregnant
reach105123883r_e_ach
reacts83616603r_e_acts
readapt1039743readapt
rebait8320403r_ebait
reboant9315093reboant
recant83228683r_ecant
recast83422773r_ecast
recency1438633recen_cy
recent83630853recen__t
rechart12314343rechart
recoat84024273recoa_t
recontact1347163recontact
redacts10510943r_edacts
redbait1039803redbait
redefect1446053redefect
redneck1445113redneck
redraft11310573redraft
reearn6612143ree_arn
reedit7617223ree_dit
reejects17336083reejects
reelects103110883reelects
reemit8717223ree_mit
reenacting1357353reenacting
reenactors1294383reenactors
reendow11285063reendow
reengage1045213reengage
reenjoy1743293reenjoy
reenlist8410363reenlist
reenter73217793reenter
reentrant947843reentrant
reentry1038033reentry
reerects10319923reerects
reest54938093ree__st
reface113616353r_eface
refect114319333r_efect
refence12312243refen_ce
reflect123913713reflect
refracts13137383refracts
regency1337363regen_cy
regent74127673regen__t
regna64614813regna__
regnal74812933regna_l
regnancy1444773regnancy
regraft11310153regraft
regrant8317323regrant
reheat94423943rehea_t
reindict1187533reindict
reinduct1176153reinduct
reinfect1346483reinfect
reinject1745543reinject
reject154116283r_eject
reknit10312533rekn_it
reknot10311733rekn_ot
relace83122153r_elace
relent64431853relen__t
relevant1149243relevant
reliant7319243reliant
relict83623903r_elict
reluct83916113r_eluct
remnants1036843remnants
renail65020763r_enail
renal55929513r_ena_l
rename82718813r_ename
renest64529713r_enest
rennase738713rennase
rennet64624853r_ennet
rent46661243r_en__t
repack142412163r_epack
repast83520633r_epast
repeat85127213repea_t
repent84728873repen__t
repentant1149323repentant
replace113214283replace
replant93318533replant
reptant92817073reptant
rerack122513163r_erack
rerent63832453reren__t
resat55139683r_esa_t
reseat64131493resea_t
resect84424703r_esect
reselect1059943reselect
resent63833623resen__t
resonant8410813resonant
respace11310913respace
respect11412033respect
restack1339433restack
restart7320033restart
retack122612823r_etack
reteach1237413reteach
retrace91417343retrace
retrack131310723retrack
retracts101111313retracts
retroact10410003retroact
revenants1246173revenants
rewrapt12138113rewrapt
reynard1135123reynard
setenant849933setenant
teenage8108053teenage
tenace82715693_tenace
tenant6322473_tenant
treenail846123treenail
veena81912323veena__
veenas91410413veena_s

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.423422437.4
2DLD Change Limit1340271426.76619808.9
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.24924650.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.