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

62 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
cathexis204575(None) 
cathexes2036271cathexes
cachexia2263582cachexia
cachexias2363382cachexias
cachexic2153542cachexic
cachexies2364162cachexies
catalexis1844952catalexis
catheads1438122catheads
cathects1545792cathects
anthesis11312503anthesis
aphesis12610513_aphesis
atheism1248523_athe_ism
atheist10314063_athe_ist
bathers124720363bathe_rs
bathes116524833bathe__s
bathetic1548583bathetic
caches137926913cache__s
cachets145014263cache_ts
cachexy2443283cachex_y
cantharis1447183cantharis
canthitis1445273canthitis
cashes114729883cashe__s
cashews15428603cashe_ws
catalexes1845913catalexes
catchers153114063catche_rs
catches144320773catche__s
catechesis1743243catechesis
catenas9313113cat_enas
caters85336503cat_e_rs
cates75951893cat_e__s
catharsis1444483catharsis
cathead1338753cathe_ad
cathect1439863cathe_ct
cathectic1545243cathectic
cathedra14104773cathedra
cathedras15104823cathedras
cathepsin1643603cathepsin
cathepsins1753363cathepsins
catheptic1844903catheptic
catheter1338153catheter
catheters1437013catheters
cathodes1439393cathodes
cathodic16126753cathodic
catholic15158383catholic
catholics16105893catholics
catteries11815523catteries
caudexes1843843caudexes
citherns13338873citherns
cithers124315773cithe_rs
diathesis1345533diathesis
esthesis1148463esthesis
fatheads1536763fatheads
fathers133916503fathe_rs
gathers114315073gathe_rs
latexes1438313lat_exes
lathers104321883lathe_rs
lathes95127493lathe__s
lathis95516173lath__is
narthexes1943873narthexes
pathetic15410963pathetic
scathes124515713scathe__s
thesis94913733__thesis

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 Filter1786911461620.406440125.6
2DLD Change Limit146162627.29620033.2
3Display Results62620.0163875.0
 (SQL Overall)178691627.71823152.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.