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

233 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
rednesses1031230(None) 
redresses10410291redresses
agednesses1237412agednesses
aridnesses1139932aridnesses
badnesses1239242badnesses
deadnesses1238942deadnesses
eyednesses1445802eyednesses
fewnesses1534952fewnesses
feynesses1535222feynesses
freenesses1339862freenesses
greynesses1446322greynesses
lewdnesses1435392lewdnesses
madnesses1239832madnesses
newnesses1236122newnesses
oddnesses1136352oddnesses
oldnesses1037702oldnesses
rawnesses1288122rawnesses
readinesses12611262readinesses
realnesses10310842realnesses
recesses10312322re_cesses
redness82012442redne_s_s
redressed1137772redressed
redresser1056792redresser
redressers1145102redressers
reedinesses1259552reedinesses
regresses10310462regresses
represses11412142represses
rudenesses1188862rudenesses
sadnesses10310302sadnesses
tirednesses1247732tirednesses
wetnesses12208212wetnesses
acidnesses1337253acidnesses
acridnesses1445783acridnesses
addresses1165633addresses
aptnesses11168993aptnesses
archnesses1547173archnesses
artinesses10815193artinesses
avidnesses1436463avidnesses
baldnesses1337643baldnesses
barenesses12311693bare_nesses
beadinesses1449553beadinesses
bignesses1267953bignesses
boldnesses1337223boldnesses
briefnesses1644943briefnesses
broadnesses1446183broadnesses
coldnesses1338423coldnesses
coynesses1437573coynesses
crudenesses1476653crudenesses
cruelnesses1346243cruelnesses
cursednesses1554963cursednesses
datednesses1357893datednesses
dazednesses2245153dazednesses
deafnesses1436223deafnesses
dearnesses1139573dearnesses
deepnesses1366673deepnesses
deftnesses1436813deftnesses
demonesses1346703demonesses
depresses1259873depresses
dewinesses1438343dewinesses
dimnesses1238213dimnesses
direnesses11311483dire_nesses
drabnesses1336483drabnesses
dresses83716173__dresses
drynesses1335363drynesses
duenesses1039323duenesses
dulnesses1037743dulnesses
dunnesses1037693dunnesses
edginesses1236683_edginesses
eerinesses10612573eerinesses
egresses949443_egresses
eldresses1045673eldresses
erectnesses1347443erectnesses
evennesses1345923evennesses
excesses1736753_excesses
fadednesses16126563fadednesses
farnesses122310813farnesses
fatnesses121710463fatnesses
fellnesses1346083fellnesses
fetidnesses1546643fetidnesses
finesses111912333_finesses
fitnesses12219373fitnesses
fixednesses2244853fixednesses
fondnesses1437703fondnesses
freshnesses1746103freshnesses
fulnesses1239033fulnesses
gaynesses1336563gaynesses
gelidnesses1355983gelidnesses
geneses82613523ge_ne_ses
gladnesses1236683gladnesses
glegnesses1245073glegnesses
goddesses1243453goddesses
goodnesses1236433goodnesses
grandnesses1348113grandnesses
graynesses1436143graynesses
greatnesses1247773greatnesses
greedinesses1446453greedinesses
greennesses1247023greennesses
grimnesses13106533grimnesses
hardnesses141810543hardnesses
harnesses121812073harnesses
headinesses1539843headinesses
heiresses1236963heiresses
hipnesses1436753hipnesses
hornednesses1645503hornednesses
hotnesses1238903hotnesses
icinesses11310053icinesses
idlesses936003_idlesses
illnesses937273illnesses
ironnesses1047823ironnesses
jadednesses20145773jadednesses
keennesses1445323keennesses
kermesses15284963kermesses
kindnesses1537213kindnesses
laxnesses1646633laxnesses
leannesses10108343leannesses
lionesses939423lionesses
loudnesses1138433loudnesses
lownesses1236983lownesses
luridnesses1246713luridnesses
markednesses1944173markednesses
mazednesses2345403mazednesses
meannesses12128163meannesses
meeknesses1644803meeknesses
meetnesses1237443meetnesses
mildnesses1397393mildnesses
morenesses12811383more_nesses
nakednesses1645843nakednesses
nearnesses1039093nearnesses
neatnesses10310003neatnesses
needinesses1258103needinesses
nerdinesses1249043nerdinesses
nesses64718323___nesses
notednesses1247773notednesses
nownesses1236883nownesses
nudenesses1157853nudenesses
onenesses9311823onenesses
opennesses1246313opennesses
patnesses111611793patnesses
peeresses1138453peeresses
pertnesses12310293pertnesses
preblesses1445103preblesses
precesses13310463pre_cesses
primnesses1497803primnesses
proudnesses1447483proudnesses
purenesses12810723pure_nesses
rabidnesses1476123rabidnesses
racinesses12313493racinesses
raggednesses1543853raggednesses
randinesses121311203randinesses
ranknesses1438093ranknesses
rapidnesses1476463rapidnesses
raptnesses1248523raptnesses
rarenesses10313093rarenesses
rashnesses1338713rashnesses
readdresses1394513readdresses
reassesses945053reassesses
recessed1139713re_cessed
recrosses1138373recrosses
redefies12710163red_efies
redenies9615713red_enies
redeyes112910973red_e_yes
redfishes1645793redfishes
redhorses1345653redhorses
redigresses1343943redigresses
rednecked1743163rednecked
rednecks1544013redne_cks
redress82511873redre_s_s
redressor1064223redressor
redressors1153783redressors
refreshes1595953refreshes
regalnesses1246183regalnesses
reglosses1045343reglosses
regressed1138113regressed
reinfuses1245633reinfuses
releases8313343re_leases
reneges82513593re_ne_ges
renested92212953re_nested
renests74014213re_ne_sts
rennases848983re_nnases
repasses101810373re_passes
repousses1146063repousses
repressed12610103repressed
represser1168953represser
repressers1256883repressers
restresses1049313restresses
reverses112513513re_verses
richnesses1537793richnesses
rifenesses1339933rifenesses
rigidnesses1345923rigidnesses
riminesses121211403riminesses
ripenesses12310363ripenesses
rootednesses1345313rootednesses
ropinesses121311013ropinesses
rosinesses101213133rosinesses
roundnesses1247043roundnesses
rowdinesses1536963rowdinesses
ruddinesses1336023ruddinesses
ruggednesses1543313ruggednesses
sacrednesses1544863sacrednesses
seedinesses1259203seedinesses
seeresses939053seeresses
selfnesses1335893selfnesses
sexinesses1739203sexinesses
shrewdnesses1942923shrewdnesses
shynesses1535313shynesses
sidednesses1347103sidednesses
skewnesses1743763skewnesses
slynesses1235863slynesses
sorenesses101313483sore_nesses
surenesses101212203sure_nesses
tendresses1145923tendresses
tepidnesses1445383tepidnesses
tidinesses1139213tidinesses
trendinesses1346323trendinesses
trignesses1188213trignesses
trimnesses1287753trimnesses
truenesses1039313truenesses
tweenesses1345803tweenesses
undresses1039313undresses
vendeuses1343393vendeuses
vexednesses2244583vexednesses
voidnesses1436833voidnesses
waenesses1239773waenesses
wannesses1239233wannesses
weaknesses1735463weaknesses
weedinesses1557073weedinesses
weirdnesses1545203weirdnesses
wellnesses1335783wellnesses
widenesses1438773widenesses
wildnesses14157363wildnesses
witnesses12219923witnesses
woenesses1239133woenesses
wrynesses1534843wrynesses

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486412338.56017364.6
3Display Results2332330.1102118.2
 (SQL Overall)1786912338.82620246.0
 
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.