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

90 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
hypnoses164663(None) 
hypnosis1646531hypnosis
cyanoses1337422cyanoses
haploses1338852haploses
heptoses1338372heptoses
hognoses12108132hognoses
kyphoses2045282kyphoses
pycnoses1554972pycnoses
pyknoses1783572pyknoses
adenoses947903adenoses
apposes11511473_apposes
bypasses1533833bypasses
cyanosed1444613cyanosed
cyanosis1346273cyanosis
cycloses1538183cycloses
cypreses1535143cypreses
cypruses1534313cypruses
deposes103117213dep_oses
diploses111110323diploses
dynodes1235453dy_nodes
eposes84418783_ep_oses
ethnoses1146083ethnoses
exposes1639963exp_oses
gnoses76515163__gnoses
hanses95022633h_an_ses
haplosis1347093haplosis
hardnoses1346233hardnoses
hawknoses1942413hawknoses
heptose1237493heptose_
hexoses17228883h_exoses
hidroses1237903hidroses
hipbones1546023hipbones
hipness12277383hipnes_s
hipnesses1436753hipnesses
hognose11117243hognose_
hommoses1538153hommoses
hooknoses1644353hooknoses
hoses85443173h___oses
hybrises1645423hybrises
hydrases15227643hydrases
hydropses1846033hydropses
hymnists1644903hymnists
hymnless1632803hymnless
hymnodies18123993hymnodies
hyperopes1947503hyperopes
hypes135818673hyp___es
hypnoid1647883hypno_id
hypnotic1846623hypnotic
hypnotics1944443hypnotics
hypnotism1954023hypnotism
hypnotisms2053783hypnotisms
hypnotist1755643hypnotist
hypnotists1853883hypnotists
hypnotizes27124053hypnotizes
hypoed1547923hyp_o_ed
hypogea1645473hyp_ogea
hyponea1546453hyp_onea
hyponeas1646383hyponeas
hyponoias1746113hyponoias
hyponyms2144983hyponyms
hypos1312014743hyp_o__s
imposes113213683imp_oses
kyanises15206393kyanises
kyphosis2045173kyphosis
mannoses1039083mannoses
mycoses1437733my_coses
myoses114013843my__oses
noses55435643___noses
opposes1149243_opposes
papooses1248053papooses
peploses1269473peploses
poses74642763__p_oses
proses84733473__proses
ptoses83514673__ptoses
pycnosis1554733pycnosis
pyknosis1753643pyknosis
pyoses114314303__pyoses
pyranoses1445853pyranoses
reposes94021263rep_oses
rhamnoses14104183rhamnoses
stenoses8310443stenoses
supposes1238203supposes
sycoses1249133sy_coses
synopses1346223sy_nopses
typhose1546693typhose_
typhuses1643763typhuses
xyloses1746843xy_loses
zoonoses1746203zoonoses
zygoses20436783zy_goses
zymoses21608693zy_moses

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 Filter1786911461620.420425454.8
2DLD Change Limit146162906.17323677.6
3Display Results90900.0461956.5
 (SQL Overall)178691906.63926915.3
 
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.