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

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

139 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
suchness133576(None) 
muchness1534071muchness
archness1337512archness
butchness1643452butchness
duchess1335552duch_ess
lushness1136232lushness
richness1337432richness
sauciness1138042sauciness
sickness1437832sickness
success1146402suc_cess
suchnesses1536672suchnesses
suckless14288822suckless
sureness8912902sureness
achiness1339703_achiness
bushiness14177763bushiness
bushless1335813bushless
business102110693business
busyness13264813busyness
chess105016923__ch_ess
curtness1037263curtness
cushiness14197183cushiness
cuteness1039673cuteness
duchies133312313duchie_s
ductless11196313ductless
dueness82310123du_eness
dullness934873dullness
dulness8307983du_lness
dumbness1334613dumbness
dunness8298983du_nness
euchres1288663euchre_s
flushness1544893flushness
fullness1135443fullness
fulness10248963fu_lness
gaucheness1642773gaucheness
gushiness13206853gushiness
highness1536053highness
hugeness1237373hugeness
iciness938863_iciness
itchiness1444753itchiness
juiciness1835153juiciness
justness1535323justness
kuchens1634713kuch_ens
laciness102112553laciness
lucidness1244313lucidness
luckiness1596573luckiness
luckless14265893luckless
muches134718993much_e_s
muchnesses1744713muchnesses
mushiness14248223mushiness
muteness1039013muteness
niceness1039843niceness
nighness1236103nighness
nudeness936733nudeness
numbness1234413numbness
ouches114322183ouch_e_s
packness1636933packness
plushness1444623plushness
poshness1356653poshness
punchless1643653punchless
puniness101610273puniness
pureness101110183pureness
pushiness14197283pushiness
quickness2443733quickness
raciness102413453raciness
rashness1138093rashness
roughness1345763roughness
ruches114819583ruch_e_s
rudeness938083rudeness
ruthless1135413ruthless
sachems14348903sach_ems
sachets123914103sach_ets
sadness8310613s_adness
safeness11239633safeness
sageness92111983sageness
saltness82610243saltness
sameness102712683sameness
saneness82313723saneness
sashless1136603sashless
scenes84520353s_cene_s
schleps1445483s_chleps
schnaps1443703s_chnaps
schuss11186733s_ch_uss
scones84521303s_cone_s
scumless1254993scumless
scunners10357303scunners
selfness1135153selfness
sexiness1537943sexiness
shyness1344993s_hyness
sighless1276553sighless
siziness1737423siziness
skewness1533763skewness
slackness1535433slackness
slickness1535903slickness
slimness1036523slimness
slouchiness1642653slouchiness
slowness1135013slowness
slushiness1344643slushiness
slyness1035263s_lyness
smugness1143813smugness
snubness1044373snubness
snugness934323snugness
sockless14267793sockless
softness1136433softness
soleness8814263soleness
soreness8914793soreness
soundness1036963soundness
sourness839543sourness
spaciness1337083spaciness
spiciness1347053spiciness
spruceness1444103spruceness
spryness1334003spryness
squatness1844943squatness
staunchness1651693staunchness
suaveness1247703suaveness
subchiefs1942743subchiefs
subnets92512083su_bnets
succeeds1343693succeeds
succuss1134993suc_cuss
suckers133717623suc_kers
suckiest143314113suckiest
sucklers14379963sucklers
suckles134516743suckle_s
sucrases10310253sucrases
sucres84218893suc_re_s
sucroses1039933sucroses
sudsless944353sudsless
sulkiness1347353sulkiness
sultaness945613sultaness
sumless92611123su_mless
sundress936983sundress
sunless73013693su_nless
sunniness9247943sunniness
supines94216383supine_s
suppress1236443suppress
surliness939943surliness
touchiness1544613touchiness
toughness1355093toughness
usualness993563usualness
yuckiness1874923yuckiness

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621398.42317352.7
3Display Results1391390.0632206.3
 (SQL Overall)1786911398.88920102.5
 
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.