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

39 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
moderateness156528(None) 
immoderateness1982582immoderateness
moderatenesses1764402moderatenesses
literateness1256403literateness
moderates12710753moderat__e_s
modernness1343523moder__nness
obdurateness1553053obdurateness
accurateness1652884accurateness
adequateness2252724_adequateness
averageness1555034_averageness
concreteness1655054concreteness
considerateness1872134considerateness
contriteness1456454contriteness
covertness1545504cover_t_ness
desperateness1665194desperateness
immediateness1862934immediateness
irateness9310494___irateness
meatiness11311184m__e_atiness
miserableness17145754miserableness
moderate11710994moderat__e__
moderated1388144moderat__e_d
moderately1643424moderat__ely
moderating1448804moderatin__g
moderations1448274moderat_ions
moderators1386644moderat__ors
moderatos1286524moderat___os
modernes1138424moder___ne_s
modernest1248114moder___nest
modernnesses1543864modernnesses
moreness10911574mo__r__eness
moroseness1246224mo__roseness
oblateness1244894_o_blateness
operativeness1876664_operativeness
operoseness1354834_operoseness
ornateness1046714_o_rnateness
overtness1238224_over_t_ness
sedateness1146664__sedateness
separateness1455504separateness
temperateness1764424temperateness

Search took 9 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 Filter1786911247900.390458182.1
2DLD Change Limit124790397.58016463.1
3Display Results39390.0133000.0
 (SQL Overall)178691397.98322383.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.