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

111 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
cathodes143939(None) 
cathode1338991cathode_
kathodes1646181kathodes
bathoses13310462bathoses
cathexes2036272cathexes
cathodal14155412cathodal
cathodic16126752cathodic
cathouse1338862cathouse
cathouses1439432cathouses
kathode1545732kathode_
pathoses13412772pathoses
ratholes11312412ratholes
abodes94417513_a_bodes
acnodes1037833_acnodes
anodes74418763_a_nodes
aphides134711203_aphides
athodyd1542693_athodyd
athodyds1641923_athodyds
atones65225773_at_ones
bathes116524833bath__es
bathos116215633batho__s
bathrobes1644393bathrobes
caboodles1443283caboodles
cabooses1237863cabooses
caches137926913cach__es
cachous14312583cacho_us
cades85440733ca___des
cahoots1238473ca_hoots
cahows14399123ca_ho_ws
cajoles163712103ca_joles
cajones163311333ca_jones
calloses10313393calloses
calzones1948763calzones
canoes84725883ca_no_es
canoodles1244003canoodles
canzones1939153canzones
capotes11314643ca_potes
carbides133111693carbides
cargoes104415223cargo_es
carhops14329703carho_ps
carioles10817083carioles
carthorse1446293carthorse
carthorses1546363carthorses
cascades13128553cascades
caseoses1039293caseoses
cashboxes2343053cashboxes
cashes114729883cash__es
cashoos12310793casho_os
cataloes10311653cataloes
catboats1247873catboats
catches144320773cat_ches
catchpoles1943783catchpoles
cates75951893cat___es
catfaces1536963catfaces
catharses1446413catharses
catheads1438123catheads
cathects1545793cathects
cathedra14104773cathedra
cathedras15104823cathedras
catheter1338153catheter
catheters1437023catheters
cathexis2045753cathexis
catholic15158383catholic
catholics16105893catholics
cations94524143catio_ns
catties94023053cat_ties
cestodes1138203cestodes
chides124620473c__hides
chokes154917383c__hokes
chores114828023c__hores
choses115825133c__hoses
citoles9312553cit_oles
cladodes1245323cladodes
coalholes1445373coalholes
codes86247293c___odes
commodes1539093commodes
corrodes111310333corrodes
cowhides1736013cowhides
crunodes1144973crunodes
custodes1136653custodes
ethoses10311763_ethoses
fathomed1744733fathomed
fathomer1645293fathomer
fathomers1744953fathomers
fathoms1537523fatho_ms
fatsoes10379423fatso_es
hatboxes2055003hatboxes
hydathodes2151993hydathodes
kathodal16153403kathodal
kathodic18114573kathodic
lathes95127503lath__es
mahoes11313103ma_ho_es
manholes13311183manholes
methods1338893method_s
orthoses11311143orthoses
outmodes11208963outmodes
pathogen1446463pathogen
pathogens1545713pathogens
pathos115516693patho__s
potholes13312933potholes
rachides141511223rachides
raphides14188393raphides
rathole10312053rathole_
rawhides15145543rawhides
sarodes84216143sa_rodes
scathes124515713scath__es
tacnodes1145003tacnodes
tapholes1339623tapholes
tetrodes939093tetrodes
tholes94919783__tholes
xanthones1957023xanthones

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.440406115.9
2DLD Change Limit1461621117.96618348.2
3Display Results1111110.0502220.0
 (SQL Overall)1786911118.45621131.9
 
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.