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

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

171 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
wholesomenesses2361911wholesomenesses_
wholesomeness2162403wholesomene_s_s_
lonesomenesses1653794_lonesomenesses_
awesomenesses1853385__awesomenesses_
fulsomenesses1853125_ful_somenesses_
gamesomenesses1962725_gamesomenesses_
gruesomenesses1753075_gruesomenesses_
handsomenesses2062705_handsomenesses_
longsomenesses1763085_longsomenesses_
noisomenesses1554245_no_isomenesses_
tiresomenesses1653345_tiresomenesses_
toilsomenesses1662705_toilsomenesses_
toothsomenesses2061905toothsomenesses_
wearisomenesses2062415wearisomenesses_
welcomenesses2052585w_el_comenesses_
wholenesses1745805whol____enesses_
winsomenesses1854045w__insomenesses_
worrisomenesses2062275worrisomenesses_
cohesivenesses2256206_cohesivenesses_
fearsomenesses1953196_fearsomenesses_
footsorenesses1792226_footsorenesses_
gladsomenesses1892386_gladsomenesses_
grotesquenesses2561516grotesquenesses_
hoarsenesses1545606_hoars__enesses_
hollownesses1852286_hol_lo_wnesses_
homesicknesses2561596_homesicknesses_
irksomenesses1953196__irksomenesses_
lightsomenesses2161826lightsomenesses_
lissomenesses1453476__lissomenesses_
loathsomenesses20112116loathsomenesses_
lonesomeness1454116_lonesomene_s_s_
obesenesses1346766__obes__enesses_
operosenesses1575326__operosenesses_
selfsamenesses1892146_selfsamenesses_
solemnnesses1443636_sole__mnnesses_
wholesomest1952916wholesom_____est
witlessnesses1547236witles__snesses_
woebegonenesses216876woebegonenesses_
adhesivenesses2155057_adhesivenesses_
agelessnesses1387627ageles__snesses_
aimlessnesses1487467aimles__snesses_
airlessnesses12117997airles__snesses_
allusivenesses1755197_allusivenesses_
alonenesses1147217__al__onenesses_
artlessnesses1247667artles__snesses_
awesomeness1653407__awesomene_s_s_
blessednesses1552857__blessednesses_
bootlessnesses1556457bootles__snesses_
chastenesses1746317ch__as_tenesses_
cheesinesses1765377ch_ees__inesses_
childlikenesses25131067childlikenesses_
choicenesses1944677cho___icenesses_
closenesses1347847__cl__osenesses_
coarsenesses1447247_coars__enesses_
cocksurenesses2261847_cocksurenesses_
covetousnesses1955227_covetousnesses_
delusivenesses1856547_delusivenesses_
dolefulnesses1774847_dole_fulnesses_
dolorousnesses1555787_dolorousnesses_
elusivenesses1697707__elusivenesses_
endlessnesses1356767endles__snesses_
erosivenesses1648317ero__sivenesses_
exclusivenesses2764667exclusivenesses_
explosivenesses2793927explosivenesses_
extremenesses2252887extre__menesses_
falsenesses1446747_fal_s__enesses_
fleshinesses18114367__fles_hinesses_
folksinesses1964067_folks__inesses_
foodlessnesses1755767foodles__snesses_
foolishnesses1944467foolis__hnesses_
footlessnesses1656567footles__snesses_
fulsomeness1652847_ful_somene_s_s_
gamesomeness1753207_gamesomene_s_s_
ghostlinesses1742497gho__stlinesses_
ghoulishnesses2152287ghoulis__hnesses_
gloominesses1544127__gl_oominesses_
godlessnesses1446587godles__snesses_
gruesomeness1553067_gruesomene_s_s_
gutlessnesses1346947gutles__snesses_
halenesses13312047_hal____enesses_
handsomeness1853057_handsomene_s_s_
haplessnesses1747257haples__snesses_
hideousnesses1755847_hide_ousnesses_
hirsutenesses1653597_h_irsutenesses_
hokeynesses2193717_hoke___ynesses_
holinesses13511497_hol____inesses_
homelessnesses18137477_homelessnesses_
homelinesses1765367_home__linesses_
homeynesses1984817_home___ynesses_
hominesses15510867_h____ominesses_
hoodednesses1744497_ho___odednesses_
hopefulnesses2184597_hope_fulnesses_
hopelessnesses18147017_hopelessnesses_
hornlessnesses1656277_hornles__snesses_
horriblenesses1953907_horriblenesses_
horsinesses1439557_ho_rs__inesses_
illusivenesses1755787_illusivenesses_
illusorinesses1461657_illusorinesses_
inclusivenesses2065117inclusivenesses_
joblessnesses2155997jobles__snesses_
jocosenesses2143977_jo__cosenesses_
joylessnesses2255647joyles__snesses_
lamenesses12610567___l__amenesses_
lawlessnesses1546387lawles__snesses_
lonenesses10311347___l__onenesses_
longsomeness1553157_longsomene_s_s_
loosenesses1147247___l_oosenesses_
lovelornnesses1761407_lovelornnesses_
lovesicknesses2361597_lovesicknesses_
meddlesomeness207937meddlesomene_s_s_
moderatenesses1764407_moderatenesses_
morosenesses1446867_mo__rosenesses_
noisomeness1354077_no_isomene_s_s_
obsoletenesses1662227obsole__tenesses_
onerousnesses1348977__onerousnesses_
otiosenesses1245707__o_tiosenesses_
plotlessnesses1556097plotles__snesses_
politenesses1448597_pol__itenesses_
profusenesses18113877profus__enesses_
raylessnesses1546507rayles__snesses_
reclusivenesses2055287reclusivenesses_
reflexivenesses2893397reflexivenesses_
remotenesses1446817___remotenesses_
repletenesses1554497reple__tenesses_
roominesses1337437_ro___ominesses_
rootlessnesses1346607rootles__snesses_
samenesses12410857_____samenesses_
saplessnesses1347277saples__snesses_
seclusivenesses1965057seclusivenesses_
sexlessnesses1846747sexles__snesses_
shallownesses1951557shal_lo_wnesses_
sinlessnesses1157987sinles__snesses_
solenesses10412707_____solenesses_
sorenesses101313497_____sorenesses_
spotlessnesses1456277spotles__snesses_
sublimenesses1763387subl__imenesses_
supremenesses1753177supre__menesses_
tiresomeness1453607_tiresomene_s_s_
toilsomeness1452577_toilsomene_s_s_
toothsomeness1861947toothsomene_s_s_
toplessnesses1446587toples__snesses_
troublesomeness1971527troublesomene_s_s_
uselessnesses1147317useles__snesses_
violablenesses1984737viol_ablenesses_
volatilenesses1754477_volatilenesses_
volublenesses1854567_vol_ublenesses_
wearisomeness1862317wearisomene_s_s_
welcomeness1852707w_el_comene_s_s_
wheezinesses2742867wh__e_ezinesses_
whitenesses1746657wh____itenesses_
wholeness1545377whol____ene_s_s_
wholesome1744397wholesom_____e__
wholesomely2262117wholesom_____ely
wholesomer1853327wholesom_____e_r
winglessnesses1765467wingles__snesses_
winsomeness1653657w__insomene_s_s_
wisenesses13310827w___is__enesses_
woefulnesses1845347w_o_e_fulnesses_
woenesses1239137w_____o_enesses_
wolfishnesses2243737w_ol_fishnesses_
wondrousnesses1855847w_ondrousnesses_
woodennesses1643657woode___nnesses_
woodinesses15127467w_o___odinesses_
woolinesses14157507w_o___olinesses_
woollinesses15113797wool___linesses_
woozinesses23175637w_o___ozinesses_
wordlessnesses1775877wordles__snesses_
workablenesses2354447w_orkablenesses_
worklessnesses20125487workles__snesses_
worminesses16127997w_o___rminesses_
worrisomeness1882557worrisomene_s_s_

Search took 9 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.1231452772.4
2DLD Change Limit950241718.16011645.1
3Display Results1711710.1401221.4
 (SQL Overall)1786911718.42321214.7
 
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.