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

44 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
haggardnesses195225(None) 
laggardnesses1652391laggardnesses
haggardness1752332haggardne_s_s
hardnesses141810543h___ardnesses
jaggednesses2242793jagg_ednesses
laggardness1452373laggardne_s_s
raggednesses1543863ragg_ednesses
sluggardnesses1761283sluggardnesses
waywardnesses2351763waywardnesses
absurdnesses1562724_absurdnesses
agednesses1237414_a_g_ednesses
aggresses1146144_agg_r__esses
algidnesses1345164_alg_idnesses
angrinesses1247284_ang_rinesses
apartnesses1346824_a_partnesses
awarenesses1447254_a_warenesses
awkwardnesses2451824awkwardnesses
backwardnesses2661304backwardnesses
bagginesses1545954bagg__inesses
beggarlinesses1871884beggarlinesses
doggednesses1643704dogg_ednesses
eagernesses1246984ea_ger_nesses
forwardnesses20123264forwardnesses
frowardnesses20112894frowardnesses
gladnesses1236684__gla_dnesses
glarinesses1239514__glarinesses
grandnesses1348114__grandnesses
hairinesses14198944ha__irinesses
handednesses1765644ha_ndednesses
haphazardnesses337884haphazardnesses
hardinesses151110224h___ardinesses
harnesses121812074h___ar_nesses
haughtinesses2042164haughtinesses
hoarinesses14310224h__oarinesses
hoggishnesses21143654hoggishnesses
hungrinesses1643854hung_rinesses
inwardnesses1654674_inwardnesses
languidnesses1552404languidnesses
niggardlinesses1871354niggardlinesses
outwardnesses1752614outwardnesses
ruggednesses1543324rugg_ednesses
shagginesses1743964shagg__inesses
upwardnesses1843094_upwardnesses
waggishnesses2143284waggishnesses

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 Filter178691950240.373479064.3
2DLD Change Limit95024444.69020261.0
3Display Results44440.0133384.6
 (SQL Overall)178691445.07635203.1
 
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.