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

176 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
mercifulnesses215427(None) 
mercifulness1964422mercifulne_s_s
fancifulnesses2254003fancifulnesses
forcefulnesses2254173forcefulnesses
mirthfulnesses2253643mirthfulnesses
peacefulnesses2154703peacefulnesses
wearifulnesses2054653wearifulnesses
artfulnesses1546654_ar_tfulnesses
beautifulnesses2083454beautifulnesses
carefulnesses1845694car_efulnesses
deceitfulnesses2173044deceitfulnesses
dreadfulnesses19193794dreadfulnesses
dreamfulnesses20183694dreamfulnesses
dutifulnesses1755114_dutifulnesses
fearfulnesses1945314fe_arfulnesses
ferociousnesses2055844ferociousnesses
fretfulnesses1945904_fretfulnesses
fruitfulnesses2094634_fruitfulnesses
gracefulnesses20154914gracefulnesses
harmfulnesses2164304har_mfulnesses
heedfulnesses20124104he_edfulnesses
helpfulnesses2153544he_lpfulnesses
hurtfulnesses1954854hur_tfulnesses
manfulnesses1745834m__anfulnesses
mercilessnesses18104534mercilessnesses
mercurialnesses1981434mercurialnesses
merrinesses1358264merri___nesses
mindfulnesses1954434m_indfulnesses
mournfulnesses1963424mournfulnesses
needfulnesses17134094ne_edfulnesses
perviousnesses1957304perviousnesses
pitifulnesses1855574_pitifulnesses
plentifulnesses2093174plentifulnesses
preciousnesses1857534preciousnesses
regretfulnesses1963274regretfulnesses
restfulnesses1646624re_stfulnesses
ruefulnesses1545934__ruefulnesses
seriousnesses1249904ser_iousnesses
tactfulnesses1855264_tactfulnesses
tearfulnesses1645534te_arfulnesses
vengefulnesses2153654vengefulnesses
veraciousnesses20156534veraciousnesses
verticalnesses1953674verticalnesses
voicefulnesses2253574voicefulnesses
watchfulnesses2552984watchfulnesses
zestfulnesses2555004ze_stfulnesses
atrociousnesses1754865atrociousnesses
awfulnesses1744945___awfulnesses
balefulnesses1844855_balefulnesses
bashfulnesses2154185_bashfulnesses
blissfulnesses1852835blissfulnesses
boastfulnesses1954035boastfulnesses
bountifulnesses2073195bountifulnesses
cheerfulnesses2253385cheerfulnesses
civilnesses1644855___civilnesses
coercivenesses2165655coerci_venesses
colorfulnesses1993835colorfulnesses
cordialnesses1654575cordi_alnesses
curiousnesses1549035cur_iousnesses
decidednesses1853895de_cidednesses
deliciousnesses1855875deliciousnesses
deviousnesses1747745de_viousnesses
dolefulnesses1774845_dolefulnesses
doubtfulnesses2053705doubtfulnesses
eerinesses10612605eer_i___nesses
enviousnesses1647895_enviousnesses
ethicalnesses1853205_ethicalnesses
eventfulnesses2054275eventfulnesses
evilnesses1346005_e_vi__lnesses
faithfulnesses2354405faithfulnesses
fancifulness2053765fancifulne_s_s
fatefulnesses1945995_fatefulnesses
fertilenesses1648035ferti_lenesses
fervidnesses1943845fervi__dnesses
fitfulnesses1866025__fitfulnesses
forcefulness2054455forcefulne_s_s
forciblenesses2154195forciblenesses
forgetfulnesses2262985forgetfulnesses
frailnesses1447605_frai__lnesses
fulnesses1239055_____fulnesses
gainfulnesses17124625_gainfulnesses
germinesses1437885germi___nesses
gleefulnesses1764255_gleefulnesses
graciousnesses1757735graciousnesses
gratefulnesses18135415gratefulnesses
guilefulnesses1853585guilefulnesses
hatefulnesses1945805_hatefulnesses
healthfulnesses2492905healthfulnesses
herculeses15113015herc__ul_e_ses
hopefulnesses2184595_hopefulnesses
imperiousnesses1955485imper_iousnesses
jerkinesses2246055jerki___nesses
joyfulnesses2553505__joyfulnesses
lawfulnesses1844145__lawfulnesses
lusciousnesses1556245lusciousnesses
lustfulnesses1655155_lustfulnesses
lyricalnesses1853105lyr_icalnesses
maliciousnesses19195985maliciousnesses
manifoldnesses2061445m_anifoldnesses
marchionesses2052365marc_hionesses
masterfulnesses2053295masterfulnesses
materialnesses1653915mater_i_alnesses
mealinesses13310975meali___nesses
meatinesses13311985meati___nesses
melodiousnesses1855055melodiousnesses
mercenarinesses1961775mercenarinesses
merciless1344475merci__l_e_s_s
mercilessly1852185merci__l_essly
mercilessness1753465merci__l_essness
messinesses1297515messi___nesses
miffinesses1944365m___iffinesses
mirinesses121512325mir_i___nesses
mirthfulness2053745mirthfulne_s_s
morbidnesses1743975morbi__dnesses
murkinesses17136785murki___nesses
nerdinesses1249055nerdi___nesses
nervinesses1437325nervi___nesses
nervousnesses1646905ner_vousnesses
painfulnesses18115155_painfulnesses
peacefulness1954995peacefulne_s_s
perilousnesses1667275perilousnesses
perkinesses1748935perki___nesses
playfulnesses2153645_playfulnesses
precisenesses1756285preci_senesses
previousnesses1966495previousnesses
pridefulnesses2053895pridefulnesses
pushfulnesses2153945_pushfulnesses
regardfulnesses2072525regardfulnesses
reposefulnesses2062575reposefulnesses
resentfulnesses1883745resentfulnesses
rifenesses1339955__r_if_enesses
rightfulnesses2174465rightfulnesses
ruthfulnesses1954945_ruthfulnesses
scornfulnesses1953205scornfulnesses
serriednesses1454275serri_ednesses
servilenesses1646305servi_lenesses
shamefulnesses2253685shamefulnesses
shrillnesses1543505shr_i_llnesses
sinfulnesses1546135__sinfulnesses
skillfulnesses2152655skillfulnesses
slothfulnesses2053465slothfulnesses
songfulnesses1754675_songfulnesses
sorrowfulnesses2161965sorrowfulnesses
soulfulnesses1654555_soulfulnesses
spaciousnesses17147185spaciousnesses
specialnesses1753865speci_alnesses
speciousnesses17146905speciousnesses
spitefulnesses1954415spitefulnesses
sportfulnesses1964175sportfulnesses
tastefulnesses1754605tastefulnesses
tediousnesses1447775te_diousnesses
tenaciousnesses1756075tenaciousnesses
terriblenesses1694395terriblenesses
thankfulnesses2453095thankfulnesses
thriftinesses1952325thr_iftinesses
tristfulnesses1774335tristfulnesses
trustfulnesses1764315trustfulnesses
truthfulnesses2054115truthfulnesses
tunefulnesses1655135_tunefulnesses
undutifulnesses1962675undutifulnesses
unlawfulnesses2052985unlawfulnesses
usefulnesses1545825__usefulnesses
variousnesses1648695var_iousnesses
venialnesses1555705ve_ni_alnesses
viciousnesses1848065_viciousnesses
voraciousnesses20146195voraciousnesses
wakefulnesses2354295_wakefulnesses
wastefulnesses2054525wastefulnesses
wearifulness1854815wearifulne_s_s
willfulnesses1953885_willfulnesses
wishfulnesses2254285_wishfulnesses
wistfulnesses1955545_wistfulnesses
woefulnesses1845345__woefulnesses
wrathfulnesses2354375wrathfulnesses
wrongfulnesses2153175wrongfulnesses
youthfulnesses2353735youthfulnesses

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 Limit950241766.51314589.9
3Display Results1761760.1261396.8
 (SQL Overall)1786911766.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.