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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
regretfulness175387(None) 
regretfulnesses1963272regretfulnesses
forgetfulness2053743forgetfulness
fretfulness1776223__fretfulness
neglectfulness2082083neglectfulness
regardfulness1862893regardfulness
resentfulness1664793resentfulness
respectfulness2163273respectfulness
restfulness1447233re__stfulness
rightfulness1994893rig_htfulness
artfulness1346404__ar_tfulness
carefulness1645954_care_fulness
deceitfulness1963544deceitfulness
eventfulness1854644_eventfulness
fearfulness1745224fear__fulness
frightfulness2363204frig_htfulness
gleefulness1554064__gleefulness
gratefulness1655744__gratefulness
heedfulness18104074he__edfulness
hurtfulness1755014_hur_tfulness
mercifulness1964414me_rcifulness
needfulness1593994ne__edfulness
peacefulness1954984peace_fulness
regretful1352724regretful____
regretfully1872504regretful__ly
remorsefulness1962174remorsefulness
reposefulness1862814reposefulness
ruefulness1346104r__ue_fulness
sportfulness1754784spor_tfulness
tearfulness1445484tear__fulness
ungratefulness1862454ungratefulness
vengefulness1953874venge_fulness
wearifulness1854804wear_ifulness
zestfulness2345314ze__stfulness
balefulness1645015_bale_fulness
beautifulness1853455beautifulness
boastfulness1754415_boastfulness
cheerfulness2053585_cheerfulness
delightfulness2261895delightfulness
despitefulness2062545despitefulness
dolefulness1544885_dole_fulness
doubtfulness1853685_doubtfulness
dreadfulness1763885dre__adfulness
dreamfulness1853595dre__amfulness
effortfulness18112415effortfulness
egregiousness1554695_egregiousness
fatefulness1746015_fate_fulness
fitfulness1645735___fitfulness
forcefulness2054455_forcefulness
forgetfulnesses2262985forgetfulnesses
fretfulnesses1945905__fretfulnesses
fruitfulness1854885_fruitfulness
gainfulness1544615__gainfulness
gracefulness1855245__gracefulness
guilefulness1653725guile_fulness
harmfulness1984285_har_mfulness
hatefulness1745965_hate_fulness
healthfulness2252905healthfulness
helpfulness1953485he__lpfulness
hopefulness1954875_hope_fulness
lustfulness1445315__lustfulness
masterfulness1853515masterfulness
mirthfulness2053745_mirthfulness
mournfulness1753345mour_nfulness
prayerfulness2162685prayerfulness
pridefulness1854325pride_fulness
regalness1045475reg____alness
regardfulnesses2072525regardfulnesses
regressiveness1864225regressiveness
regretters1144095regret___ters
repleteness1354175replet__eness
reproachfulness2591165reproachfulness
resentfulnesses1883745resentfulnesses
resourcefulness2071525resourcefulness
restfullest1454155re__stfullest
restfulnesses1646625re__stfulnesses
revengefulness2161825revengefulness
righteousness1763925righteousness
rightfulnesses2174465rig_htfulnesses
ruthfulness1754985r__uthfulness
scornfulness1753225scor_nfulness
secretiveness1865865secretiveness
shamefulness2074155shame_fulness
sorrowfulness1962225sorrowfulness
spitefulness1754605spite_fulness
sprightfulness2362205sprig_htfulness
tactfulness1645225__tactfulness
tastefulness1554855taste_fulness
tristfulness1564985_tristfulness
trustfulness1565065_trustfulness
truthfulness1864415__truthfulness
tunefulness1455245_tune_fulness
uneventfulness2062035uneventfulness
unfruitfulness2062015unfruitfulness
untruthfulness2061925untruthfulness
usefulness1345725__use_fulness
voicefulness2053645voice_fulness
wakefulness2154585_wake_fulness
wastefulness1854835waste_fulness
wistfulness1745275__wistfulness
woefulness1645265__woe_fulness
wonderfulness2062875wonderfulness
wrathfulness2154515__wrathfulness

Search took 10 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.453394461.4
2DLD Change Limit1247901039.36013332.3
3Display Results1031030.0801287.5
 (SQL Overall)1786911039.89318062.4
 
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.