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

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

48 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
directedness165426(None) 
dejectedness2353562dejectedness
directednesses1863382directednesses
directness1344192direct__ness
affectedness2153203affectedness
dementedness1654673dementedness
directionless1661933directionless
directress1343103direct__ress
expectedness2453323expectedness
collectedness1863704collectedness
connectedness1884454connectedness
datedness1187754d___atedness
decidedness16103794d__ecidedness
dejectednesses2553074dejectednesses
deservedness1753484deservedness
detachedness1952524detachedness
devotedness1653704d_evotedness
diluteness1145194di_lute_ness
directed1238234directed____
directest1246304direct___est
directions1379644direction__s
directives1655834direct_ive_s
directnesses1595284direct__nesses
directories1446014directorie_s
directresses15123084directresse_s
directrices1652894directrice_s
directrixes2152064directrixe_s
direness9311304dir___e_ness
dirtiness1039474dir__t_iness
discreteness1554484discre_te_ness
diverseness1554774diverse_ness
dividedness1753314di_videdness
erectness1146124_erect__ness
fierceness1543794fierc_e_ness
giftedness1543684gi__ftedness
hirsuteness1452954hirsute_ness
indebtedness1654524indebtedness
indirectness1552914indirect__ness
irateness9310494_ir_ate_ness
limitedness1453894li_mitedness
pervertedness1963274pervertedness
relatedness1245604__relatedness
rootedness1144904__rootedness
spiritedness1553784spir_itedness
tiredness1036934tir___edness
uprootedness1562694uprootedness
wickedness2043074wi__ckedness
wretchedness2152154_wretchedness

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 Filter1786911247900.403443402.0
2DLD Change Limit124790487.69016227.6
3Display Results48480.0301600.0
 (SQL Overall)178691488.12321998.2
 
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.