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 “dishearteningly” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

56 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
dishearteningly237113(None) 
disheartening1852382disheartening__
hearteningly1972433___hearteningly
discerningly1952954disce_r__ningly
deadeningly1752645d___ea_deningly
deafeningly1952545d___ea_feningly
disarmingly1853415dis__ar__mingly
dishearten1444335dishearte__n___
disheartened1752755dishearte__n_ed
disheartenment20202895dishearten_ment
disheartenments21242645disheartenments
disheartens1563555dishearte__n__s
disparagingly2161735dis_par_agingly
distractingly2053255distract__ingly
heartening1446735___heartening__
heartrendingly227985___heartrendingly
shatteringly1962385__sh_atteringly
threateningly2061215_threa_teningly
bigheartedly2281906bighearte___dly
dartingly1436946d____art__ingly
desolatingly1752696desola_t__ingly
disapprovingly2671546disappr_ovingly
disburdening1772106dis_burdening__
discernibly1952736disce_r__ni_bly
discerning1447866disce_r__ning__
discouragingly2261366discour_agingly
disenchantingly2581156dis_enchantingly
disgustingly1852256dis_gust__ingly
disheriting1646456dishe_r_iting__
disheveling19163096dishe__veling__
dismayingly2152176dis_ma___yingly
disparting1438936dis_part__ing__
dispraisingly2061986dis__praisingly
disquietingly2761786dis__quietingly
disseating121111786dissea_t__ing__
dissertating1474796disse_rtating__
disserting121310856disse_rt__ing__
distressingly1882206dis__tressingly
disturbingly1951946dis_tur__bingly
frighteningly2411906frigh___teningly
hearkening1844536___hearkening__
mishearing1647886mishear___ing__
misleadingly1951696mislea___dingly
mislearning1443726mislear__ning__
resharpening1852346resh_arpening__
scatteringly1872496__s_catteringly
searchingly2042846__s_ear_chingly
searingly1338276__s_ear___ingly
sharpening1644886__sh_arpening__
shortening1445306__sh_ortening__
shortenings1542686__sh_ortening_s
smartening1344996__s_martening__
startlingly1542766__s_tart_lingly
swelteringly1951736__swe_lteringly
witheringly2152526withe_r___ingly
yearningly1743386___year__ningly

Search took 9 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 Filter178691950240.1231452772.4
2DLD Change Limit95024568.26611495.8
3Display Results56560.0301866.7
 (SQL Overall)178691568.41921224.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.