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
ineffectualness23131291ineffectualness_
effectualness2171933__effectualness_
effectualnesses2391804__effectualnesses
ineffectiveness2682994ineffectiveness_
ineffectual1962485ineffectual_____
ineffectuality2591995ineffectual__ity
ineffectually2462295ineffectual___ly
effectiveness2455676__effectiveness_
effectuates1952536__effectua_te_s_
factualness1652986____factualness_
neglectfulness2082066_neglectfulness_
unaffectedness2372086unaffect_edness_
affectedness2153207__affect_edness_
affectionless2161877__affectionless_
affectless1842137__affect__l_ess_
beneficialness2171397benefic_ialness_
defectiveness2256547_de_fectiveness_
effectivenesses2665067__effectivenesses
effectual1752767__effectual_____
effectualities2262207__effectualities
effectuality2382317__effectual__ity
effectually2252657__effectual___ly
effectuate1852587__effectua_te___
effectuated2051997__effectua_te__d
effectuations2151947__effectuations_
effeteness1643677__effe_t__eness_
effortfulness18112397__effortfulness_
essentialness1363247__essentialness_
factualnesses1853687____factualnesses
identicalness1662647identic__alness_
imperfectness2261707imperfect___ness_
indirectness1552907indirect___ness_
ineffableness2155607ineff__ableness_
ineffective2273937ineffect__ive___
ineffectively2753127ineffect__ive_ly
inefficacies2262167ineffic__acie_s_
inexactness2052697ine_xact___ness_
inexpertness2152677inexpert___ness_
infectiousness1954307in__fectiousness_
initialness1155727in____itialness_
inoffensiveness2472177inoffensiveness_
insecureness1453097in__sec_ureness_
intellectualism19172247intellectual__ism
intellectualist17162327intellectual__ist
intellectuals1562857intellectual___s_
invectiveness2156737in__vectiveness_
needfulness1593997_ne__edfu_lness_
neutralness1154377_n___eutralness_
perfectiveness2455347_perfectiveness_
perfectness1853497_perfect___ness_
reflectiveness2255107_reflectiveness_
respectfulness2163257_respectfulness_
uneventfulness2062027une_ventfulness_
unexpectedness2672317unexpect_edness_

Search took 10 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 Limit95024549.00010558.2
3Display Results54540.0461173.9
 (SQL Overall)178691549.16919488.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.