Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “smallnesses” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

72 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
smallnesses	13	4	496	(None)
malenesses	12	3	1222	2	_malenesses
saltnesses	10	3	1016	2	s_altnesses
scalinesses	13	3	932	2	scalinesses
smallness	11	7	451	2	smallne_s_s
smartnesses	13	3	714	2	smartnesses
stalenesses	11	3	1110	2	stalenesses
stillnesses	11	4	673	2	stillnesses
tallnesses	10	3	747	2	_tallnesses
amplenesses	15	8	570	3	amplenesses
baldnesses	13	3	765	3	_baldnesses
calmnesses	14	3	684	3	_calmnesses
chillnesses	16	4	472	3	chillnesses
dismalnesses	15	5	398	3	disma_lnesses
drollnesses	12	4	436	3	drollnesses
dullnesses	11	3	599	3	_dullnesses
fellnesses	13	4	608	3	_fellnesses
femalenesses	17	4	686	3	femalenesses
frailnesses	14	4	759	3	frailnesses
fullnesses	13	3	621	3	_fullnesses
halenesses	13	3	1204	3	_halenesses
halfnesses	16	3	626	3	_halfnesses
illnesses	9	3	728	3	__illnesses
madnesses	12	3	983	3	_ma_dnesses
maltinesses	13	3	1023	3	_maltinesses
manlinesses	13	9	1019	3	_manlinesses
matinesses	12	3	1454	3	_matinesses
mazinesses	21	3	992	3	_mazinesses
mealinesses	13	3	1097	3	mealinesses
mildnesses	13	9	739	3	_mildnesses
ovalnesses	13	4	605	3	ova_lnesses
palenesses	12	3	1266	3	_palenesses
realnesses	10	3	1085	3	rea_lnesses
sadnesses	10	3	1030	3	s_a_dnesses
safenesses	13	4	937	3	s_afenesses
sagenesses	11	5	1082	3	s_agenesses
sallownesses	15	4	274	3	s_allownesses
saltinesses	11	3	1145	3	s_altinesses
samenesses	12	4	1085	3	s_amenesses
sanenesses	10	4	1269	3	s_anenesses
scantnesses	13	7	653	3	scantnesses
scarinesses	13	3	990	3	scarinesses
seaminesses	13	3	1075	3	seaminesses
selfnesses	13	3	589	3	s_elfnesses
shadinesses	15	3	864	3	shadinesses
shakinesses	18	3	761	3	shakinesses
shallownesses	19	5	155	3	shallownesses
sharpnesses	16	4	523	3	sharpnesses
shrillnesses	15	4	350	3	shrillnesses
sillinesses	11	6	984	3	sillinesses
simplenesses	16	4	562	3	simplenesses
slacknesses	17	4	524	3	slacknesses
slatinesses	11	3	1163	3	slatinesses
slynesses	12	3	586	3	s__lynesses
smarminesses	16	4	510	3	smarminesses
smokinesses	17	3	625	3	smokinesses
smugnesses	13	4	456	3	sm_ugnesses
snakinesses	15	3	855	3	snakinesses
soapinesses	13	3	971	3	soapinesses
solenesses	10	4	1270	3	s_olenesses
spacinesses	15	3	810	3	spacinesses
sparenesses	13	3	917	3	sparenesses
stablenesses	14	4	810	3	stablenesses
staginesses	12	3	846	3	staginesses
staidnesses	12	3	719	3	staidnesses
stainlesses	11	4	416	3	stainlesses
starknesses	15	4	588	3	starknesses
suavenesses	14	4	842	3	suavenesses
surlinesses	11	3	1005	3	surlinesses
swartnesses	14	3	671	3	swartnesses
usualnesses	11	4	469	3	usua_lnesses
wellnesses	13	3	578	3	_wellnesses

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	121633	0.390	458182.1
2	DLD Change Limit	121633	72	5.140	23664.0
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	5.576	32046.4