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

132 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
dournesses113824(None) 
sournesses10310011sournesses
dearnesses1139582dearnesses
donenesses11310562donenesses
dopinesses13159722dopinesses
dourness947682dourne_s_s
dozinesses20168632dozinesses
duenesses1039332d_uenesses
dulnesses1037762d_ulnesses
dunnesses1037702d_unnesses
duresses939172d_ur_esses
foulnesses1337932foulnesses
loudnesses1138432loudnesses
poornesses1236802poornesses
bluenesses1237933bluenesses
bogusnesses1444843bogusnesses
boldnesses1337233boldnesses
boninesses121111453boninesses
boundnesses1446623boundnesses
boxinesses19127903boxinesses
burgesses1245513_burgesses
coldnesses1338423coldnesses
coolnesses1237193coolnesses
cosinesses121012823cosinesses
countesses1248843countesses
courtesies1246453courtesies
coynesses1437573co_ynesses
cozinesses21179503cozinesses
curtnesses1238373_curtnesses
daftnesses1436383daftnesses
dampnesses1535603dampnesses
danknesses1536253danknesses
darknesses1537013darknesses
deadnesses1238943deadnesses
deafnesses1436223deafnesses
deepnesses1366673deepnesses
deftnesses1436813deftnesses
demonesses1346703demonesses
demurenesses1544753demurenesses
depresses1259883depr_esses
devoutnesses1683933devoutnesses
dewinesses1438353dewinesses
digresses1137863digr_esses
dimnesses1238213d_imnesses
direnesses11311483direnesses
diureses936453diur_e_ses
dodginesses1435433dodginesses
dopeynesses1744023dopeynesses
dorkinesses1647663dorkinesses
dottinesses1238133dottinesses
doublenesses1546513doublenesses
dowdinesses1635723dowdinesses
downinesses1536143downinesses
drabnesses1336483drabnesses
dresses83716173d__r_esses
drollnesses1244363drollnesses
druidesses1242583druidesses
drynesses1335363d_rynesses
duchesses1544133d_uchesses
dullnesses1135993dullnesses
dumbnesses1584603dumbnesses
dwarfnesses1843293dwarfnesses
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
odiousnesses1347993odiousnesses
ogresses938473_ogr_esses
oldnesses1037703_oldnesses
onenesses9311823_onenesses
oozinesses19178023oozinesses
piousnesses1348983piousnesses
pokinesses1669613pokinesses
poshnesses1537463poshnesses
proudnesses1447503proudnesses
purenesses12810743_purenesses
ropinesses121311023ropinesses
rosinesses101213143rosinesses
roughnesses15105133roughnesses
roundnesses1247043roundnesses
smugnesses1344563smugnesses
snubnesses1245403snubnesses
snugnesses1165423snugnesses
sobernesses1346593sobernesses
softnesses1337603softnesses
solenesses10412703solenesses
sorenesses101313493sorenesses
sorrinesses11310093sorrinesses
soundnesses1247523soundnesses
sourness839543sourne_s_s
sourpusses1242453sourpusses
stoutnesses1146973stoutnesses
surenesses101212213_surenesses
tautnesses10118283tautnesses
toughnesses15104483toughnesses
truenesses1039313truenesses
voidnesses1436843voidnesses
votresses1236503votr_esses
woenesses1239133wo_enesses
wornnesses1337133wornnesses
youngnesses1544283youngnesses

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.453394461.4
2DLD Change Limit1406031325.83024117.2
3Display Results1321320.0761736.8
 (SQL Overall)1786911326.35928100.5
 
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.