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

68 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
anodyne114416(None) 
anodynes1244441anodynes
aerodyne1244192aerodyne
anode65021042anod__e
anodize1738682anodize
anodynic1444492anodynic
anolyte10159002anolyte
autodyne1243822autodyne
abode85518813abod__e
aboding11410123aboding
acnode938203acnod__e
acolyte12157653acolyte
aedine73218393a_edine
aerodynes1344603aerodynes
agone65924553ago__ne
alkyne13436863a_lkyne
alone55732963alo__ne
amidine103613853amidine
amidone10349313amidone
analyse10208893analyse
analyte10158813analyte
analyze19167013analyze
ancone83916953an_cone
andante8311273an_dante
androgyne1452393androgyne
anemone9119453anemone
anguine839913anguine
aniline7418473aniline
anodal72512123anod_al
anodes74418763anod_es
anodic92813133anod_ic
anodized1946463anodized
anodizes1837963anodizes
anoint6423633ano_int
anole55330383ano__le
anolytes11169213anolytes
anomie83215963ano_mie
anomy105113393anomy__
anon46134853ano__n_
anonym1136383anony_m
anonyms1235443anonyms
anyone94612733an_yone
apolune945283apolune
aroynt9312893aro_ynt
atone56527983ato__ne
autodynes1343903autodynes
avodire1143763avodire
axone125918473axo__ne
condone102616293condone
condyle13247053condyle
dyne85320933___dyne
groyne1037213gro_yne
indene73215373in_dene
inosine7314283inosine
iodine74618653_iodine
langsyne1242823langsyne
lanoline8311953lanoline
nardine82712573nardine
noddle83211363_noddle
node513036883_nod__e
nodose738883_nodose
nodule7309803_nodule
none45743173_no__ne
odyle9349593__odyle
sanidine939853sanidine
undine7817263un_dine
undone7914253un_done
vandyke1842513van_dyke

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 Filter1786911340270.406440125.6
2DLD Change Limit134027686.92319359.7
3Display Results68680.0302266.7
 (SQL Overall)178691687.35924282.0
 
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.