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

148 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
sournesses1031001(None) 
dournesses1138241dournesses
foulnesses1337932foulnesses
loudnesses1138432loudnesses
poornesses1236802poornesses
smugnesses1344562smugnesses
snubnesses1245402snubnesses
snugnesses1165422snugnesses
sobernesses1346592sobernesses
softnesses1337602softnesses
solenesses10412702solenesses
sorenesses101313492sorenesses
sorrinesses11310092sorrinesses
soundnesses1247522soundnesses
sourness839542sourne_s_s
sourpusses1242452sourpusses
stoutnesses1146972stoutnesses
surenesses101212212s_urenesses
bluenesses1237933bluenesses
bogusnesses1444843bogusnesses
boldnesses1337233boldnesses
boninesses121111453boninesses
boundnesses1446623boundnesses
boxinesses19127903boxinesses
burgesses1245513_burgesses
coldnesses1338423coldnesses
coolnesses1237193coolnesses
cosinesses121012823cosinesses
countesses1248843countesses
courtesies1246453courtesies
coynesses1437573co_ynesses
cozinesses21179503cozinesses
curtnesses1238373_curtnesses
dearnesses1139583dearnesses
donenesses11310563donenesses
dopinesses13159723dopinesses
dourness947683dourne_s_s
dozinesses20168633dozinesses
duenesses1039333_duenesses
dulnesses1037763_dulnesses
dunnesses1037703_dunnesses
duresses939173_dur_esses
fairnesses1357383fairnesses
farnesses122310813_farnesses
fondnesses1437703fondnesses
foxinesses20127733foxinesses
fozinesses22158193fozinesses
fulnesses1239053_fulnesses
gluinesses1138233gluinesses
glumnesses1344733glumnesses
gonenesses11310253gonenesses
goodnesses1236433goodnesses
gorinesses11311553gorinesses
goutinesses1239973goutinesses
governesses1546723governesses
harnesses121812073_harnesses
hoarinesses14310223hoarinesses
hokinesses1758943hokinesses
holinesses13511493holinesses
hominesses15510863hominesses
hotnesses1238903ho_tnesses
jokinesses2147533jokinesses
loginesses11410323loginesses
lonenesses10311343lonenesses
longnesses1138503longnesses
lornnesses1037823lornnesses
lostnesses1049303lostnesses
lousinesses111210323lousinesses
lownesses1236983lo_wnesses
mootnesses1237153mootnesses
mopinesses14139123mopinesses
morenesses12811393morenesses
mousinesses13129833mousinesses
nearnesses1039103nearnesses
nosinesses101411323nosinesses
nownesses1236893no_wnesses
oddnesses1136353_oddnesses
ogresses938473_ogr_esses
oldnesses1037703_oldnesses
onenesses9311823_onenesses
oozinesses19178023oozinesses
piousnesses1348983piousnesses
pokinesses1669613pokinesses
poshnesses1537463poshnesses
proudnesses1447503proudnesses
purenesses12810743_purenesses
ropinesses121311023ropinesses
rosinesses101213143rosinesses
roughnesses15105133roughnesses
roundnesses1247043roundnesses
sadnesses10310303s_adnesses
safenesses1349373safenesses
sagenesses11510823sagenesses
saltnesses10310163saltnesses
samenesses12410853samenesses
sanenesses10412693sanenesses
saucinesses1338983saucinesses
scarinesses1339903scarinesses
scurvinesses1743933scurvinesses
securenesses1445673securenesses
seeresses939053seer_esses
selfnesses1335893selfnesses
sexinesses1739213sexinesses
sharpnesses1645233sharpnesses
sheernesses1445843sheernesses
shortnesses1446793shortnesses
showinesses1735993showinesses
shynesses1535313s_hynesses
sicknesses1636763sicknesses
sizinesses1938653sizinesses
skewnesses1743763skewnesses
slimnesses1236423slimnesses
slownesses1344943slownesses
slynesses1235863s_lynesses
smartnesses1337143smartnesses
smokinesses1736253smokinesses
snowinesses1436413snowinesses
soapinesses1339713soapinesses
sogginesses1346773sogginesses
solidnesses1238103solidnesses
solonetses1043673solonetses
sombernesses1643613sombernesses
sootinesses11410053sootinesses
soppinesses1566843soppinesses
sourceless1273013sourceless
sparenesses1339173sparenesses
sprynesses1544973sprynesses
squarenesses2144973squarenesses
squatnesses2045213squatnesses
starknesses1545883starknesses
sternnesses1146633sternnesses
stoninesses1138253stoninesses
stresses81112493s_tr_esses
sturdinesses1345793sturdinesses
successes1345643s_uccesses
suchnesses1536673suchnesses
surceases1157473s_urceases
surlinesses11310053s_urlinesses
surpasses1145533s_urpasses
swartnesses1436713swartnesses
tautnesses10118283tautnesses
toughnesses15104483toughnesses
truenesses1039313truenesses
voidnesses1436843voidnesses
votresses1236503votr_esses
woenesses1239133wo_enesses
wornnesses1337133wornnesses
youngnesses1544283youngnesses

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 Filter1786911406030.453394461.4
2DLD Change Limit1406031488.61016330.2
3Display Results1481480.0761947.4
 (SQL Overall)1786911489.13919552.6
 
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.