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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
dechlorinates195276(None) 
dechlorinate1853121dechlorinate_
dechlorinated2062351dechlorinated
chlorinates1645542__chlorinates
chlorinate1546123__chlorinate_
chlorinated1744493__chlorinated
dechlorinating2162183dechlorinating
dechlorination2053413dechlorination
dechlorinations2153113dechlorinations
unchlorinated1962043unchlorinated
chlorates142512274__chlor__ates
chlorinator1653364__chlorinator
chlorinators1753184__chlorinators
chlorines142512354__chlorin__es
chlorinities1754184__chlorinities
chlorites142311964__chlori__tes
decelerates1446794deceler__ates
decolorizes2345884decolori__zes
decorates12314744dec__or__ates
decorticates17124344dec__orticates
defibrinates18112724de_fibrinates
delaminates1456904de__laminates
denominates14167204de__nominates
desalinates1246214desal__inates
perchlorates1953384perchlor__ates
anchorites1547765anch_ori__tes
chlorate133112695__chlor__ate_
chlordanes1644515__chlor_danes
chlorides15289755__chlori__des
chlorinating1854445__chlorinating
chlorination1756245__chlorination
chlorinations1855535__chlorinations
chlorine133013305__chlorin__e_
chlorinity1853845__chlorinit_y
chlorins132612885__chlorin___s
chlorite133012845__chlori__te_
chordates1547685__ch_or_dates
chorines132917255__ch_orin__es
coordinates1444105__c_oordinates
coronates1110816925__c__oronates
culminates1447055__cul_minates
deaminates1349385de___aminates
debilitates1444475debil__itates
decaffeinated2361125decaffeinated
decapitates1655645dec__apitates
decarbonates1753915dec_arbonates
decelerate1347515deceler__ate_
decelerated1545925deceler__ated
decemvirates2052085dec_emvirates
decimates14410695dec____imates
declarants1343605dec_laran_t_s
declines113315805dec_l__in__es
decollates13137155dec__o_llates
decolonizes2345535decolo__nizes
decoloring1486315decolorin___g
decolorization26136415decolorization
decolorizations27136105decolorizations
decolorize2256065decolori__ze_
decolorized2445255decolori__zed
decolorizer2354595decolori__zer
decolorizers2453125decolori_zers
decontaminates19112975decontaminates
decorate11315195dec__or__ate_
decorated13312215dec__or__ated
decorticate16134635dec__orticate_
decorticated18144175dec__orticated
decrepitates1793085dec_repitates
defibrinate17112985de_fibrinate_
defibrinated19112575de_fibrinated
defoliates1446335de__foli_ates
dehydrates1844245de_hydr__ates
delaminate1347375de__laminate_
delaminated1545785de__laminated
delicates12314315de__l__icates
delineates1147125de__l__ineates
denominate13167685de__nominate_
denominated15166255de__nominated
deracinates1445865de__racinates
derivates13310105de____rivates
desalinate1146675desal__inate_
desalinated1345775desal__inated
detonates10310435de__to__nates
detoxicates2154065de__toxicates
dichlorvoses2161225dichlor_voses
dichroites1645145dichro_i__tes
dichromates1956075dich__romates
dimenhydrinates258555dimenhydrinates
doctorates1346215doc_tor__ates
dominates12311745d____ominates
echinate1359405_ech___inate_
echinated1546485_ech___inated
eclogites1245265_ec_logi__tes
eliminates1246975_e__liminates
ephorates1459165_eph_or__ates
excoriates1946325_e_xcori_ates
fluorinates1464615__fluorinates
loricates11310135____loricates
machinates1747325mach___inates
perchlorate1853755perchlor__ate_
peregrinates1553355pe_regrinates
reclinate11410025rec_l__inate_
recoinages1345395rec__o_inages
recriminates1654885rec_riminates
rectorates12410375rec_tor__ates
recultivates1753485recul_tivates
renominates13137805re__nominates

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901068.51314658.8
3Display Results1061060.0631682.5
 (SQL Overall)1786911068.98219894.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.