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

171 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
retracting1331193(None) 
detracting1438711detracting
refracting1638731refracting
retracing12313291retrac_ing
retracking1738161retracking
retroacting1447281retroacting
attracting1346562attracting
extracting2047222extracting
protracting1646932protracting
reacting113317892re__acting
recrating121318792recra_ting
redacting13612302re_dacting
redrafting1545962redrafting
reenacting1357352reenacting
reerecting1339972reerecting
regrafting1545992regrafting
regranting1238322regranting
regrating111316212regra_ting
reracking1639312re_racking
restricting1449302restricting
retacking1658972ret_acking
retasting102513412ret_asting
reteaching1636022reteaching
retractile1246252retractile
retraction121310532retraction
retractions13910352retractions
retraining11310242retraining
retreating111414772retreating
abstracting1645183abstracting
aerating92821003ae_ra_ting
astricting1357833astricting
berating113220763be_ra_ting
betraying1537713betra_ying
contracting16610473contracting
derating103222283de_ra_ting
deratting1139513de_ratting
destructing1546113destructing
detaching1637263det_aching
detecting13259983det_ecting
detraction13138583detraction
detractions14118273detractions
detractive1647373detractive
detraining1267673detraining
distracting1569253distracting
enacting11311363_e_nacting
erecting112415063_e_recting
eructing112110173_e_ructing
exacting1838523_e_xacting
infracting1647353infracting
interacting14411713interacting
iterating10314253itera_ting
metricating1647363metricating
nitrating10312673nitra_ting
outacting1239213out_acting
outracing12912163outrac_ing
outrating10916403outra_ting
overacting16310913overacting
preacting142412533pre__acting
preenacting16125373preenacting
preerecting1646143preerecting
pretasting13239283pret_asting
pretraining1446503pretraining
pretreating1448893pretreating
reaching143317203re__aching
readapting1445153readapting
reattaching1743123reattaching
reattacking1843303reattacking
rebaiting12311643re_baiting
rebating112418343re_ba_ting
rebranching1943383rebranching
recanting122414823re_canting
recasting122414233re_casting
recharting1637213recharting
recoating121317463recoa_ting
recreating131214583recreating
recruiting1347903recruiting
redating102620173re_da_ting
redbaiting1446263redbaiting
redirecting1545613redirecting
redrawing1437213redra_wing
reejecting2045813reejecting
reelecting1338783reelecting
refacing142512813re_fac_ing
refecting152413353re_fecting
reflating132514713refla_ting
reflecting1638823reflecting
refractile1544143refractile
refraction15137903refraction
refractions16127723refractions
refractive1846693refractive
refraining1437263refraining
reframing1538623refra_ming
refronting1437273refronting
regrading121210203regra_ding
regreeting1237343regreeting
regretting1237783regretting
reheating132314913rehea_ting
reiterating12410493reitera_ting
rejecting192211153re_jecting
relacing112516043re_lac_ing
relating92725443re_la_ting
relocating13310873relocating
relucting1239773re_lucting
remating112322423re_ma_ting
repacking1838283re_packing
repasting122312843re_pasting
repeating122618983repea_ting
replacing142210163replac_ing
replanting1338523replanting
replating122217403repla_ting
repricing14310473repric_ing
reprinting131510583reprinting
reproaching1944303reproaching
reraising10313773re_raising
rerenting102617663re_renting
rerouting10311873re_routing
reseating102421533resea_ting
resecting122816483re_secting
reslating102516993resla_ting
respacing1438893respac_ing
respecting1549883respecting
restacking1737183restacking
restarting11310663restarting
restating102319413resta_ting
restraining1247533restraining
retackling1744433ret_ackling
retagging1236033ret_agging
retailing103214733ret_ailing
retaining102114733ret_aining
retaking133114283ret_a_king
retaping113012553ret_a_ping
retarding111110653ret_arding
retargeting1343933retargeting
retaxing162311333ret_a_xing
retching143412173ret__ching
reteaming122110443retea_ming
retearing102214253retea_ring
retesting102614603ret_esting
retinting102215253ret_inting
retorting10613273ret_orting
retouching1644693retouching
retract91318113retract___
retracted12410953retract_ed
retractor11218513retract_or
retractors12158583retractors
retracts101111313retract__s
retrain7615423retra__in_
retrains8314533retra__ins
retreading12128483retreading
retrenching1743913retrenching
retrieving1445293retrieving
retrimming1544263retrimming
retroaction1347363retroaction
retroactions1447073retroactions
retroactive1645823retroactive
retroceding1544133retroceding
retrodicting1654463retrodicting
retrying122410453retr__ying
retting83425883ret___ting
retwisting1445633retwisting
rewrapping1843343rewrapping
rewriting13310413rewr_iting
rotating92614553rot_a_ting
serrating10513213serra_ting
subtracting1645273subtracting
terracing1237703terrac_ing
tetracaine1245193tetracaine
titrating10310113titra_ting
tracing103720153__trac_ing
tracking153715463__tracking
untracking1746933untracking

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 Filter1786911406030.453394461.4
2DLD Change Limit1406031718.15617239.2
3Display Results1711710.0931838.7
 (SQL Overall)1786911718.70220534.5
 
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.