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

346 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
retraces10141727(None) 
retrace91417341retrace_
retraced111413021retraced
retracer101411881retracer
retracers11149551retracers
retracks14149101retracks
retracts101111311retracts
detracts11138832detracts
outraces102217862outraces
petrales10312982petrales
recrates102420372recrates
rectrices1338872rectrices
refaces123216742re_faces
refracts13137382refracts
reframes1338992reframes
regrades103212172regrades
regrates92618402regrates
relaces93420882re_laces
replaces123114122replaces
reprices122913352reprices
reracks132310532re_racks
respaces12311042respaces
retacks132210712ret_acks
retakes113718862ret_akes
retapes93917422ret_apes
retaxes143615092ret_axes
reteaches1437122reteaches
retrack131310722retrac_k
retracked1657452retracked
retract91318112retrac_t
retracted12410952retracted
retrains8314532retrains
retries74129072retr_ies
retroacts1146282retroacts
terraces102712252terraces
traces85329932__traces
aerates74627493ae_rates
amtracks1696633amtracks
amtracs1198883amtrac_s
anthraces1448893anthraces
attracts1047793attracts
bedrapes1386963bedrapes
berakes134815773be_rakes
berates94126873be_rates
betakes134212523bet_akes
betrayed1436303betrayed
betrayer1345643betrayer
betrayers1445013betrayers
betrays12127823betra_ys
boraces113716853_boraces
braces108427773__braces
catfaces1536963catfaces
cerates95428253ce_rates
cetanes9315133cet_anes
citrates102315093citrates
defaces133213403de_faces
degrades11269923degrades
depraves1436873depraves
derates84028893de_rates
detaches1439653det_aches
detract101414633detrac_t
detracted1357793detracted
detrains9411763detrains
detrudes1036203detrudes
earaches13411303_earaches
effaces15277273_effaces
embraces14128873embraces
enfaces122110913_enfaces
enlaces92313393_enlaces
enrages83114853_enrages
entrances11310953entrances
erases64425403_e_rases
etapes85415293_et_apes
ethanes103713513_ethanes
extracts1747623extracts
ferrates113013423ferrates
fetiales11319613fetiales
footraces1446713footraces
gentrices1258913gentrices
graces94523493__graces
hatracks1737533hatracks
headraces1546613headraces
heretrices1546303heretrices
hyraces1537913_hyraces
iterances1148903iterances
iterates81317823iterates
lettuces1043503lettuces
matrices12312083matrices
menaces112715523me_naces
merces105720743me_r_ces
metages102714973met_ages
metates92720013met_ates
meterages1248183meterages
methanes133812163methanes
metres85121563metr__es
metrics11312363metric_s
mistraces13312293mistraces
nitrates82516223nitrates
oratrices1145833oratrices
outfaces132311393outfaces
outpaces122411943outpaces
outrace92418553outrace_
outraced112414203outraced
outrages92215933outrages
outrances112912113outrances
outrates82421373outrates
outraves112313833outraves
peaces106324083pe__aces
peerages1189893peerages
petrale9312623petrale_
prefaces15311063pre_faces
preplaces1578743preplaces
preprices1569263preprices
prerace11414123pre_race_
pretapes122811533pret_apes
pretences132312613pretences
pretrains11410143pretrains
pretravel1444123pretravel
protracts1347023protracts
races74943243___races
racetracks1853003racetracks
reaches123423203re__aches
reacts83616603re__acts
reales64934123re__ales
reargues936713reargues
reattaches1543563reattaches
reattacks1543753reattacks
reaves94127573re__aves
reawakes15348073reawakes
rebates95123183re_bates
rebranches1745193rebranches
recanes93222263re_canes
recces10614913re__cces
reclames12310893reclames
recrate92621663recrate_
recrated112918603recrated
recreances1446503recreances
recreates11313363recreates
rectorates12410363rectorates
redacts10510943re_dacts
redates83423873re_dates
redrafts1235603redrafts
redrawer1235313redrawer
redrawers1344353redrawers
redraws11218473redra_ws
redries83721713redr_ies
redrives122610393redrives
reduces10513343re_duces
redwares1239053redwares
reembraces1643893reembraces
reenacts1036993reenacts
reentrances1345173reentrances
reerects10319923reerects
reface113616353re_face_
refaced133713573re_faced
refences13311843refences
reflates113115663reflates
refract121311603refrac_t
refracted1557393refracted
refrains1139593refrains
reframe1239393reframe_
reframed1437853reframed
refries104419733refr_ies
regales83520793re_gales
reggaes948883regga_es
reglazes1846793reglazes
regrade92612033regrade_
regraded113410763regraded
regrafts1235303regrafts
regrants9310013regrants
regrate82618663regrate_
regrated102816333regrated
reimages1138373reimages
reiterates10412003reiterates
rejoices17287663rejoices
relace83122153re_lace_
relaced103517213re_laced
relates73731433re_lates
relaxes143215323re_laxes
releases8313343releases
reliances1139623reliances
remakes134116173re_makes
remates93827113re_mates
renames92418053re_names
rennases848983rennases
repacks15269543re_packs
repaves123513653re_paves
rephrases1447413rephrases
replace113214283replace_
replaced133211393replaced
replacer12279743replacer
replacers13266833replacers
replates102919273replates
reprice113212833reprice_
repriced132610543repriced
reprises102615463reprises
reproaches1755433reproaches
reprobes121910293reprobes
reprocess1345933reprocess
reproves132011473reproves
rerack122513163re_rac_k
reracked15169123re_racked
reraise7316313re_raise
reraises8415643re_raises
rerebraces1445033rerebraces
rerises73525883re_rises
resales74724903re_sales
rescales103414573rescales
reshapes1338803reshapes
reshaves1438733reshaves
reslates83619503reslates
respace11310913respace_
respaced1338503respaced
respades1139853respades
restacks1438093restacks
restages92815773restages
restates83423433restates
restrains9311623restrains
restricts1138823restricts
restrikes1339413restrikes
restrives12310663restrives
resurfaces1543013resurfaces
retables101712673retables
retack122612823ret_ac_k
retacked15169273ret_acked
retackles1545363ret_ackles
retags73414303ret_a_gs
retails74718973ret_ails
retains74522253ret_ains
retake104718533ret_ake_
retaken113911803ret_aken
retaker113714313ret_aker
retakers123511133ret_akers
retape83917683ret_ape_
retaped103814283ret_aped
retardates1146433retardates
retarded102410753retarded
retarder9229433retarder
retarders10227573retarders
retards85015003ret_ards
retarget9312743retarget
retargets1045303retargets
retastes82212903retastes
retaxed153512233ret_axed
retches123318513ret_ches
reteach1237413reteac_h
reteamed1138013reteamed
reteams9339563retea_ms
retears72814923retea_rs
retenes76324623ret_enes
reticles103912483reticles
reties65436193ret__ies
retiles74426993ret_iles
retimes95020173ret_imes
retines75134673ret_ines
retinues85113153retinues
retirants947323retirants
retirees84611653retirees
retires74726213ret_ires
retitles83612593retitles
retouches1445903retouches
retracing12313293retracing
retractor11218513retractor
retractors12158583retractors
retrain7615423retra_in
retrained10411313retrained
retrainee9511163retrainee
retrainees1046393retrainees
retral64419743retra__l
retrally11310523retrally
retreaded1137053retreaded
retreads937823retreads
retreated10312623retreated
retreater9310203retreater
retreaters1047543retreaters
retreats8311413retreats
retrenches1545903retrenches
retrials8510823retrials
retried84419153retr_ied
retrieves1265653retrieves
retrims93612373retr_ims
retroact10410003retroac_t
retroacted1366133retroacted
retrocede1245403retrocede
retrocedes1344943retrocedes
retropacks1852493retropacks
retrorse837623retrorse
retros63820193retr__os
retunes76918403ret_unes
returnees9396113returnees
retypes12308623ret_ypes
revoices13278993revoices
rewakes144614983re_wakes
rewaxes173911333re_waxes
reweaves1436603reweaves
rewraps12136563rewra_ps
rewrites11311063rewrites
ricracs1136363ricrac_s
rotaries8315693rotaries
rotates72819773rot_ates
rubaces1139313r_ubaces
seracs84418573se_rac_s
serapes95218103se_rapes
serrates82617023serrates
setbacks1686303setbacks
strafes104516003_strafes
strakes114218073_strakes
subraces12313033subraces
taces76237803__t_aces
tectrices1346253tectrices
tenaces92814513te_naces
terces83921413te_r_ces
terrace93311843terrace_
terraced11318123terraced
terranes82514433terranes
terrases82111483terrases
tetracid1147263tetracid
tetracids1245933tetracids
tetrads82910193tetra_ds
tetramer1046813tetramer
tetramers1146463tetramers
tetrarchs14104303tetrarchs
tetras63017623tetra__s
tetrodes939093tetrodes
thoraces13118943thoraces
titrates82314663titrates
trace75829613__trace_
traced94821583__traced
tracer84820233__tracer
tracers94917843__tracers
tracks124818843__tracks
tracts85019073__tracts
trades75724503__trades
trances93919643__trances
trapes85024463__trapes
traves94222743__traves
trices84826333__trices
truces84916333__truces
unbraces12229413unbraces
untraced112413243untraced
untracks1437523untracks
urethanes1245163urethanes
vendaces1457183vendaces
vertices13612283vertices
wetbacks1974983wetbacks
wetwares1445953wetwares

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.1731032896.0
2DLD Change Limit1461623467.95318378.2
3Display Results3463460.1402471.4
 (SQL Overall)1786913468.26621617.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.