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

68 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
inoperativeness2073891inoperativeness_
cooperativeness2273373cooperativeness_
imperativeness2155473i_mperativeness_
operativeness1876663__operativeness_
operativenesses2055774__operativenesses
comparativeness2482925comparativeness_
informativeness2363155informativeness_
innovativeness2063175in_novativeness_
inoperative1646755inoperativ__e___
invectiveness2156735in_ve_ctiveness_
inventiveness1956975in_ve_ntiveness_
negativeness1656085_n__egativeness_
normativeness1855005_no_rmativeness_
superlativeness20283945_superlativeness_
abortiveness1755326abo__r_tiveness_
alternativeness1862616_alternativeness_
assertiveness1655506_asser_tiveness_
coerciveness1955406_co_er_civeness_
combativeness2254176_co_mbativeness_
competitiveness2482196competitiveness_
consecutiveness2262816consecutiveness_
cooperatives1965556cooperativ__e_s_
creativeness1747766__cre_ativeness_
decorativeness2054186_decorativeness_
desperateness1665196desperat__eness_
dispersiveness20104056disper_siveness_
evocativeness2154186evo__cativeness_
figurativeness2162626_figurativeness_
imaginativeness21152536imaginativeness_
imitativeness1864736i__mitativeness_
immoderateness1982586immoderat__eness_
imperatives1846446i_mperativ__e_s_
implicativeness2462506implicativeness_
impressiveness2164466i_mpressiveness_
inattentiveness1862896inattentiveness_
indecisiveness2063966in_decisiveness_
ineffectiveness2683006ineffectiveness_
inexpensiveness2762786inexpe_nsiveness_
ingressiveness1864166ingre_ssiveness_
inoffensiveness2472176inoffensiveness_
inopportuneness1971016inopportuneness_
inquisitiveness2762666inquisitiveness_
insensitiveness1863546insensitiveness_
instructiveness2064156instructiveness_
intemperateness1972736intemperat__eness_
intensiveness1667486in_te_nsiveness_
intolerableness1763066intolera_bleness_
intrusiveness1656316in__trusiveness_
intuitiveness1656196in__tuitiveness_
invasiveness1855716in___vasiveness_
invectivenesses23106016in_ve_ctivenesses
inventivenesses21136256in_ve_ntivenesses
lucrativeness1854576__lucrativeness_
moderateness1565286_moderat__eness_
nativeness1357836_n____ativeness_
negativenesses1855856_n__egativenesses
normativenesses2084526_no_rmativenesses
operatives15117886__operativ__e_s_
pervasiveness2155136___pervasiveness_
protectiveness2154596prote_ctiveness_
provocativeness25132196provocativeness_
repetitiveness1963846_repetitiveness_
respectiveness2155366respe_ctiveness_
sportiveness1766986__spor_tiveness_
supportiveness2162676suppor_tiveness_
temperateness1764426temperat__eness_
unobtrusiveness2071526unobtrusiveness_
vegetativeness2173256_vegetativeness_

Search took 6 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 Filter178691658740.310576422.6
2DLD Change Limit65874684.97013254.3
3Display Results68680.0631079.4
 (SQL Overall)178691685.34333443.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.