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

204 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
retracts10111131(None) 
detracts11138831detracts
refracts13137381refracts
retraces101417271retraces
retracks14149101retracks
retract91318111retract_
retroacts1146281retroacts
attracts1047792attracts
detract101414632detract_
extracts1747622extracts
protracts1347022protracts
reacts83616602re__acts
redacts10510942re_dacts
redrafts1235602redrafts
reenacts1036992reenacts
reerects10319922reerects
refract121311602refract_
regrafts1235302regrafts
regrants9310012regrants
reracks132310532re_racks
restricts1138822restricts
retacks132210712ret_acks
retirants947322retirants
retrace91417342retrac_e
retraced111413022retraced
retracer101411882retracer
retracers11149552retracers
retrack131310722retrac_k
retracted12410952retracted
retractor11218512retractor
retractors12158582retractors
retrains8314532retrains
retreats8311412retreats
retroact10410002retroact_
tracts85019072__tracts
abstracts1346593abstracts
amtracks1696633amtracks
amtracs1198883amtrac_s
artefacts1443153artefacts
astricts1049463astricts
attract9511833attract_
bearcats1267023bearcats
betrays12127823betra_ys
bracts105617773__bracts
cataracts1345583cataracts
contracts132212013contracts
derats74625063de_ra_ts
destructs1245773destructs
detects104011093det_ects
detracted1357793detracted
detractor12147213detractor
detractors13147293detractors
detrains9411763detrains
distracts1249283distracts
enacts84012973_e_nacts
entrants8311753entrants
epacts105010393_e_pacts
erects84116183_e_rects
errants7410643_errants
eructs83610793_e_ructs
exacts15359613_e_xacts
extract16311013extract_
hatracks1737533hatracks
infracts1346623infracts
interacts11312123interacts
intrants8312863intrants
metrics11312363metric_s
metrists1039853metrists
outacts9310213out_acts
outraces102217863outraces
overacts1339653overacts
petrales10312983petrales
preacts113211363pre__acts
preenacts1345843preenacts
preerects1345413preerects
pretrains11410143pretrains
pretreats1146933pretreats
protract12510603protract_
racetracks1853003racetracks
react74634333re__act_
readapts1145583readapts
reattacks1543753reattacks
rebaits9312573re_baits
recants93217093re_cants
recasts93413533re_casts
recharts1337663recharts
recoats92616643recoa_ts
recrate92621663recra_te
recrates102420373recrates
recreants1146623recreants
recruits1036563recruits
rectrices1338873rectrices
redact9419043re_dact_
redbaits1135903redbaits
redirects12125103redirects
redraft11310573redraft_
redraws11218473redra_ws
redroots937753redroots
reejects17336083reejects
reelects103110883reelects
reenact9413003reenact_
reentrants1044663reentrants
reerect92915883reerect_
refaces123216743re_faces
refects124012743re_fects
reflects13288873reflects
refracted1557393refracted
refractor14156323refractor
refractors15156273refractors
refrains1139593refrains
reframes1338993reframes
refronts1137773refronts
regrades103212173regrades
regraft11310153regraft_
regrant8317323regrant_
regrate82618663regra_te
regrates92618403regrates
regreets9287853regreets
regrets83212923regr_ets
reheats104513523rehea_ts
rejects163910693re_jects
relaces93420883re_laces
relicts94414593re_licts
relucts9369673re_lucts
remnants1036843remnants
repacks15269543re_packs
repasts93611933re_pasts
repeats94316053repea_ts
replaces123114123replaces
replants102811243replants
reprices122913353reprices
reprints1039903reprints
rerack122513163re_rac_k
rerents73319423re_rents
reseats74319583resea_ts
resects94115593re_sects
respaces12311043respaces
respects1247703respects
restacks1438093restacks
restarts8310873restarts
restrains9311623restrains
restraints1056603restraints
restrict10313633restrict_
retack122612823ret_ac_k
retags73414303ret_a_gs
retails74718973ret_ails
retains74522253ret_ains
retakes113718863ret_akes
retapes93917423ret_apes
retardants1144143retardants
retards85015003ret_ards
retargets1045303retargets
retaste72313133ret_aste
retastes82212903ret_astes
retaxes143615093ret_axes
reteach1237413reteac_h
reteaches1437123reteaches
reteams9339563retea_ms
retears72814923retea_rs
retests73813853ret_ests
retints74717013ret_ints
retirant8313593retirant_
retorts76016513ret_orts
retracing12313293retracing
retracked1657453retracked
retractile1246253retractile
retracting13311933retracting
retraction121310533retraction
retractions13910353retractions
retrain7615423retra_in
retral64419743retra__l
retrally11310523retrally
retreads937823retreads
retreat7317533retreat_
retrials8510823retrials
retries74129073retr_ies
retrims93612373retr_ims
retroacted1366133retroacted
retrodicts1344483retrodicts
retrofits1245353retrofits
retropacks1852493retropacks
retros63820193retr__os
retwists1135603retwists
rewraps12136563rewra_ps
rewrapt12138113rewrapt_
ricracs1136363ricrac_s
seracs84418573se_rac_s
setbacks1686303setbacks
straits74916323_straits
subtracts1346363subtracts
tacts76524123__t_acts
terraces102712253terraces
tetracid1147263tetracid
tetracids1245933tetracids
tetrads82910193tetra_ds
tetrarchs14104303tetrarchs
tetras63017623tetra__s
titrants838483titrants
traces85329933__traces
tracks124818843__tracks
tract75635713__tract_
traits65121983__traits
untracks1437523untracks
wetbacks1974983wetbacks

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622047.79618748.3
3Display Results2042040.0802550.0
 (SQL Overall)1786912048.31221498.0
 
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.