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

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

54 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
ineffectualness23131301ineffectualness_
effectualness2171933__effectualness_
effectualnesses2391814__effectualnesses
ineffectiveness2683004ineffectiveness_
ineffectual1962495ineffectual_____
ineffectuality2591995ineffectual__ity
ineffectually2462305ineffectual___ly
effectiveness2455676__effectiveness_
effectuates1952536__effectua_te_s_
factualness1652996____factualness_
neglectfulness2082086_neglectfulness_
unaffectedness2372086unaffect_edness_
affectedness2153207__affect_edness_
affectionless2161877__affectionless_
affectless1842137__affect__l_ess_
beneficialness2171397benefic_ialness_
defectiveness2256547_de_fectiveness_
effectivenesses2665107__effectivenesses
effectual1752767__effectual_____
effectualities2262207__effectualities
effectuality2382317__effectual__ity
effectually2252657__effectual___ly
effectuate1852587__effectua_te___
effectuated2051997__effectua_te__d
effectuations2151957__effectuations_
effeteness1643677__effe_t__eness_
effortfulness18112417__effortfulness_
essentialness1363267__essentialness_
factualnesses1853697____factualnesses
identicalness1662667identic__alness_
imperfectness2261707imperfect___ness_
indirectness1552917indirect___ness_
ineffableness2155607ineff__ableness_
ineffective2273947ineffect__ive___
ineffectively2753137ineffect__ive_ly
inefficacies2262167ineffic__acie_s_
inexactness2052697ine_xact___ness_
inexpertness2152687inexpert___ness_
infectiousness1954307in__fectiousness_
initialness1155737in____itialness_
inoffensiveness2472177inoffensiveness_
insecureness1453097in__sec_ureness_
intellectualism19172257intellectual__ism
intellectualist17162337intellectual__ist
intellectuals1562857intellectual___s_
invectiveness2156737in__vectiveness_
needfulness1593997_ne__edfu_lness_
neutralness1154377_n___eutralness_
perfectiveness2455347_perfectiveness_
perfectness1853507_perfect___ness_
reflectiveness2255107_reflectiveness_
respectfulness2163277_respectfulness_
uneventfulness2062037une_ventfulness_
unexpectedness2672317unexpect_edness_

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.376475242.0
2DLD Change Limit95024548.45011245.4
3Display Results54540.0501080.0
 (SQL Overall)178691548.87620131.9
 
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.