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 “detoxicates” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
detoxicates215406(None) 
detoxicate2054481detoxicate_
detoxicated2253491detoxicated
detoxicants2152092detoxicants
intoxicates2054442intoxicates
decorticates17124333decorticates
dedicates13311693de__dicates
defoliates1446333defoli_ates
delicates12314313de__licates
denominates14167203denominates
detonates10310433deto__nates
detoxicant2053483detoxica_nt
detoxicating2353863detoxicating
detoxication2246203detoxication
detoxications2355653detoxications
detoxifies2143603detoxi_fies
intoxicate1955003intoxicate_
intoxicated2154023intoxicated
metricates1449113met_ricates
catholicates1973264catholicates
certificates1992904certificates
deactivates1744394deactivates
deaminates1349384de_aminates
debilitates1444474debilitates
decapitates1655644decapitates
decimates14410694de__cimates
decollates13137154deco_llates
decorates12314744deco__rates
decorticate16134634decorticate_
decorticated18144164decorticated
dedicate12312804de__dicate_
dedicated14310254de__dicated
dedicatee13410344de__dicatee
dedicatees1445314de__dicatees
defalcates1644544de_falcates
defecates1538594de__fecates
defoliate1346994defoli_ate_
defoliated1545834defoli_ated
delaminates1456904delaminates
delicate11315494de__licate_
demarcates1545974de_marcates
demodulates1543754demodulates
denominate13167684denominate_
denominated15166254denominated
deoxidizes2843344de_oxidizes
depilates12310924de__pilates
depopulates1644034depopulates
deprecates1547284de_precates
depreciates1664614depreciates
deracinates1445864deracinates
derivates13310094de__rivates
derogates11310974dero__gates
desalinates1246214desalinates
desiccates1545384de_siccates
desolates10311794deso__lates
deteriorates1354444deteriorates
detonate9311194deto__nate_
detonated1138214deto__nated
detoxes1538804detox____es
detoxified2243084detoxi_fied
deviates12312734de__vi_ates
devoices14307414devo_ic__es
disintoxicates2471874disintoxicates
divaricates1743874divaricates
dominates12311744d__ominates
duplicates1546634d_uplicates
eradicates1348264_eradicates
explicates2196664_explicates
extricates1998244_extricates
intoxicants2063044intoxicants
loricates11310124__loricates
medicates14312114me__dicates
metricate1349914met_ricate_
metricated1547294met_ricated
negotiates1145154negoti_ates
oxidates1636334___oxidates
peroxidases2153054peroxidases
rededicates15115074rededicates
relocates11712934relo__cates
remotivates1644774remotivates
renominates13137804renominates
replicates1449454re_plicates
retaliates1049094retali_ates
sonicates11410384__sonicates
toxicants1843834__toxicants
toxicities1947284__toxicities
toxicoses1843604__toxicoses
tunicates11268744__tunicates
urticates1148894urt__icates
vellicates1545904ve_llicates
vesicates14119034ve__sicates

Search took 10 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 Filter1786911488190.470380193.6
2DLD Change Limit148819919.07616397.0
3Display Results91910.0461978.3
 (SQL Overall)178691919.59218629.2
 
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.