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

112 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
shynesses153531(None) 
slynesses1235861slynesses
ashinesses1339162ashinesses
coynesses1437572coynesses
drynesses1335362drynesses
feynesses1535222feynesses
gaynesses1336562gaynesses
sadnesses10310302sadnesses
shyness1344992shyne_s_s
sprynesses1544972sprynesses
synesises1245612s_ynesises
wrynesses1534842wrynesses
achinesses1539303achinesses
aptnesses11168993aptnesses
awaynesses1644273awaynesses
badnesses1239253badnesses
bignesses1267963bignesses
bushinesses16107473bushinesses
busynesses15145513busynesses
chesses124112633ch__esses
chicnesses1745213chicnesses
cushinesses16127413cushinesses
dimnesses1238213dimnesses
duenesses1039333duenesses
dulnesses1037763dulnesses
dunnesses1037703dunnesses
farnesses122310813farnesses
fatnesses121710463fatnesses
fewnesses1534953fewnesses
finesses111912343_finesses
fishinesses17107253fishinesses
fitnesses12219373fitnesses
fulnesses1239053fulnesses
graynesses1436143graynesses
greynesses1446323greynesses
gushinesses15127033gushinesses
harnesses121812073harnesses
hipnesses1436753hipnesses
hotnesses1238903hotnesses
icinesses11310073icinesses
illnesses937283illnesses
laxnesses1646633laxnesses
lionesses939433lionesses
lownesses1236983lownesses
lushnesses1337343lush_nesses
madnesses1239833madnesses
mushinesses16127323mushinesses
nesses64718323___nesses
newnesses1236123newnesses
nownesses1236893nownesses
oddnesses1136353oddnesses
oldnesses1037703oldnesses
onenesses9311823onenesses
oyesses1037333_oy_esses
patnesses111611793patnesses
phyleses1645183phyle_ses
phylesises1843633phylesises
poshnesses1537463posh_nesses
pushinesses1697333pushinesses
rashnesses1338723rash_nesses
rawnesses1288123rawnesses
rednesses10312313rednesses
safenesses1349373safenesses
sagenesses11510823sagenesses
saltnesses10310163saltnesses
samenesses12410853samenesses
sanenesses10412693sanenesses
seeresses939053seeresses
selfnesses1335893selfnesses
sexinesses1739213sexinesses
shadinesses1538643shadinesses
shakinesses1837613shakinesses
sharpnesses1645233sharpnesses
sheernesses1445843sheernesses
shininesses1448303shininesses
shortnesses1446793shortnesses
showinesses1735993showinesses
sicknesses1636763sicknesses
sissynesses12123423sissynesses
sizinesses1938653sizinesses
skewnesses1743763skewnesses
slimnesses1236423slimnesses
slownesses1344943slownesses
slyness1035263slyne_s_s
smugnesses1344563smugnesses
snubnesses1245403snubnesses
snugnesses1165423snugnesses
softnesses1337603softnesses
solenesses10412703solenesses
sorenesses101313493sorenesses
sournesses10310013sournesses
stresses81112493s_tresses
successes1345643successes
suchnesses1536673suchnesses
surenesses101212213surenesses
synapses1344713s_ynapses
syndeses1245263s_yndeses
syndesises1443563s_yndesises
synereses1245313s_ynereses
synesis1039163s_yne_sis
syngases1245073s_yngases
syngasses1343813s_yngasses
synopses1346223s_ynopses
thinnesses1346273thinnesses
waenesses1239773waenesses
wannesses1239233wannesses
washinesses1737263washinesses
wetnesses12208213wetnesses
whatnesses1635733whatnesses
witnesses12219923witnesses
woenesses1239133woenesses
yesses93615813__y_esses

Search took 10 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.423422437.4
2DLD Change Limit1486411128.93616634.0
3Display Results1121120.0462434.8
 (SQL Overall)1786911129.40518999.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.