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

125 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
detracting143871(None) 
retracting13311931retracting
attracting1346562attracting
derating103222282de_ra_ting
deratting1139512de_ratting
destructing1546112destructing
detaching1637262det_aching
detecting13259982det_ecting
detraction13138582detraction
detractions14118272detractions
detractive1647372detractive
detraining1267672detraining
distracting1569252distracting
extracting2047222extracting
refracting1638732refracting
retracing12313292retrac_ing
retracking1738162retracking
retroacting1447282retroacting
abstracting1645183abstracting
aerating92821003ae_ra_ting
astricting1357833astricting
berating113220763be_ra_ting
betraying1537713betra_ying
contracting16610473contracting
deaerating12311563deaera_ting
debating123213733de_ba_ting
decanting132510633de_canting
decocting1538123de_cocting
decorating14312073decora_ting
decrypting1943213decrypting
dedicating1539143dedicating
deducting1436843de_ducting
defacing15238683de_fac_ing
defatting1436103de_fatting
defeating142311973defea_ting
defecating17237783defecating
defecting162510223de_fecting
deflating142610713defla_ting
deflecting1736503deflecting
defragging1742823defragging
defrauding1642923defrauding
defraying1735853defra_ying
defrocking2143153defrocking
defrosting1544493defrosting
degrading13137373degra_ding
dejecting20217793de_jecting
delating103119603de_la_ting
demarcating1745203demarcating
demasting1338453de_masting
denitrating13128333denitra_ting
deorbiting1445153deorbiting
departing1349513de_parting
depicting1537813de_picting
depraving1635973depra_ving
deprecating1777283deprecating
depurating1438643depura_ting
derailing112011313de_railing
deranging1238063de_ranging
desalting1138843de_salting
descanting1446923descanting
detailing112510413det_ailing
detaining112510473det_aining
detesting112610323det_esting
dethatching2142243dethatching
deticking1736043det_icking
detonating1248823detonating
detract101414633detract___
detracted1357793detract_ed
detractor12147213detract_or
detractors13147293detractors
detracts11138833detract__s
detrain8412253detra__in_
detrains9411763detra__ins
detruding1245193detr_uding
deuterating1347273deutera_ting
deviating14311083devia_ting
diffracting2143343diffracting
directing1338823d_irecting
disrating11714553disra_ting
districting1559003districting
drafting13339403d__rafting
dratting10389653d__ratting
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
protracting1646933protracting
reacting113317893re__acting
recrating121318793recra_ting
redacting13612303re_dacting
redrafting1545963redrafting
reenacting1357353reenacting
reerecting1339973reerecting
regrafting1545993regrafting
regranting1238323regranting
regrating111316213regra_ting
reracking1639313re_racking
restricting1449303restricting
retacking1658973ret_acking
retasting102513413ret_asting
reteaching1636023reteaching
retractile1246253retractile
retraction121310533retraction
retractions13910353retractions
retraining11310243retraining
retreating111414773retreating
serrating10513203serra_ting
sidetracking2052123sidetracking
subtracting1645273subtracting
terracing1237703terrac_ing
tetracaine1245193tetracaine
titrating10310113titra_ting
tracing103720153__trac_ing
tracking153715463__tracking
underacting1547523unde_racting
untracking1746933untracking

Search took 7 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.406440125.6
2DLD Change Limit1406031256.39022003.6
3Display Results1251250.0631984.1
 (SQL Overall)1786911256.85926052.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.