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

97 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
zymosis2148749(None) 
zygosis20405951zygosis
zymoses21608691zymoses
mycosis1437752mycosis
myosis114012552my_osis
osmosis976572osmosis
pyosis114012122py_osis
pyrosis12411652pyrosis
sycosis1238802sycosis
zygoses20436782zygoses
zymases21938332zymases
zymolysis2653062zymolysis
zymosan2143802zymosan
zymosans2243222zymosans
zymotic2345702zymotic
abiosis939373abiosis
anemosis10148073anemosis
azygoses2163313azygoses
chymosin1845013chymosin
chymosins1944743chymosins
cyanosis1346273cyanosis
cyclosis1547473cyclosis
cyesis1148573cy_esis
cymoid1459463cymo_id
cymols1377193cymo_ls
cymose13429653cymos_e
cymous1388403cymo_us
demoses103815823demoses
emesis84712623_emesis
enosis63816423_enosis
gaposis1038423gaposis
gnosis75711213_gnosis
gummosis1343713gummosis
hypnosis1646533hypnosis
kenosis11369003kenosis
ketosis11429733ketosis
kyphosis2045173kyphosis
lysis84511463ly__sis
meiosis939023meiosis
mimesis1137323mimesis
mimosas1136753mimosas
miosis83615163_miosis
mitosis939633mitosis
mosks116117003__mosks
moss67641033__mos_s
mosts76028543__mosts
myasis114010463my_asis
mycoses1437723mycoses
myiasis1245483myiasis
myoses114013843my_oses
myosin113410763my_osin
myosins12278953my_osins
mysosts1234543mysosts
nemesis937373nemesis
osmoses9138123osmoses
ostosis71310113ostosis
phimosis1546173phimosis
ptosis83611823_ptosis
pycnosis1554733pycnosis
pyknosis1753643pyknosis
pyoses114314303py_oses
samosas939293samosas
semiosis1059873semiosis
sorosis72611963sorosis
sycoses1249133sycoses
symbiosis16123783symbiosis
symposia1545773symposia
synesis1039153synesis
synopsis1346643synopsis
thymosin1644473thymosin
thymosins1744173thymosins
tmesis8529793_tmesis
tylosin1046903tylosin
tylosins1145723tylosins
utmosts934593utmosts
vamoses1239143vamoses
virosis1039023virosis
whoosis1335443whoosis
whosis1237163_whosis
xerosis14249663xerosis
xyloses1746843xyloses
yogis95617743_y_ogis
yonis85020823_y_onis
zombis1936283zom_bis
zoonosis1744393zoonosis
zoris145320013z__oris
zygoid2045933zygo_id
zygomas2243413zygomas
zygose19455553zygos_e
zygosity2442983zygosity
zygotes20355163zygotes
zygotic2254653zygotic
zymase201997483zymas_e
zymes1924712943zym__es
zymogen2243693zymogen
zymogens2343673zymogens
zymolyses2643133zymolyses

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.1561145455.1
2DLD Change Limit134027976.40620922.1
3Display Results97970.0303233.3
 (SQL Overall)178691976.59227107.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.