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

121 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
oxidate153702(None) 
oxidase1543541oxidase
oxidated1745031oxidated
oxidates1636331oxidates
exudate1537092exudate
nidate7313782_nidate
opiate8513462opi_ate
outdate83016422outdate
oxalate1457622oxalate
oxidable1865122oxidable
oxidant1547362oxidant
oxidants1643932oxidants
oxidases1643882oxidases
oxidative2044312oxidative
oxide131210952oxid__e
oxidise1545042oxidise
oxidize2444982oxidize
agitate8312063agitate
airdate8311323airdate
alidade936993alidade
amidase1036733amidase
amirate91115953amirate
animate91617213animate
aviate9315203avi_ate
axite125218253axi__te
binate8419773_binate
caudate10311353caudate
climate11312833climate
cnidae978143cnida_e
cogitate1148553cogitate
cordate10315223cordate
date56443323___date
dilate73220693_dilate
dominate11312853dominate
emirate91015833emirate
epidote1037393epidote
epilate9314283epilate
expiate16910593expiate
exudates1636623exudates
fixate1638733_fixate
foliate10513533foli_ate
foredate12310913foredate
frigate11311063frigate
gradate9511233gradate
ideate7313683__ideate
imitate9310873imitate
iodate7313503_iodate
iodinate949343iodinate
irate55627983__irate
lapidate1157903lapidate
ligate72519253_ligate
loricate10310663loricate
mandate10315573mandate
mediate103415213mediate
misate81222693_misate
misdate101413963misdate
motivate1347693motivate
nidated939863_nidated
nidates8311893_nidates
nominate10312473nominate
oblate82214743o_blate
obligate11198303obligate
obovate1235463obovate
obviate1235783obviate
ocicat101412813ocicat_
ocicats11137413ocicats
ocreate93711743ocreate
odonate848403odonate
oleate6318883o_leate
operate9615733operate
opiated1039483opi_ated
opiates9312143opi_ates
oppilate1245863oppilate
orate55133303o__rate
ordinate9310253ordinate
ornate6315143o_rnate
outate62923403o_utate
outdare83113403outdare
outdated1012513193outdated
outdates93114743outdates
outrate72323183outrate
ovate84214393o__vate
overate10620963overate
ovulate1039453ovulate
oxalated1695323oxalated
oxalates1557063oxalates
oxid12815483oxid___
oxidasic1842503oxidasic
oxidating1845053oxidating
oxidation1746323oxidation
oxides14109693oxid_es
oxidic1635943oxid_ic
oxidised1743413oxidised
oxidiser1642903oxidiser
oxidises1644833oxidises
oxidized2644033oxidized
oxidizer2543693oxidizer
oxidizes2544583oxidizes
oxids13128963oxid__s
oxime1498433oxi__me
oximeter1755153oximeter
ozonate1646863ozonate
pedate93117763_pedate
pirate82322883_pirate
plicate11314513plicate
postdate1139653postdate
predate10616893predate
primate111516283primate
private121513263private
proximate2045773proximate
quinate16511573quinate
radiate83416313radiate
redate74124683_redate
ruinate7312833ruinate
sedate73019813_sedate
sonicate10310933sonicate
spicate113214193spicate
spinate93114813spinate
update93810293_update
urinate7315363urinate
validate1239003validate

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271216.28321331.7
3Display Results1211210.0462630.4
 (SQL Overall)1786911216.73226543.5
 
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.