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

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

58 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
ungratefulness186245(None) 
gratefulness1655742__gratefulness
gracefulness1855243__gracefulness
untruthfulness2061923untruthfulness
disgracefulness2271674disgracefulness
fatefulness1746014___fatefulness
gratefullest1683134__gratefullest
gratefulnesses18135414__gratefulnesses
hatefulness1745964___hatefulness
regretfulness1753874regret_fulness
undutifulness1762704un_dutifulness
unfaithfulness2371684unfaithfulness
unfruitfulness2062014unfruitfulness
ungraciousness1753854ungraciousness
ungrateful1462114ungrateful____
ungratefully1962354ungrateful__ly
unlawfulness1852594un_la_wfulness
wrathfulness2154514__wrathfulness
artfulness1346405__ar_t_fulness
balefulness1645015___balefulness
carefulness1645955___carefulness
despitefulness2062545despitefulness
distastefulness1971795distastefulness
forcefulness2054455_for_cefulness
forgetfulness2053745forget_fulness
fretfulness1776225__fret_fulness
gainfulness1544615__g_ainfulness
gleefulness1554065__g_leefulness
gracefullest1893085__gracefullest
gracefulnesses20154915__gracefulnesses
gratefuller1552185__gratefulle_r
grateless10277585__grate__l_ess
guilefulness1653725__guilefulness
hurtfulness1755015_hur_t_fulness
mirthfulness2053745_mir_thfulness
peacefulness1954985__peacefulness
prayerfulness2162685__prayerfulness
pridefulness1854325__pridefulness
regardfulness1862895reg_ardfulness
rightfulness1994895rig_ht_fulness
ruefulness1346105___r_uefulness
ruthfulness1754985___ruthfulness
shamefulness2074155__shamefulness
spitefulness1754605__spitefulness
sportfulness1754785spor_t_fulness
tastefulness1554855__tastefulness
truthfulness1864415__truthfulness
tunefulness1455245tun____efulness
umbrageousness1961915umbrageousness
uneventfulness2062035uneventfulness
ungraceful1652295ungraceful____
ungracefully2192345ungraceful__ly
unnaturalness1362265un_naturalness
unskillfulness2171145unskillfulness
usefulness1345725u____sefulness
vengefulness1953875veng___efulness
wakefulness2154585___wakefulness
wastefulness1854835__wastefulness

Search took 8 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.356501941.0
2DLD Change Limit95024586.69014203.9
3Display Results58580.0461260.9
 (SQL Overall)178691587.09225196.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.