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

66 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
despitefulness206254(None) 
spitefulness1754602__spitefulness
deceitfulness1963543deceit_fulness
despiteful1651734despiteful____
despitefully2161784despiteful__ly
distastefulness1971794distastefulness
pitifulness1665484___pitifulness
reposefulness1862814re_posefulness
resentfulness1664794resent_fulness
respectfulness2163274respectfulness
restfulness1447234res__t_fulness
spitefullest1762334__spitefullest
spitefulnesses1954414__spitefulnesses
tastefulness1554854tas__tefulness
wastefulness1854834was__tefulness
zestfulness2345314zes__t_fulness
beautifulness1853455be_autifulness
deceitfulnesses2173045deceit_fulnesses
delightfulness2261895delightfulness
desirousness1356875des_i_rousness
despicableness2164125despicableness
despiteous1352325despiteou____s
destituteness1462925destit_uteness
disdainfulness1991575disdainfulness
disgracefulness2271675disgracefulness
dolefulness1544885d___olefulness
doubtfulness1853685d_oubt_fulness
dutifulness1555085d___utifulness
eventfulness1854645_event_fulness
faithfulness2154225__faithfulness
fatefulness1746015___fatefulness
fitfulness1645735___fit_fulness
fruitfulness1854885_fruit_fulness
gratefulness1655745__gratefulness
guilefulness1653725__guilefulness
hatefulness1745965___hatefulness
healthfulness2252905he_althfulness
helpfulness1953485help___fulness
hopefulness1954875_hop__efulness
lustfulness1445315lus__t_fulness
masterfulness1853515mas__terfulness
meaningfulness2061345meaningfulness
mercifulness1964415merci__fulness
peacefulness1954985pe__acefulness
piteousness1347265___piteousness
pridefulness1854325__pridefulness
purposefulness2161605purposefulness
regretfulness1753875regret_fulness
remorsefulness1962175remorsefulness
resourcefulness2071525resourcefulness
revengefulness2161825revengefulness
shamefulness2074155__shamefulness
sinfulness1345845__s_i_nfulness
skillfulness1952445__skillfulness
slothfulness1853505__slothfulness
spitefuller1651385__spitefulle_r
sportfulness1754785__sportfulness
suspensefulness19111435suspensefulness
unfaithfulness2371685unfaithfulness
ungratefulness1862455ungratefulness
unskillfulness2171145unskillfulness
usefulness1345725_us___efulness
vengefulness1953875ve__ngefulness
voicefulness2053645__voicefulness
wearifulness1854805weari__fulness
wistfulness1745275wis__t_fulness

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.360496363.9
2DLD Change Limit95024666.83013912.7
3Display Results66660.0431534.9
 (SQL Overall)178691667.23324705.0
 
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.