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

124 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
chlorate13311269(None) 
chlorates142512271chlorates
chlorite133012841chlorite
chloracne1644512chloracne
chloral12169982chlora_l
chlorals13148032chlorals
chlordane1544912chlordane
chloride143310242chloride
chlorinate1546122chlorinate
chlorine133013302chlorine
chlorites142311962chlorites
cholate122114932ch_olate
chorale124313352ch_orale
chordate1448032ch_ordate
chromate15312782chromate
colocate12313442colocate
cultrate10310872cultrate
phorate12413362ph_orate
allocate10411023allocate
biforate1346903biforate
bilobate1247033bilobate
borate85026153__borate
calcarate1347703calcarate
calceate1239863calceate
calibrate1347743calibrate
califate13310483califate
calorie92716893calor_ie
calorize192712733calorize
calotte9510563calo_tte
calycate1537893calycate
carate84734003c__arate
castrate10313863castrate
celebrate1348083celebrate
celibate1259313celibate
cellmate1237873cellmate
celomata1296633celomata
cerate84829463c__erate
charade13129913ch_arade
chelate122914893ch_elate
chloracnes1744443chloracnes
chloralose1552783chloralose
chloramine1746113chloramine
chlordan1445493chlordan
chlordanes1644513chlordanes
chlordans1544893chlordans
chloric143410613chlor_ic
chlorid133211843chlor_id
chlorides15289753chlorides
chlorids14299673chlorids
chlorin123113003chlor_in
chlorinated1744493chlorinated
chlorinates1645543chlorinates
chlorines142512353chlorines
chlorins132612883chlorins
chloritic1657433chloritic
chloroses1447683chloroses
chlorotic1656983chlorotic
chlorous1339223chlorous
chocolate1647413chocolate
cholates132414763ch_olates
choragi1346683ch_oragi
choral115118493ch_ora_l
chorales133712883ch_orales
chorals124614113ch_orals
chordates1547683ch_ordates
chore105126763ch_or__e
chorine123218363ch_orine
chorten122811303ch_or_ten
chortle124210443ch_ortle
chromates16313113chromates
chromite15310833chromite
ciliate9514603cil_iate
ciliolate1145973ciliolate
cirrate92413493c_irrate
citrate92216803c_itrate
clavate1238713c_lavate
climate11312833c_limate
clodpate1344083c_lodpate
coelomate1398113coelomate
cohobate1547013cohobate
collate92919683col_late
collocate1348673collocate
colocated1439613colocated
colocates13312853colocates
colorable1348243colorable
colorado1145933colorado
colorant10414723colorant
colorants1149863colorants
colorize192314203colorize
comate104124843c__omate
cordate10315223c__ordate
coronate103018213coronate
corotate102813933corotate
corporate13410903corporate
crate76537403c___rate
culotte976893culo_tte
cultrated1248223cultrated
curate85226243c__urate
decorate11315193decorate
ephorate1359503ephorate
filtrate1148223filtrate
florae94713883_flora_e
globate1057823_globate
horste94817413_h_orste
hydrate14239813_hydrate
lobate82915243__lobate
locate83919843__locate
lyrate94112103__lyrate
meliorate1179483meliorate
ochlocrat1653183ochlocrat_
ochlocrats1752353ochlocrats
orate55133303___orate
perchlorate1853753perchlorate
perorate10417923perorate
phonate12411813ph_onate
phorates13413043ph_orates
priorate10411733priorate
prorate9418733_prorate
relocate10713533relocate
sororate8411173sororate
thionate11137503thionate
thorite10313443th_orite
tolerate8312323tolerate
valerate11311473valerate

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.406440125.6
2DLD Change Limit1461621247.56319325.9
3Display Results1241240.0462695.7
 (SQL Overall)1786911248.01522294.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.