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

202 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
witnesses1221992(None) 
fitnesses12219371fitnesses
wetnesses12208211wetnesses
witnessed13214721witnessed
witnesser12224531witnesser
witnessers13173101witnessers
aptnesses11168992aptnesses
bignesses1267962bignesses
dimnesses1238212dimnesses
fatnesses121710462fatnesses
finesses111912342fi_nesses
hipnesses1436752hipnesses
hotnesses1238902hotnesses
lionesses939432lionesses
litenesses10513022litenesses
patnesses111611792patnesses
swiftnesses1744502swiftnesses
titanesses1037252titanesses
vitesses1136332vit_esses
waenesses1239772waenesses
waitresses1345062waitresses
wannesses1239232wannesses
whatnesses1635732whatnesses
whitenesses1746652whitenesses
widenesses1438772widenesses
wildnesses14157362wildnesses
wilinesses131911092wilinesses
wirinesses131811522wirinesses
wisenesses13310822wisenesses
witness103010012witne_s_s
wittinesses14127482wittinesses
woenesses1239132woenesses
wrynesses1534842wrynesses
acidnesses1337253acidnesses
actresses1137933actresses
airinesses102613613airinesses
aridnesses1139933aridnesses
artinesses10815213artinesses
avidnesses1436463avidnesses
awaynesses1644273awaynesses
badnesses1239253badnesses
biasnesses1236963biasnesses
bittinesses13148263bittinesses
chicnesses1745213chicnesses
coynesses1437573coynesses
curtnesses1238373curtnesses
cutenesses12910903cutenesses
daftnesses1436383daftnesses
deftnesses1436813deftnesses
dewinesses1438353dewi_nesses
digresses1137863digresses
direnesses11311483direnesses
dirtinesses1239883dirtinesses
distresses1148853distresses
ditsinesses12108763ditsinesses
ditzinesses21126213ditzinesses
drynesses1335363drynesses
duenesses1039333duenesses
dulnesses1037763dulnesses
dunnesses1037703dunnesses
earwitnesses1543783earwitnesses
editresses1165073editresses
evilnesses1346003evilnesses
eyewitnesses1852113eyewitnesses
faintnesses1447143faintnesses
fairnesses1357383fairnesses
farnesses122310813farnesses
fastnesses1389083fastnesses
fewnesses1534953fewnesses
feynesses1535223feynesses
finenesses13310713finenesses
finesse10187643fi_nesse_
finessed12136793fi_nessed
firmnesses1535613firmnesses
firstnesses1445733firstnesses
fitness10299393fitne_s_s
flatnesses1337763flatnesses
fulnesses1239053fulnesses
gastnesses11129143gastnesses
gaynesses1336563gaynesses
giantesses1143513giantesses
glibnesses1344753glibnesses
grimnesses13106533grimnesses
harnesses121812073harnesses
highnesses1746083highnesses
icinesses11310073icinesses
idlesses936003_idlesses
illnesses937283illnesses
justnesses1736493justnesses
kindnesses1537213kindnesses
kineses113111253ki_ne_ses
kirmesses15253903kirmesses
latenesses10413363latenesses
laxnesses1646633laxnesses
licitnesses1346413licitnesses
lightnesses1546143lightnesses
likenesses1449533likenesses
liminesses121310853liminesses
limpnesses14116653limpnesses
lithenesses1447313lithenesses
livenesses13411073livenesses
lostnesses1049303lostnesses
lownesses1236983lownesses
madnesses1239833madnesses
matinesses12314543matinesses
meetnesses1237453meetnesses
mildnesses1397393mildnesses
mirinesses121512313mirinesses
mistinesses131310623mistinesses
mistresses1247993mistresses
moistnesses1347153moistnesses
mootnesses1237153mootnesses
mutenesses1289973mutenesses
neatnesses10310013neatnesses
nesses64718323___nesses
newnesses1236123newnesses
nicenesses12310353nicenesses
niftinesses1437243niftinesses
nighnesses1446463nighnesses
nownesses1236893nownesses
oddnesses1136353oddnesses
oilinesses101512443oilinesses
oldnesses1037703oldnesses
onenesses9311823onenesses
pastnesses12910513pastnesses
pertnesses12310313pertnesses
pinknesses1636583pinknesses
pipinesses1448603pipinesses
pithinesses1637503pithinesses
pixinesses1937373pixinesses
primnesses1497803primnesses
quietnesses2045603quietnesses
raptnesses1248523raptnesses
rawnesses1288123rawnesses
rednesses10312313rednesses
richnesses1537803richnesses
rifenesses1339943rifenesses
rightnesses1546233rightnesses
riminesses121211413riminesses
ripenesses12310373ripenesses
ritzinesses2096743ritzinesses
sadnesses10310303sadnesses
saltnesses10310163saltnesses
shynesses1535313shynesses
sicknesses1636763sicknesses
sizinesses1938653sizinesses
slimnesses1236423slimnesses
slynesses1235863slynesses
softnesses1337603softnesses
stresses81112493_stresses
swartnesses1436713swartnesses
sweetnesses1445723sweetnesses
tacitnesses1336323tacitnesses
tartnesses101110713tartnesses
tautnesses10118283tautnesses
thinnesses1346263thinnesses
tidinesses1139223tidinesses
tightnesses1565583tightnesses
tigresses1046403tigresses
tininesses10311163tininesses
tresses73719543__tresses
trignesses1188213trignesses
trimnesses1287753trimnesses
tritenesses11710393tritenesses
tweenesses1345803tweenesses
unfitnesses1446133unfitnesses
vainnesses1337343vainnesses
vastnesses13128203vastnesses
victresses1544973victresses
vilenesses13310223vilenesses
vinasses1135703vi_nasses
vitalnesses1456273vitalnesses
vitesse1044583vit_esse_
voidnesses1436843voidnesses
votresses1236503votresses
waitressed1442923waitressed
warinesses131514523warinesses
warmnesses15167353warmnesses
wavinesses16199283wavinesses
waxinesses20138763waxinesses
weaknesses1735463weaknesses
weirdnesses1545213weirdnesses
wellnesses1335783wellnesses
wetness10277723wetne_s_s
whininesses1746183whininesses
wimpinesses1835633wimpinesses
windinesses1557813windinesses
wineless112711173wi_neless
wineries112316533wi_neries
winesaps1364553wi_nesaps
winesops1374663wi_nesops
wintrinesses1555773wintrinesses
wirelesses1345333wirelesses
wiseasses1244043wiseasses
wispinesses1636273wispinesses
wisses94619603wi___sses
witless103310983witle_s_s
witlessly1543743witlessly
witlessness1446263witlessness
witnessing1442443witnessing
witneys13274723witne__ys
wornnesses1337133wornnesses

Search took 8 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.453394461.4
2DLD Change Limit1486412027.17020731.0
3Display Results2022020.1101836.4
 (SQL Overall)1786912027.73323107.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.