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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

65 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
kathodes164618(None) 
cathodes1439391cathodes
kathode1545731kathode_
bathoses13310462bathoses
cathode1338992cathode_
kathodal16153402kathodal
kathodic18114572kathodic
pathoses13412772pathoses
ratholes11312412ratholes
abodes94417513_a_bodes
acnodes1037833_acnodes
anodes74418763_a_nodes
aphides134711203_aphides
athodyd1542693_athodyd
athodyds1641923_athodyds
atones65225773_at_ones
bathes116524833bath__es
bathos116215633batho__s
bathrobes1644393bathrobes
cathexes2036273cathexes
cathodal14155413cathodal
cathodic16126753cathodic
cathouse1338863cathouse
cathouses1439433cathouses
ethoses10311763_ethoses
fathomed1744733fathomed
fathomer1645293fathomer
fathomers1744953fathomers
fathoms1537523fatho_ms
fatsoes10379423fatso_es
hatboxes2055003hatboxes
hydathodes2151993hydathodes
karaokes1145013karaokes
katharses1643873katharses
kations114013663katio_ns
kayoes134710823ka_yo_es
ketones115014503ket_ones
ketoses114912873ket_oses
keyholes1844593keyholes
kithes135016653kith__es
knotholes1644173knotholes
kolhozes2443223kolhozes
kyphoses2045283kyphoses
kythes16499133kyth__es
lathes95127503lath__es
mahoes11313103ma_ho_es
manholes13311183manholes
methods1338893method_s
orthoses11311143orthoses
outmodes11208963outmodes
pathogen1446463pathogen
pathogens1545713pathogens
pathos115516693patho__s
potholes13312933potholes
rachides141511223rachides
raphides14188393raphides
rathole10312053rathole_
rawhides15145543rawhides
sarodes84216143sa_rodes
skatoles1236143skat_oles
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.436409841.7
2DLD Change Limit146162657.70618967.3
3Display Results65650.0135000.0
 (SQL Overall)178691658.15521911.8
 
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.