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

67 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
disgracefulness227167(None) 
gracefulness1855243___gracefulness
disdainfulness1991574dis_dainfulness
disgraceful1861684disgraceful____
disgracefully23101544disgraceful__ly
distastefulness1971794distastefulness
distressfulness18101794distressfulness
distrustfulness19132344distrustfulness
gratefulness1655744___gratefulness
ungratefulness1862454_ungratefulness
despitefulness2062545des_pitefulness
forcefulness2054455__for_cefulness
gracefullest1893085___gracefullest
gracefulnesses20154915___gracefulnesses
mistrustfulness20141905mistrustfulness
peacefulness1954985___peacefulness
resourcefulness2071525resourcefulness
shamefulness2074155__s_hamefulness
balefulness1645016____balefulness
carefulness1645956____carefulness
discreetness1553036discr__e_etness
discreteness1554486discr__e_teness
disgracers1444736disgrac_____ers
disgraces1348456disgrac_____e_s
dismalness1344046dis_ma____lness
disorderedness1771246disor_deredness
disorderliness1661036disor_derliness
disparateness1684196disparate___ness
dolefulness1544886d____olefulness
dreadfulness1763886d___readfulness
dreamfulness1853596d___reamfulness
fatefulness1746016____fatefulness
gainfulness1544616___g_ainfulness
gleefulness1554066___g_leefulness
gracefuller1752286___gracefulle_r
graceless12226896___grace__l_ess
graciousness1548426___graciousness
gratefullest1683136___gratefullest
gratefulnesses18135416___gratefulnesses
guilefulness1653726___guilefulness
hatefulness1745966____hatefulness
mercifulness1964416__mer_cifulness
mirthfulness2053746mi__r_thfulness
neglectfulness2082086_neglectfulness
prayerfulness2162686___prayerfulness
pridefulness1854326___pridefulness
regardfulness1862896_reg_ardfulness
regretfulness1753876_regr_etfulness
remorsefulness1962176remor_sefulness
reproachfulness2591166reproachfulness
respectfulness2163276res_pectfulness
rightfulness1994896ri_g__htfulness
ruefulness1346106____r_uefulness
sorrowfulness1962226__sorrowfulness
spitefulness1754606__s_pitefulness
suspensefulness19111436suspensefulness
tactfulness1645226____tactfulness
tastefulness1554856tas___tefulness
ungraciousness1753856_ungraciousness
usefulness1345726_us____efulness
vengefulness1953876veng___efulness
voicefulness2053646___voicefulness
wakefulness2154586____wakefulness
wastefulness1854836was___tefulness
wishfulness2054346wis____hfulness
wistfulness1745276wis____tfulness
wrathfulness2154516___wrathfulness

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 Filter178691950240.376475242.0
2DLD Change Limit95024677.95311948.2
3Display Results67670.0461456.5
 (SQL Overall)178691678.37521336.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.