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 “fitnesses” 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
fitnesses1221937(None) 
fatnesses121710461fatnesses
finesses111912341fi_nesses
witnesses12219921witnesses
aptnesses11168992aptnesses
bignesses1267962bignesses
dimnesses1238212dimnesses
faintnesses1447142faintnesses
fairnesses1357382fairnesses
farnesses122310812farnesses
fastnesses1389082fastnesses
fewnesses1534952fewnesses
feynesses1535222feynesses
finenesses13310712finenesses
finesse10187642fi_nesse_
finessed12136792fi_nessed
firmnesses1535612firmnesses
firstnesses1445732firstnesses
fitness10299392fitne_s_s
flatnesses1337762flatnesses
fulnesses1239052fulnesses
hipnesses1436752hipnesses
hotnesses1238902hotnesses
lionesses939432lionesses
litenesses10513022litenesses
patnesses111611792patnesses
titanesses1037252titanesses
unfitnesses1446132unfitnesses
vitesses1136332vit_esses
wetnesses12208212wetnesses
witnessed13214722witnessed
witnesser12224532witnesser
witnessers13173102witnessers
acidnesses1337253acidnesses
actresses1137933actresses
airinesses102613613airinesses
aridnesses1139933aridnesses
artinesses10815213artinesses
avidnesses1436463avidnesses
badnesses1239253badnesses
biasnesses1236963biasnesses
bittinesses13148263bittinesses
chicnesses1745213chicnesses
coynesses1437573coynesses
curtnesses1238373curtnesses
cutenesses12910903cutenesses
daftnesses1436383daftnesses
deftnesses1436813deftnesses
digresses1137863digresses
direnesses11311483direnesses
dirtinesses1239883dirtinesses
distresses1148853distresses
ditsinesses12108763ditsinesses
ditzinesses21126213ditzinesses
drynesses1335363drynesses
duenesses1039333duenesses
dulnesses1037763dulnesses
dunnesses1037703dunnesses
editresses1165073editresses
evilnesses1346003evilnesses
fatalnesses1456283fatalnesses
fatness103311293fatne_s_s
fattinesses14118973fattinesses
feistinesses1555893feistinesses
fellnesses1346083fellnesses
fesses94820253f___esses
fetidnesses1546653fetidnesses
fierinesses1439233fierinesses
filminesses1636233filminesses
filthinesses1844463filthinesses
fineness11310643fi_neness
fineries112416743fi_neries
finises10312903fi_n_ises
finishes1438983fi_nishes
finitenesses1557723finitenesses
fishinesses17107243fishinesses
fitfulnesses1866023fitfulnesses
fixednesses2244853fixednesses
fleetnesses1445483fleetnesses
flintinesses1546323flintinesses
fluidnesses1545483fluidnesses
fondnesses1437703fondnesses
fortresses1345663fortresses
foulnesses1337933foulnesses
foxinesses20127733foxinesses
fozinesses22158193fozinesses
frailnesses1447593frailnesses
freenesses1339873freenesses
fruitinesses1546443fruitinesses
fullnesses1336213fullnesses
fustinesses14129783fustinesses
gastnesses11129143gastnesses
gaynesses1336563gaynesses
giantesses1143513giantesses
glibnesses1344753glibnesses
grimnesses13106533grimnesses
harnesses121812073harnesses
heftinesses1737133heftinesses
highnesses1746083highnesses
icinesses11310073icinesses
idlesses936003_idlesses
iffinesses1635583iffinesses
illnesses937283illnesses
justnesses1736493justnesses
kindnesses1537213kindnesses
kineses113111253ki_ne_ses
kirmesses15253903kirmesses
latenesses10413363latenesses
laxnesses1646633laxnesses
licitnesses1346413licitnesses
lightnesses1546143lightnesses
likenesses1449533likenesses
liminesses121310853liminesses
limpnesses14116653limpnesses
lithenesses1447313lithenesses
livenesses13411073livenesses
loftinesses1437923loftinesses
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
swiftnesses1744503swiftnesses
tacitnesses1336323tacitnesses
tartnesses101110713tartnesses
tautnesses10118283tautnesses
thinnesses1346263thinnesses
tidinesses1139223tidinesses
tightnesses1565583tightnesses
tigresses1046403tigresses
tininesses10311163tininesses
tresses73719543__tresses
trignesses1188213trignesses
trimnesses1287753trimnesses
tritenesses11710393tritenesses
vainnesses1337343vainnesses
vastnesses13128203vastnesses
victresses1544973victresses
vilenesses13310223vilenesses
vinasses1135703vi_nasses
vitalnesses1456273vitalnesses
vitesse1044583vit_esse_
voidnesses1436843voidnesses
votresses1236503votresses
waenesses1239773waenesses
waitresses1345063waitresses
wannesses1239233wannesses
whatnesses1635733whatnesses
whitenesses1746653whitenesses
widenesses1438773widenesses
wildnesses14157363wildnesses
wilinesses131911093wilinesses
wirinesses131811523wirinesses
wisenesses13310823wisenesses
witness103010013witne_s_s
wittinesses14127483wittinesses
woenesses1239133woenesses
wrynesses1534843wrynesses

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.420425454.8
2DLD Change Limit1486412027.20620627.4
3Display Results2022020.1061905.7
 (SQL Overall)1786912027.73223110.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.