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

102 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
suchnesses153667(None) 
muchnesses1744711muchnesses
archnesses1547172archnesses
butchnesses1843702butchnesses
duchesses1544132duch_esses
lushnesses1337342lushnesses
richnesses1537802richnesses
saucinesses1338982saucinesses
sicknesses1636762sicknesses
successes1345642suc_cesses
suchness1335762suchne_s_s
surenesses101212212surenesses
achinesses1539303_achinesses
bushinesses16107473bushinesses
businesses121411393businesses
busynesses15145513busynesses
chesses124112633__ch_esses
curtnesses1238373curtnesses
cushinesses16127413cushinesses
cutenesses12910903cutenesses
duenesses1039333du_enesses
dullnesses1135993dullnesses
dulnesses1037763du_lnesses
dumbnesses1584603dumbnesses
dunnesses1037703du_nnesses
flushnesses1745383flushnesses
fullnesses1336213fullnesses
fulnesses1239053fu_lnesses
gauchenesses1843323gauchenesses
gushinesses15127033gushinesses
highnesses1746083highnesses
hugenesses1437143hugenesses
icinesses11310073_icinesses
itchinesses1644613itchinesses
juicinesses2035893juicinesses
justnesses1736493justnesses
lacinesses12312123lacinesses
lucidnesses1445243lucidnesses
luckinesses1746653luckinesses
muchness1534073muchne_s_s
mushinesses16127323mushinesses
mutenesses1289973mutenesses
nicenesses12310353nicenesses
nighnesses1446463nighnesses
nudenesses1157863nudenesses
numbnesses1474693numbnesses
packnesses1856633packnesses
plushnesses1645583plushnesses
poshnesses1537463poshnesses
puninesses121110753puninesses
purenesses12810743purenesses
pushinesses1697333pushinesses
quicknesses2643753quicknesses
racinesses12313513racinesses
rashnesses1338723rashnesses
roughnesses15105133roughnesses
rudenesses1188873rudenesses
sadnesses10310303s_adnesses
safenesses1349373safenesses
sagenesses11510823sagenesses
saltnesses10310163saltnesses
samenesses12410853samenesses
sanenesses10412693sanenesses
schusses1334213s_ch_usses
selfnesses1335893selfnesses
sexinesses1739213sexinesses
shynesses1535313s_hynesses
sizinesses1938653sizinesses
skewnesses1743763skewnesses
slacknesses1745243slacknesses
slicknesses1745193slicknesses
slimnesses1236423slimnesses
slouchinesses1842803slouchinesses
slownesses1344943slownesses
slushinesses1445473slushinesses
slynesses1235863s_lynesses
smugnesses1344563smugnesses
snubnesses1245403snubnesses
snugnesses1165423snugnesses
softnesses1337603softnesses
solenesses10412703solenesses
sorenesses101313493sorenesses
soundnesses1247523soundnesses
sournesses10310013sournesses
spacinesses1538103spacinesses
spicinesses1547103spicinesses
sprucenesses1694613sprucenesses
sprynesses1544973sprynesses
squatnesses2045213squatnesses
staunchnesses1851463staunchnesses
suavenesses1448423suavenesses
succusses1344423suc_cusses
sulkinesses1557723sulkinesses
sultanesses1145563sultanesses
sundresses1146543sundresses
sunninesses11148383sunninesses
suppresses1446253suppresses
surlinesses11310053surlinesses
touchinesses1744243touchinesses
toughnesses15104483toughnesses
usualnesses1144693usualnesses
yuckinesses2044763yuckinesses

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 Filter1786911406030.423422437.4
2DLD Change Limit1406031025.81324187.7
3Display Results1021020.0601700.0
 (SQL Overall)1786911026.29628381.7
 
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.