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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

37 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
imperativeness215547(None) 
inoperativeness2073892inoperativeness
operativeness1876662_operativeness
comparativeness2482923comparativeness
cooperativeness2273373cooperativeness
imitativeness1864733im_itativeness
imperatives1846443imperativ__e_s
implicativeness2462503implicativeness
impressiveness2164463impressiveness
superlativeness20283943superlativeness
alternativeness1862614alternativeness
amativeness1646224am___ativeness
assertiveness1655504asser_tiveness
competitiveness2482194competitiveness
creativeness1747764_cre_ativeness
decorativeness2054184decorativeness
dispersiveness20104054disper_siveness
figurativeness2162624figurativeness
imaginativeness21152534imaginativeness
impassiveness2054494imp_assiveness
imperative1748564imperativ__e__
imperatively2255574imperativ__ely
impertinences1953594imper_tinences
impreciseness1962704imp_reciseness
impulsiveness2054554imp_ulsiveness
informativeness2363154informativeness
innovativeness2063174innovativeness
invectiveness2156734inve_ctiveness
inventiveness1956974inve_ntiveness
lucrativeness1854574_lucrativeness
negativeness1656084__negativeness
operativenesses2055774_operativenesses
pervasiveness2155134__pervasiveness
repetitiveness1963844repetitiveness
sportiveness1766984_spor_tiveness
temperateness1764424temperat__eness
vegetativeness2173254vegetativeness

Search took 4 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.330541487.9
2DLD Change Limit65874373.17020780.4
3Display Results37370.0162312.5
 (SQL Overall)178691373.51650822.2
 
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.