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

108 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
chlorates14251227(None) 
chlorate133112691chlorate_
chlorites142311961chlorites
chloracnes1744442chloracnes
chlorals13148032chlora_ls
chlordanes1644512chlordanes
chlorides15289752chlorides
chlorinates1645542chlorinates
chlorines142512352chlorines
chlorite133012842chlorite_
chloroses1447682chloroses
cholates132414762ch_olates
chorales133712882ch_orales
chordates1547682ch_ordates
chromates16313112chromates
colocates13312852colocates
phorates13413042ph_orates
allocates11410473allocates
borates94823013__borates
calibrates1446953calibrates
califates14310113califates
calories102919553calor_ies
calorizes202312293calorizes
calottes10610083calo_ttes
carates95630613c__arates
castrates11312673castrates
celebrates1447673celebrates
celibates1358633celibates
cellmates1347513cellmates
cerates95428253c__erates
charades141310853ch_arades
charases131312763ch_arases
chelates132713843ch_elates
chloracne1644513chloracne
chloral12169983chlora__l
chloralose1552783chloralose
chloraloses1652783chloraloses
chloramines1845523chloramines
chlordane1544913chlordane_
chlordans1544893chlordans
chloride143310243chloride_
chlorids14299673chlor_ids
chlorinate1546123chlorinate_
chlorinated1744493chlorinated
chlorine133013303chlorine_
chlorins132612883chlor_ins
chloritic1657433chloritic
chlorosis1446193chlorosis
chlorotic1656983chlorotic
chlorous1339223chlor_ous
chocolates1746783chocolates
cholate122114933ch_olate_
choragus1474303ch_oragus
chorale124313353ch_orale_
chorals124614113ch_ora_ls
chordate1448033ch_ordate_
chores114828023ch_or__es
chorines132917253ch_orines
chorten122811303ch_or_ten
chortens13308793ch_or_tens
chortles133611323ch_ortles
choruses1339983ch_oruses
chromate15312783chromate_
chromites16310963chromites
ciliates10413453cil_iates
citrates102315093c_itrates
climates12311973c_limates
clodpates1444103c_lodpates
coelomates1497573coelomates
cohobates1646523cohobates
collates103019143col_lates
collocates1448123collocates
colocate12313443colocate_
colocated1439613colocated
colorants1149863colorants
colorizes203014523colorizes
comates114123643c__omates
coronates1110816923coronates
corotates112714283corotates
corporates14410733corporates
crates85736063c___rates
culottes1076293culo_ttes
cultrate10310873cultrate_
cultrated1248223cultrated
curates95323833c__urates
decorates12314743decorates
ephorates1459163ephorates
filtrates1247733filtrates
horstes104516113_h_orstes
hydrates15229413_hydrates
locates93218813__locates
meliorates1288903meliorates
ochlocrats1752353ochlocrat_s
orates64328613___orates
perchlorates1953383perchlorates
perorates11417023perorates
phonates13410643ph_onates
phorate12413363ph_orate_
priorates11410763priorates
prorates10418073_prorates
relocates11712933relocates
sororates9410473sororates
thionates12106663thionates
thoraces13118943th_oraces
thoraxes1896363th_oraxes
thorites11312393th_orites
tolerates9312123tolerates
valerates12310543valerates

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411087.25320493.7
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.73523101.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.