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

108 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
nudenesses115785(None) 
rudenesses1188861rudenesses
crudenesses1476652crudenesses
cutenesses12910872cutenesses
duenesses1039322du_enesses
hugenesses1437132hugenesses
mutenesses1289932mutenesses
nicenesses12310332nicenesses
nudeness936732nudene_s_s
numbnesses1474682numbnesses
purenesses12810722purenesses
snidenesses1248652snidenesses
surenesses101212202surenesses
widenesses1438772widenesses
acutenesses13126953acutenesses
agednesses1237413agednesses
badnesses1239243bad_nesses
barenesses12311693barenesses
basenesses12310553basenesses
bluenesses1237923bluenesses
businesses121411353businesses
busynesses15145493busynesses
curtnesses1238363curtnesses
direnesses11311483direnesses
donenesses11310563donenesses
dullnesses1135973dullnesses
dulnesses1037743du_lnesses
dumbnesses1584593dumbnesses
dunnesses1037693du_nnesses
eyednesses1445803eyednesses
fadednesses16126563fadednesses
finenesses13310713finenesses
freenesses1339863freenesses
fullnesses1336193fullnesses
fulnesses1239033fu_lnesses
gamenesses1368983gamenesses
gaudinesses1337843gaudinesses
gonenesses11310253gonenesses
halenesses13312033halenesses
idlenesses1138023idlenesses
inanenesses1149513inanenesses
jadednesses20145773jadednesses
justnesses1736473justnesses
lamenesses12610563lamenesses
latenesses10413353latenesses
likenesses1449533likenesses
litenesses10513003litenesses
livenesses13411053livenesses
lonenesses10311343lonenesses
loudnesses1138433loud_nesses
lushnesses1337333lushnesses
madnesses1239833mad_nesses
malenesses12312203malenesses
minutenesses1476163minutenesses
morenesses12811383morenesses
muchnesses1744693muchnesses
muddinesses1535263muddinesses
murderesses1443103murderesses
naivenesses1449083naivenesses
nakednesses1645843nakednesses
nearnesses1039093nearnesses
neatnesses10310003neatnesses
needinesses1258103needinesses
nerdinesses1249043nerdinesses
newnesses1236123n_ewnesses
nighnesses1446463nighnesses
noblenesses1348053noblenesses
nosinesses101411303nosinesses
notednesses1247773notednesses
nownesses1236883n_ownesses
nubbinesses1544283nubbinesses
nuttinesses11117733nuttinesses
oddnesses1136353_oddnesses
oldnesses1037703old_nesses
onenesses9311823_onenesses
palenesses12312653palenesses
pudginesses1545043pudginesses
puninesses121110743puninesses
queernesses2044563queernesses
quietnesses2045563quietnesses
rarenesses10313093rarenesses
rednesses10312303red_nesses
rifenesses1339933rifenesses
ripenesses12310363ripenesses
ruddinesses1336023ruddinesses
rudeness938083rudene_s_s
sadnesses10310303sad_nesses
safenesses1349373safenesses
sagenesses11510823sagenesses
samenesses12410853samenesses
sanenesses10412693sanenesses
sidednesses1347103sidednesses
snubnesses1245403snu_bnesses
snugnesses1165423snu_gnesses
solenesses10412703solenesses
sorenesses101313483sorenesses
suavenesses1448393suavenesses
suchnesses1536653suchnesses
suddennesses1442863suddennesses
tamenesses1259963tamenesses
tidinesses1139213tidinesses
truenesses1039313truenesses
tweenesses1345803tweenesses
undresses1039313und_resses
vilenesses13310213vilenesses
waenesses1239773_waenesses
wisenesses13310803wisenesses
woenesses1239133_woenesses

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 Filter1786911406030.1601116818.8
2DLD Change Limit1406031088.43616667.0
3Display Results1081080.0631714.3
 (SQL Overall)1786911088.65920636.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.