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

58 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
adenosis94634(None) 
adenoses947901adenoses
adenitis947432adenitis
adenoid959252adeno_id
adenoids1056862adenoids
adenomas1144812adenomas
adenosine1054182adenosine
adenosines1193612adenosines
adiposis1146252adiposis
agenesis938042agenesis
anemosis10148072anemosis
enosis63816422__enosis
kenosis11369002_kenosis
stenosis847992stenosis
abiosis939373a_biosis
acidosis1146143acidosis
adenines9310193adenines
adenoma1045403adeno_ma
adenovirus1451933adenovirus
adenyls1143923aden_yls
adiposes1137173adiposes
adnouns835453ad_nouns
adonis7314063ad__onis
adonises92611433adonises
ageneses939303ageneses
agenesia945983agenesia
agenesias1045363agenesias
agnosia837643a_gnosia
agnosias947243a_gnosias
alphosis1347273alphosis
amitosis1047203amitosis
anemoses10159433anemoses
apodosis1146583apodosis
arenose7311373arenos_e
arenous7314183areno_us
asepsis985903ase_psis
athetosis1244643athetosis
avenses1049643aven_ses
cyanosis1346273cyanosis
demoses103815823_demoses
denotes83817003_denotes
deposes103117213_deposes
deposit10313003_deposit
deposits1138843_deposits
enokis103010273__enokis
genesis82510823_genesis
gnosis75711213__gnosis
hypnosis1646533hypnosis
ketosis11429733_ketosis
meiosis939023_meiosis
pycnosis1554733pycnosis
pyknosis1753643pyknosis
selenosis945443selenosis
siderosis1045543siderosis
stenoses8310443stenoses
vaginosis1343573vaginosis
xerosis14249663_xerosis
zoonosis1744393zoonosis

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.1561145455.1
2DLD Change Limit146162587.15620425.1
3Display Results58580.0134461.5
 (SQL Overall)178691587.32524394.7
 
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.