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

52 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
ineffectualness2313129(None) 
effectualness2171932__effectualness
ineffectiveness2682993ineffectiveness
effectualnesses2391804__effectualnesses
ineffectual1962484ineffectual____
ineffectuality2591994ineffectual_ity
ineffectually2462294ineffectual__ly
effectiveness2455675__effectiveness
effectuates1952535__effectua_te_s
factualness1652985____factualness
neglectfulness2082065_neglectfulness
unaffectedness2372085unaffect_edness
affectedness2153206__affect_edness
affectionless2161876__affectionless
affectless1842136__affect__l_ess
beneficialness2171396benefic_ialness
defectiveness2256546_de_fectiveness
effectual1752766__effectual____
effectualities2262206__effectualities
effectuality2382316__effectual_ity
effectually2252656__effectual__ly
effectuate1852586__effectua_te__
effectuated2051996__effectua_te_d
effectuations2151946__effectuations
effeteness1643676__effe_t__eness
effortfulness18112396__effortfulness
essentialness1363246__essentialness
identicalness1662646identic__alness
imperfectness2261706imperfect___ness
indirectness1552906indirect___ness
ineffableness2155606ineff__ableness
ineffective2273936ineffect__ive__
ineffectively2753126ineffect__ively
inefficacies2262166ineffic__acie_s
inexactness2052696ine_xact___ness
inexpertness2152676inexpert___ness
infectiousness1954306in__fectiousness
initialness1155726in____itialness
inoffensiveness2472176inoffensiveness
insecureness1453096in__sec_ureness
intellectualism19172256intellectual_ism
intellectualist17162336intellectual_ist
intellectuals1562856intellectual___s
invectiveness2156736in__vectiveness
needfulness1593996_ne__edfu_lness
neutralness1154376_n___eutralness
perfectiveness2455346_perfectiveness
perfectness1853496_perfect___ness
reflectiveness2255106_reflectiveness
respectfulness2163256_respectfulness
uneventfulness2062026une_ventfulness
unexpectedness2672316unexpect_edness

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 Filter178691950240.1231452772.4
2DLD Change Limit95024527.39312853.2
3Display Results52520.0461130.4
 (SQL Overall)178691527.56223630.1
 
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.