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

137 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
masterfulness185351(None) 
masterfulnesses2053292masterfulnesses
tastefulness1554852taste_fulness
wastefulness1854832waste_fulness
fatefulness1746013fa_te_fulness
hatefulness1745963ha_te_fulness
masterliness1463833master_liness
materialness1454663ma_terialness
artfulness1346404_art__fulness
balefulness1645014ba_le_fulness
bashfulness1954224bas__hfulness
boastfulness1754414boast__fulness
carefulness1645954ca_re_fulness
cheerfulness2053584_cheerfulness
faithfulness2154224fait_hfulness
gratefulness1655744grate_fulness
lustfulness1445314lust__fulness
manfulness1545644ma___nfulness
masterful1443654masterful____
masterfully1982714masterful__ly
mirthfulness2053744mirt_hfulness
mysteriousness1953434mysteriousness
pastoralness1453604pastor_alness
prayerfulness2162684prayerfulness
restfulness1447234rest__fulness
spitefulness1754604spite_fulness
tactfulness1645224tact__fulness
tastefulnesses1754604taste_fulnesses
tearfulness1445484___tearfulness
usefulness1345724_us_e_fulness
wakefulness2154584wa_ke_fulness
wastefulnesses2054524waste_fulnesses
watchfulness2353084wa_tchfulness
wistfulness1745274wist__fulness
wonderfulness2062874wonderfulness
zestfulness2345314zest__fulness
afterburners176755_afterburners
asteriskless1651235_asteriskless
austereness1154295auster__eness
awfulness1544415_a___wfulness
beautifulness1853455beaut_ifulness
boisterousness1662845boisterousness
changefulness2262555change_fulness
colorfulness1753825_colorfulness
dangerousness1554435dangerousness
dastardliness1561375dastardliness
despitefulness2062545despite_fulness
dexterousness2154625dexterousness
distastefulness1971795distaste_fulness
distressfulness18101795distressfulness
dolefulness1544885_dole_fulness
dutifulness1555085_dut_ifulness
easterlies1046715easter__lie_s
easterners1044825easter___ners
eternalness1153825__eternalness
fancifulness2053755fa_ncifulness
fatefulnesses1945995fa_te_fulnesses
fearfulness1745225__fearfulness
fitfulness1645735_fit__fulness
forcefulness2054455force_fulness
forgetfulness2053745forgetfulness
fretfulness1776225__fretfulness
gainfulness1544615ga__infulness
gaseousness1246055gas_e_ousness
gleefulness1554065__gleefulness
gracefulness1855245grace_fulness
guilefulness1653725guile_fulness
harmfulness1984285ha__rmfulness
hatefulnesses1945805ha_te_fulnesses
healthfulness2252905healt_hfulness
heedfulness18104075__heedfulness
hopefulness1954875_hope_fulness
hurtfulness1755015hurt__fulness
lawfulness1643855la___wfulness
literalness1145495_liter_alness
lusterless1043695luster__l_ess
lustrousness1255895lust_rousness
mannerless1243525manner__l_ess
mannerliness1452565manner_liness
marvelousness1853705marvelousness
masteries111018495master___ie_s
masterlinesses1673525master_linesses
masterminds16102415master_min_ds
masterpieces1851885masterpiece_s
mastersingers1671205mastersingers
mastless102610025mast____l_ess
mateless102711295ma_te___l_ess
materialises1447325ma_terialises
materialnesses1653915ma_terialnesses
mateyness1444475ma_te___yness
matterful1443195matterful____
meaningfulness2061345meaningfulness
mercifulness1964415m_ercifulness
mindfulness1754065m__indfulness
miserableness17145755mis_erableness
miserliness1344915mis_er_liness
mistrustfulness20141905mistrustfulness
monstrousness1584865monst_rousness
mournfulness1753345m_ournfulness
murderousness1653935murderousness
naturalness1153955na_tur_alness
needfulness1593995__needfulness
painfulness1645085pa__infulness
patternless1342285patter_nl_ess
peacefulness1954985peace_fulness
pitifulness1665485_pit_ifulness
pridefulness1854325pride_fulness
pushfulness1954145pus__hfulness
rapturousness1554285rapturousness
regretfulness1753875regretfulness
resentfulness1664795resentfulness
respectfulness2163275respectfulness
ruefulness1346105__rue_fulness
ruthfulness1754985_rut_hfulness
scornfulness1753225__scornfulness
shamefulness2074155shame_fulness
sinfulness1345845__s_infulness
slothfulness1853505slot_hfulness
songfulness1554585__songfulness
soulfulness1444485__soulfulness
sportfulness1754785__sportfulness
sternness946095__ster__nness
tasteless935675taste___l_ess
tastelessness1254195tastelessness
tristfulness1564985trist__fulness
trustfulness1565065trust__fulness
truthfulness1864415trut_hfulness
tunefulness1455245_tune_fulness
vengefulness1953875venge_fulness
voicefulness2053645voice_fulness
wateriness1348075wa_ter__iness
waterishness1853265wa_terishness
waterless1238015wa_ter__l_ess
wishfulness2054345wis__hfulness
woefulness1645265__woe_fulness
wrathfulness2154515wrat_hfulness
youthfulness2153645yout_hfulness

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.390458182.1
2DLD Change Limit1247901378.98613887.2
3Display Results1371370.0931473.1
 (SQL Overall)1786911379.46918871.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.