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

124 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
slimnesses123642(None) 
sliminesses1338091sliminesses
dimnesses1238212_dimnesses
glibnesses1344752glibnesses
glumnesses1344732glumnesses
grimnesses13106532grimnesses
liminesses121310852_liminesses
limpnesses14116652_limpnesses
lionesses939432_lionesses
primnesses1497802primnesses
slicknesses1745192slicknesses
slimness1036522slimne_s_s
slownesses1344942slownesses
slynesses1235862sl_ynesses
solidnesses1238102solidnesses
trimnesses1287752trimnesses
acidnesses1337253acidnesses
algidnesses1345163algidnesses
aliennesses1145863aliennesses
alikenesses1547203alikenesses
alivenesses1448873alivenesses
aridnesses1139933aridnesses
ashinesses1339163ashi_nesses
avidnesses1436463avidnesses
balminesses1537253balminesses
bignesses1267963_bignesses
blindnesses1446183blindnesses
bluenesses1237933bluenesses
calmnesses1436843calmnesses
chicnesses1745213chicnesses
evilnesses1346003evilnesses
fairnesses1357383fairnesses
filminesses1636233filminesses
finesses111912343_fi_nesses
firmnesses1535613firmnesses
fitnesses12219373_fitnesses
flatnesses1337763flatnesses
flimsinesses1743993flimsinesses
fluidnesses1545483fluidnesses
gaminesses13410463gaminesses
gelidnesses1355983gelidnesses
gladnesses1236683gladnesses
glegnesses1245073glegnesses
gluinesses1138233gluinesses
griminesses14167553griminesses
hipnesses1436753_hipnesses
holinesses13511493holi_nesses
hominesses15510863hominesses
icinesses11310073ici_nesses
illnesses937283il_lnesses
lamenesses12610563_lamenesses
laxnesses1646633_laxnesses
likenesses1449533_likenesses
litenesses10513023_litenesses
livenesses13411073_livenesses
lownesses1236983_lownesses
mildnesses1397393mildnesses
oilinesses101512443oilinesses
oldnesses1037703ol_dnesses
plainnesses1356203plainnesses
plumbnesses1753073plumbnesses
plumpnesses1753263plumpnesses
primenesses1548993primenesses
riminesses121211413_riminesses
sadnesses10310303s_adnesses
safenesses1349373safenesses
sagenesses11510823sagenesses
saltinesses11311453saltinesses
saltnesses10310163saltnesses
samenesses12410853samenesses
sanenesses10412693sanenesses
scalinesses1339323scali_nesses
seaminesses13310753seaminesses
selfnesses1335893selfnesses
sexinesses1739213sexinesses
shininesses1448293shininesses
shynesses1535313s_hynesses
sicknesses1636763sicknesses
silkinesses1557903silkinesses
sillinesses1169843sillinesses
sizinesses1938653sizinesses
skewnesses1743763skewnesses
skimpinesses2043183skimpinesses
slacknesses1745243slacknesses
slatinesses11311633slatinesses
sleeknesses1545273sleeknesses
slightnesses1654623slightnesses
sliminess1137423slimine_s_s
slinkinesses1645813slinkinesses
slipdresses1442573slipdresses
smugnesses1344563smugnesses
snidenesses1248653snidenesses
snubnesses1245403snubnesses
snugnesses1165423snugnesses
softnesses1337603softnesses
solemnnesses1443633solemnnesses
solenesses10412703solenesses
sorenesses101313493sorenesses
sournesses10310013sournesses
spicinesses1547103spicinesses
spikinesses1746523spikinesses
spininesses1358453spininesses
sprynesses1544973sprynesses
staidnesses1237193staidnesses
stiffnesses1743593stiffnesses
stillnesses1146733stillnesses
sublimenesses1763383sublimenesses
suchnesses1536673suchnesses
sulkinesses1557723sulkinesses
sultanesses1145563sultanesses
surenesses101212213surenesses
surlinesses11310053surli_nesses
swiftnesses1744503swiftnesses
thinnesses1346263thinnesses
trignesses1188213trignesses
uglinesses1138543ugli_nesses
vainnesses1337343vainnesses
validnesses1576023validnesses
vilenesses13310223vilenesses
voidnesses1436843voidnesses
warmnesses15167353warmnesses
wildnesses14157363wildnesses
wilinesses131911093wilinesses
witnesses12219923_witnesses

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031246.56321423.6
3Display Results1241240.0602066.7
 (SQL Overall)1786911247.02925422.0
 
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.