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

164 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
dunnesses103770(None) 
duenesses1039331duenesses
dulnesses1037761dulnesses
danknesses1536252danknesses
dimnesses1238212dimnesses
donenesses11310562donenesses
dournesses1138242dournesses
drynesses1335362drynesses
duchesses1544132duchesses
dullnesses1135992dullnesses
dumbnesses1584602dumbnesses
dunness8298982dunne_s_s
duresses939172du_resses
fulnesses1239052fulnesses
puninesses121110752puninesses
wannesses1239232wannesses
adultnesses1244833adultnesses
aptnesses11168993aptnesses
badnesses1239253badnesses
bignesses1267963bignesses
bluenesses1237933bluenesses
bluntnesses1345393bluntnesses
boninesses121111453boninesses
boundnesses1446623boundnesses
burgesses1245513burgesses
businesses121411373businesses
busynesses15145503busynesses
canonesses1238423canonesses
confesses1438623confesses
countesses1248843countesses
coynesses1437573coynesses
curtnesses1238373curtnesses
cutenesses12910903cutenesses
daftnesses1436383daftnesses
dampnesses1535603dampnesses
danseuses1044133danseuses
darknesses1537013darknesses
deadnesses1238943deadnesses
deafnesses1436223deafnesses
dearnesses1139583dearnesses
deepnesses1366673deepnesses
deftnesses1436813deftnesses
demonesses1346703demonesses
densenesses1247363densenesses
depresses1259883depresses
dewinesses1438353dewinesses
digresses1137863digresses
dinginesses1337473dinginesses
direnesses11311483direnesses
donnees84210363donne__es
dopinesses13159723dopinesses
downinesses1536143downinesses
dozinesses20168633dozinesses
drabnesses1336483drabnesses
dresses83716173d__resses
druidesses1242583druidesses
dueness82310123duene_s_s
dulness8307983dulne_s_s
dumpinesses16126253dumpinesses
dunnages10154933dunn_ages
dunnest83312263dunne_s_t
dunnites947173dunn_ites
duskinesses16136843duskinesses
dustinesses121110353dustinesses
edginesses1236703edginesses
evennesses1345943evennesses
farnesses122310813farnesses
fatnesses121710463fatnesses
fewnesses1534953fewnesses
feynesses1535223feynesses
finenesses13310713finenesses
finesses111912343_finesses
fitnesses12219373fitnesses
fondnesses1437703fondnesses
foulnesses1337933foulnesses
fullnesses1336213fullnesses
funkinesses18137003funkinesses
funninesses14106873funninesses
gauntnesses1245173gauntnesses
gaynesses1336563gaynesses
gluinesses1138233gluinesses
glumnesses1344733glumnesses
gonenesses11310253gonenesses
guesses8169373gu__esses
gunneries1047043gunneries
harnesses121812073harnesses
hipnesses1436753hipnesses
hotnesses1238903hotnesses
hugenesses1437143hugenesses
humannesses1643863humannesses
huntresses1345283huntresses
icinesses11310073icinesses
idlenesses1138033idlenesses
illnesses937283illnesses
ironnesses1047833ironnesses
justnesses1736493justnesses
keennesses1445323keennesses
kindnesses1537213kindnesses
lanknesses1437503lanknesses
laxnesses1646633laxnesses
leannesses10108343leannesses
lionesses939433lionesses
lonenesses10311343lonenesses
longnesses1138503longnesses
lornnesses1037823lornnesses
loudnesses1138433loudnesses
lownesses1236983lownesses
lushnesses1337343lushnesses
madnesses1239833madnesses
meannesses12128163meannesses
muchnesses1744713muchnesses
mutenesses1289973mutenesses
nesses64718323___nesses
newnesses1236123newnesses
nownesses1236893nownesses
nudenesses1157863nudenesses
numbnesses1474693numbnesses
nunneries947113nunneries
oddnesses1136353oddnesses
oldnesses1037703oldnesses
onenesses9311823onenesses
opennesses1246313opennesses
patnesses111611793patnesses
pinknesses1636583pinknesses
punkinesses17127223punkinesses
purenesses12810743purenesses
ranknesses1438093ranknesses
rawnesses1288123rawnesses
rednesses10312313rednesses
roundnesses1247043roundnesses
rudenesses1188873rudenesses
runninesses11137693runninesses
runtinesses111210963runtinesses
sadnesses10310303sadnesses
sanenesses10412693sanenesses
shynesses1535313shynesses
slynesses1235863slynesses
smugnesses1344563smugnesses
snubnesses1245403snubnesses
snugnesses1165423snugnesses
soundnesses1247523soundnesses
sournesses10310013sournesses
successes1345643successes
suchnesses1536673suchnesses
sundresses1146543sundresses
sunninesses11148383sunninesses
surenesses101212213surenesses
tautnesses10118283tautnesses
thinnesses1346263thinnesses
tininesses10311163tininesses
truenesses1039313truenesses
undresses1039313_undresses
uneases73316263_u_neases
unmeshes1346153_unmeshes
unnerves1157273_unnerves
vainnesses1337343vainnesses
waenesses1239773waenesses
wetnesses12208213wetnesses
witnesses12219923witnesses
woenesses1239133woenesses
wornnesses1337133wornnesses
wrynesses1534843wrynesses
youngnesses1544283youngnesses
zaninesses19310383zaninesses

Search took 7 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411646.75022020.9
3Display Results1641640.0762157.9
 (SQL Overall)1786911646.98225593.1
 
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.