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

143 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
illnesses93728(None) 
chillnesses1644722chillnesses
dullnesses1135992dullnesses
dulnesses1037762dulnesses
fellnesses1346082fellnesses
fullnesses1336212fullnesses
fulnesses1239052fulnesses
hillinesses1458502hillinesses
icinesses11310072icinesses
idlenesses1138032idlenesses
idlesses936002idl_esses
illness736472illne_s_s
lionesses939432lionesses
mildnesses1397392mildnesses
oilinesses101512442oilinesses
oldnesses1037702oldnesses
sillinesses1169842sillinesses
slynesses1235862slynesses
stillnesses1146732stillnesses
tallnesses1037472tallnesses
vilenesses13310222vilenesses
wellnesses1335782wellnesses
wildnesses14157362wildnesses
wilinesses131911092wilinesses
agilenesses1247773agilenesses
airinesses102613613airinesses
aptnesses11168993aptnesses
badnesses1239253badnesses
baldnesses1337653baldnesses
biasnesses1236963biasnesses
bignesses1267963bignesses
blesses93812393_bl_esses
bluenesses1237933bluenesses
boldnesses1337233boldnesses
calmnesses1436843calmnesses
chillinesses1744983chillinesses
civilnesses1644853civilnesses
coldnesses1338423coldnesses
coolnesses1237193coolnesses
coynesses1437573coynesses
dailinesses1249493dailinesses
dailynesses1543943dailynesses
dimnesses1238213dimnesses
direnesses11311483direnesses
drollnesses1244363drollnesses
drynesses1335363drynesses
duenesses1039333duenesses
dunnesses1037703dunnesses
eldresses1045673eldresses
evilnesses1346003evilnesses
farnesses122310813farnesses
fatnesses121710463fatnesses
fewnesses1534953fewnesses
feynesses1535223feynesses
filminesses1636233filminesses
finenesses13310713finenesses
finesses111912343_finesses
firmnesses1535613firmnesses
fitnesses12219373fitnesses
flatnesses1337763flatnesses
foulnesses1337933foulnesses
gaynesses1336563gaynesses
gladnesses1236683gladnesses
glegnesses1245073glegnesses
glibnesses1344753glibnesses
gluinesses1138233gluinesses
glumnesses1344733glumnesses
halenesses13312043halenesses
halfnesses1636263halfnesses
harnesses121812073harnesses
highnesses1746083highnesses
hipnesses1436753hipnesses
holinesses13511493holinesses
hotnesses1238903hotnesses
ickinesses1637183ickinesses
idlesse834193idl_esse_
iffinesses1635583iffinesses
ileuses738673i_l_euses
impresses1338213impresses
ingresses1038533ingresses
inkinesses1439423inkinesses
ironnesses1047833ironnesses
jollinesses1836723jollinesses
kindnesses1537213kindnesses
laxnesses1646633laxnesses
likenesses1449533likenesses
liminesses121310853liminesses
limpnesses14116653limpnesses
litenesses10513023litenesses
livenesses13411073livenesses
loesses7310033__loesses
lownesses1236983lownesses
madnesses1239833madnesses
malenesses12312223malenesses
milkinesses1786793milkinesses
mirinesses121512313mirinesses
nesses64718323___nesses
newnesses1236123newnesses
nicenesses12310353nicenesses
nighnesses1446463nighnesses
nownesses1236893nownesses
oddnesses1136353oddnesses
onenesses9311823onenesses
ovalnesses1346053ovalnesses
palenesses12312663palenesses
patnesses111611793patnesses
pinknesses1636583pinknesses
pipinesses1448603pipinesses
pixinesses1937373pixinesses
rawnesses1288123rawnesses
realnesses10310853realnesses
rednesses10312313rednesses
richnesses1537803richnesses
rifenesses1339943rifenesses
riminesses121211413riminesses
ripenesses12310373ripenesses
sadnesses10310303sadnesses
saltnesses10310163saltnesses
selfnesses1335893selfnesses
shrillnesses1543503shrillnesses
shynesses1535313shynesses
sicknesses1636763sicknesses
silkinesses1557903silkinesses
sizinesses1938653sizinesses
slimnesses1236423slimnesses
slownesses1344943slownesses
smallnesses1344963smallnesses
solenesses10412703solenesses
tidinesses1139223tidinesses
tininesses10311163tininesses
titanesses1037253titanesses
uglinesses1138543uglinesses
villainesses1543513villainesses
vitalnesses1456273vitalnesses
waenesses1239773waenesses
wannesses1239233wannesses
wetnesses12208213wetnesses
widenesses1438773widenesses
wirinesses131811523wirinesses
wisenesses13310823wisenesses
witnesses12219923witnesses
woenesses1239133woenesses
wrynesses1534843wrynesses

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411436.18624028.6
3Display Results1431430.0632269.8
 (SQL Overall)1786911436.70226662.3
 
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.