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

166 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
detract10141463(None) 
detracts11138831detracts
retract91318111retract
attract9511832attract
derat65044082de_ra_t
destruct1148382destruct
detach12310412det_ach
detect94217402det_ect
detracted1357792detracted
detractor12147212detractor
detrain8412252detrain
distract11313022distract
extract16311012extract
refract121311602refract
retrace91417342retrace
retrack131310722retrack
retracts101111312retracts
retroact10410002retroact
tract75635712__tract
abstract1249223abstract
amtrac10109123amtrac_
amtrack15107393amtrack
amtracs1198883amtracs
astrict9614793astrict
attracts1047793attracts
bearcat11611913bearcat
betray111511443betra_y
betrays12127823betrays
bewrapt14147133bewrapt
bract96332723__bract
cataract1249413cataract
contract122915633contract
dealt65234283de__alt
dearest83618673dearest
decant93524223de_cant
decoct11313783de_coct
decrypt1545703decrypt
deduct10610793de_duct
deface123113863de_face
defat95426693de_fa_t
defeat103817163defea_t
defect124816173de_fect
defiant11311923defiant
deflect13399973deflect
defrag1136463defra_g
defrags1236193defrags
defraud1243913defraud
defray1337643defra_y
defrays1436113defrays
defrock1744643defrock
defrost1139553defrost
defunct1345773defunct
degrade10229903degrade
deject164512843de_ject
delict94320333de_lict
demast9517063de_mast
deorbit1048173deorbit
depart94720563de_part
depict113514793de_pict
deprave1337073deprave
derail74218813de_rail
derate74531233de_rate
derats74625063de_rats
deray95024183de_ra_y
derays105514253de_rays
derrick1435803derrick
desalt7518313de_salt
descant104315593descant
destructs1245773destructs
detail74516433det_ail
detain74617383det_ain
detects104011093det_ects
detent73624483det_ent
detest74122843det_est
dethatch1742753dethatch
detick1339383det_ick
detracting1438713detracting
detraction13138583detraction
detractive1647373detractive
detractors13147293detractors
detrains9411763detrains
detrude936083detrude
deviant11311313deviant
dextral1577003dextra_l
dextran1586163dextra_n
dextrans1695983dextrans
didact10711203d_idact
diffract1744723diffract
direct93817333d_irect
distracts1249283distracts
distrait9414343distrait
district11413873district
draft95526683d__raft
drat56247833d__ra_t
enact73525363_e_nact
enrapt8313013_enrapt
entrant7318873entrant
epact94921533_e_pact
erect74129333_e_rect
errant6618733_errant
eruct74022353_e_ruct
exact143516933_e_xact
extracts1747623extracts
hatrack1638213hatrack
infract12610003infract
intact8314663int_act
interact10316473interact
intrant7318753intrant
iterant7317783iterant
metric10314673metric_
metrics11312363metrics
metrist9317063metrist
ostraca937823ostraca
outact8317203out_act
outrace92418553outrace
overact12315043overact
petrale9312623petrale
protract12510603protract
react74634333re__act
redact9419043re_dact
redraft11310573redraft
reenact9413013reenact
reerect92915883reerect
refracts13137383refracts
regraft11310153regraft
regrant8317323regrant
rerack122513163re_rack
restrict10313633restrict
retack122612823ret_ack
reteach1237413reteach
retirant8313593retirant
retraced111413023retraced
retracer101411883retracer
retraces101417273retraces
retracks14149103retracks
retracted12410953retracted
retractor11218513retractor
retrain7615423retrain
retral64419743retra_l
retreat7317533retreat
retroacts1146283retroacts
rewrapt12138113rewrapt
serac75925203se_rac_
seracs84418573se_racs
setback1567143setback
sidetrack1643453sidetrack
strait64025893_strait
strict84821043_strict
subtract1249583subtract
tact67349033__t_act
terrace93311843terrace
tetra53417953tetra__
tetracid1147263tetracid
tetrad73612053tetra_d
tetrads82910193tetrads
tetrarch13104783tetrarch
tetras63017623tetra_s
titrant7315193titrant
trace75829613__trace
track114823013__track
tracts85019073__tracts
trait56940843__trait
trapt76433393__trapt
underact11311513unde_ract
untrack1338703untrack
wetback1875613wetback

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.406440125.6
2DLD Change Limit1340271666.98319193.3
3Display Results1661660.0463608.7
 (SQL Overall)1786911667.43524033.8
 
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.