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

51 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
informativeness2363151informativeness_
normativeness1855003_n_ormativeness_
innovativeness2063174inno_vativeness_
normativenesses2084524_n_ormativenesses
decorativeness2054185decor_ativeness_
imperativeness2155475imper_ativeness_
informations17127035informati_on__s_
informative1965155informativ__e___
informatively2453295informativ__e_ly
inoperativeness2073895inoperativeness_
instructiveness2064155instructiveness_
abortiveness1755326_abor__tiveness_
alternativeness1862616alternativeness_
amativeness1646226____amativeness_
combativeness2254176__combativeness_
creativeness1747766___creativeness_
evocativeness2154186_evo_cativeness_
figurativeness2162626figur_ativeness_
forgiveness1864986__for__giveness_
formatives1846216__formativ__e_s_
furtiveness1746536__fur__tiveness_
idiomaticness1861096idio_mati_cness_
imaginativeness21152536imaginativeness_
imitativeness1864736i__mitativeness_
implicativeness2462506implicativeness_
inanimateness1563796inanimat__eness_
inattentiveness1862896inattentiveness_
ineffectiveness2683006ineffectiveness_
informalities1864296informali_tie_s_
informatics1854106informati____cs_
information16147716informati_on____
informational1854346informati_on__al
informationally2362466informati_onally
ingressiveness1864166in_gressiveness_
inoffensiveness2472176inoffensiveness_
inquisitiveness2762666inquisitiveness_
insensitiveness1863546insensitiveness_
intimateness1455796in_timat__eness_
intrusiveness1656316in_tr_usiveness_
intuitiveness1656196in__tuitiveness_
invasiveness1855716in___vasiveness_
invectiveness2156736in__vectiveness_
inventiveness1956976in__ventiveness_
lucrativeness1854576_lucr_ativeness_
nativeness1357836_n____ativeness_
negativeness1656086_n__egativeness_
operativeness1876666_oper_ativeness_
promotiveness2053926_pro_motiveness_
refractiveness2254856ref_ractiveness_
sportiveness1766986_spor__tiveness_
superlativeness20283946superlativeness_

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.326548131.9
2DLD Change Limit65874515.06313010.9
3Display Results51510.0331545.5
 (SQL Overall)178691515.42232956.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.