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

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

111 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
joyousnesses224466(None) 
joyfulnesses2553502joyfulnesses
joyousness2043622joyousne_s_s
porousnesses1469282porousnesses
amorousnesses1547813amorousnesses
bogusnesses1444843bo_gusnesses
copiousnesses1747803copiousnesses
famousnesses1745713famousnesses
jealousnesses2056323jealousnesses
jocosenesses2143973jocosenesses
joylessnesses2255643joylessnesses
noxiousnesses2047173noxiousnesses
odiousnesses1347993odiousnesses
odorousnesses1456733odorousnesses
piousnesses1348983_piousnesses
pompousnesses1955463pompousnesses
riotousnesses1357303riotousnesses
anonymousnesses2062784anonymousnesses
anxiousnesses2057694anxiousnesses
arduousnesses1456544arduousnesses
biliousnesses1547294biliousnesses
boozinesses22175804bo_ozinesses
boyishnesses2044034boyishnesses
callousnesses1556464callousnesses
canorousnesses16127064canorousnesses
cohostesses1652544coho_stesses
coolnesses1237194co_o_lnesses
covetousnesses1955224covetousnesses
coynesses1437574coy___nesses
crossnesses1247124_crossnesses
curiousnesses1549014curiousnesses
decorousnesses1756564decorousnesses
deviousnesses1747734deviousnesses
devoutnesses1683934devoutnesses
dolorousnesses1555784dolorousnesses
dournesses1138244__dournesses
dubiousnesses1677074dubiousnesses
emulousnesses1556104emulousnesses
enormousnesses1655874enormousnesses
enviousnesses1647884enviousnesses
fatuousnesses1686864fatuousnesses
foulnesses1337934__foulnesses
gaseousnesses1356704gaseousnesses
gloriousnesses1556914gloriousnesses
goodnesses1236434go_o_dnesses
gooeynesses1544194go_oeynesses
goofinesses1535964go_ofinesses
gorgeousnesses1655094gorgeousnesses
grossnesses1146714_grossnesses
heinousnesses1655554heinousnesses
hideousnesses1755844hideousnesses
humorousnesses1955444humorousnesses
joblessnesses2155994joblessnesses
jokinesses2147534j__okinesses
jollinesses1836724jo_llinesses
jowlinesses2135324jo_wlinesses
joyfulness2343204joyfulne_s_s
justnesses1736494j___ustnesses
kookinesses1435374ko_okinesses
looninesses1197994lo_oninesses
loopinesses13116734lo_opinesses
loosenesses1147244lo_osenesses
loudnesses1138434__loudnesses
lousinesses111210324__lousinesses
moodinesses14147644mo_odinesses
mooninesses13127944mo_oninesses
mootnesses1237154mo_o_tnesses
morosenesses1446864morosenesses
mousinesses13129834__mousinesses
nervousnesses1646894nervousnesses
obtusenesses1445064_obtusenesses
obviousnesses1866294obviousnesses
ominousnesses1556184ominousnesses
onerousnesses1348974onerousnesses
oozinesses19178024_o_ozinesses
piteousnesses1557174piteousnesses
poornesses1236804po_o_rnesses
populousnesses1864744populousnesses
porousness1248444porousne_s_s
proudnesses1447504_proudnesses
raucousnesses1556564raucousnesses
rigorousnesses1565854rigorousnesses
robustnesses1443784ro_bustnesses
roominesses1337434ro_ominesses
rootinesses1139524ro_otinesses
ruinousnesses1356424ruinousnesses
seriousnesses1249884seriousnesses
sinuousnesses1247314sinuousnesses
sonorousnesses1356514sonorousnesses
sootinesses11410054so_otinesses
sournesses10310014__sournesses
stoutnesses1146974_stoutnesses
tediousnesses1447764tediousnesses
tenuousnesses1357054tenuousnesses
timorousnesses1655694timorousnesses
tortuousnesses1455764tortuousnesses
uxoriousnesses2156304uxoriousnesses
vacuousnesses1896514vacuousnesses
vaporousnesses1956004vaporousnesses
variousnesses1648674variousnesses
venomousnesses1954984venomousnesses
viciousnesses1848054viciousnesses
vigorousnesses1865524vigorousnesses
viscousnesses1786004viscousnesses
woefulnesses1845344woefulnesses
wondrousnesses1855844wondrousnesses
woodinesses15127464wo_odinesses
woolinesses14157504wo_olinesses
woozinesses23175634wo_ozinesses
youngnesses1544284__youngnesses
zealousnesses2256264zealousnesses

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 Filter1786911247900.1431249587.4
2DLD Change Limit1247901117.10617561.2
3Display Results1111110.0631761.9
 (SQL Overall)1786911117.31224438.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.