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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 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
ineffectiveness268300(None) 
effectiveness2455672__effectiveness
defectiveness2256543_de_fectiveness
ineffectualness23131303ineffectualness
inoffensiveness2472173inoffensiveness
invectiveness2156733in__vectiveness
perfectiveness2455343_perfectiveness
reflectiveness2255103_reflectiveness
effectivenesses2665104__effectivenesses
electiveness1757554__e_lectiveness
inattentiveness1862894inattentiveness
ineffective2273944ineffectiv__e__
ineffectively2753134ineffectiv__ely
inexpensiveness2762784inexpensiveness
instructiveness2064154instructiveness
inventiveness1956974in__ventiveness
refractiveness2254854_refractiveness
respectiveness2155364_respectiveness
selectiveness1856514_se_lectiveness
deceptiveness2155695_de_ceptiveness
defectivenesses2496075_de_fectivenesses
defensiveness20115815_de_fensiveness
definitiveness2163795_definitiveness
effectives21134565__effectiv__e_s
effectualness2171935__effectualness
effeteness1643675__effe_t__eness
effusiveness2154935__eff_usiveness
festiveness1748225____festiveness
fictiveness1946315____fictiveness
indecisiveness2063965in__decisiveness
ineffableness2155605ineff__ableness
inefficients2062605ineffic_i_en_ts
infectiousness1954305in__fectiousness
informativeness2363155informativeness
ingressiveness1864165in_gressiveness
innovativeness2063175in_novativeness
inoperativeness2073895inoperativeness
inquisitiveness2762665inquisitiveness
insensitiveness1863545insensitiveness
intensiveness1667485in__tensiveness
intuitiveness1656195in__tuitiveness
invectivenesses23106015in__vectivenesses
negativeness1656085_ne__gativeness
objectiveness2755165__objectiveness
offensiveness2274245__offensiveness
perceptiveness2354785_perceptiveness
preventiveness2294895pre_ventiveness
protectiveness2154595_protectiveness
reactiveness1756925_re__activeness
receptiveness2056125_re_ceptiveness
reductiveness1955545_re_ductiveness
reflexiveness2662745_refle_xiveness
retentiveness1657165_re_tentiveness
secretiveness1865865_secre_tiveness
seductiveness1955245_se_ductiveness
subjectiveness2863975_subjectiveness
unaffectedness2372085unaffect_edness
vindictiveness2363035vin__dictiveness
activeness1547706_____activeness
affectedness2153206__affect_edness
affectionless2161876__affectionless
assertiveness1655506__assertiveness
attentiveness1665156__attentiveness
attractiveness1983556_attractiveness
coerciveness1955406coe__rc_iveness
consecutiveness2262816_consecutiveness
creativeness1747766___creativeness
decorativeness2054186_decorativeness
defectives1945686_de_fectiv__e_s
derivativeness2163806_derivativeness
destructiveness2173806destructiveness
diffusiveness2353436_diff_usiveness
distinctiveness2162916distinctiveness
effective2076196__effectiv__e__
effectively2554496__effectiv__ely
effectivities2453856__effectivities
electivenesses1957646__e_lectivenesses
evocativeness2154186__evocativeness
excessiveness2554966__excessiveness
expensiveness2555586__expensiveness
extensiveness2355306__extensiveness
fertileness1447576____fertileness
fugitiveness1964026___fugitiveness
furtiveness1746536____furtiveness
imaginativeness21152536imaginativeness
imitativeness1864736i__mitativeness
imperativeness2155476i_mperativeness
imperfectives2562046imperfectiv__e_s
imperfectness2261706imperfect___ness
implicativeness2462506implicativeness
impreciseness1962706i_mprec_iseness
impressiveness2164466i_mpressiveness
incisiveness1756336in___cisiveness
inclusiveness1855126in__clusiveness
indefiniteness1863086indef_initeness
indirectness1552916indirect___ness
inefficiencies2462116ineffic_i_encies
inefficiency2562546ineffic_i_en_cy
inefficient1953566ineffic_i_en__t
inefficiently2462476ineffic_i_ently
inexactness2052696ine_xact___ness
inexpertness2152686inexpert___ness
infections15510236in__fecti_on__s
infective17108976in__fectiv__e__
infectivities2155126in__fectivities
infiniteness1555736in__f_initeness
inflections1646996in_flecti_on__s
inflective18126576in_flectiv__e__
inflexibleness2662576in_flexibleness
insectivores17101726in__sectivore_s
insecureness1453096in__sec_ureness
interestingness1671556interestingness
intrusiveness1656316in__trusiveness
invasiveness1855716in___vasiveness
invectives1885906in__vectiv__e_s
inventivenesses21136256in__ventivenesses
meditativeness2062886_meditativeness
nativeness1357836_n____ativeness
neglectfulness2082086_neglectfulness
noneffective2363586noneffectiv__e__
normativeness1855006_n_ormativeness
obstructiveness2273396obstructiveness
operativeness1876666ope__rativeness
perfectives2145476_perfectiv__e_s
perfectness1853506_perfect___ness
productiveness2283286_productiveness
recessiveness1865906_re_cessiveness
regressiveness1864226_regressiveness
repetitiveness1963846_repetitiveness
repressiveness1964816_repressiveness
resistiveness1656026_re_sistiveness
restiveness1449666____restiveness
restrictiveness2093416restrictiveness
selectivenesses2056006_se_lectivenesses
sensitiveness1655816_se_nsitiveness
suggestiveness1962926_suggestiveness
susceptiveness2163386_susceptiveness
tentativeness1655026_te_ntativeness
unexpectedness2672316unexpect_edness
vegetativeness2173256_vegetativeness

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.343520965.0
2DLD Change Limit950241406.86013851.9
3Display Results1401400.1101272.7
 (SQL Overall)1786911407.31324434.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.