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

Here are the results of your fuzzy-string dictionary search for “chastening” 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.

78 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
chastening	16	5	652	(None)
hastening	13	25	948	1	_hastening
chaptering	18	10	796	2	chaptering
chartering	16	10	925	2	chartering
chasseing	15	5	496	2	chasse_ing
chastising	16	5	488	2	chastising
chattering	16	10	864	2	chattering
christening	17	4	340	2	christening
fastening	13	26	860	2	_fastening
battening	12	26	885	3	_battening
cantering	12	24	1737	3	c_antering
cantoning	12	3	1088	3	c_antoning
careening	12	3	1001	3	c_areening
cartoning	12	3	1111	3	c_artoning
casketing	16	3	538	3	c_asketing
casting	10	46	2834	3	c_ast__ing
castling	11	3	1123	3	c_ast_ling
catering	11	20	1990	3	c_a_tering
chaffering	22	10	464	3	chaffering
chagrining	17	4	344	3	chagrining
chaining	14	28	1078	3	cha__ining
challenging	18	5	256	3	challenging
chambering	20	11	604	3	chambering
chamfering	21	12	533	3	chamfering
changeling	17	4	567	3	changeling
channeling	16	4	520	3	channeling
chanting	14	34	1353	3	chant__ing
charting	14	26	1419	3	chart__ing
chasing	13	37	1589	3	chas___ing
chasten	12	43	1240	3	chaste__n_
chastened	15	4	588	3	chasten_ed
chastener	14	4	570	3	chasten_er
chasteners	15	5	479	3	chasteners
chasteness	15	4	652	3	chasteness
chastens	13	42	918	3	chaste__ns
chatting	14	28	1014	3	cha_t_ting
cheapening	18	8	380	3	cheapening
chickening	22	4	413	3	chickening
chiseling	15	3	640	3	chis_eling
chittering	16	10	718	3	chittering
christenings	18	5	128	3	christenings
chuntering	16	4	780	3	chuntering
clattering	13	10	923	3	clattering
clustering	13	11	681	3	clustering
coarsening	13	4	554	3	coarsening
coasting	11	36	1551	3	coast__ing
coattending	15	4	354	3	coattending
cratering	12	3	1265	3	cra_tering
cravening	15	4	755	3	cra_vening
crispening	15	4	387	3	crispening
fastenings	14	27	390	3	_fastenings
fattening	13	28	783	3	_fattening
flattening	14	11	510	3	flattening
glistening	12	9	428	3	glistening
haltering	13	22	1200	3	_haltering
happening	17	3	559	3	_happening
hardening	14	3	802	3	_hardening
harkening	17	4	692	3	_harkening
harshening	17	4	417	3	_harshening
hasting	11	47	2519	3	_hast__ing
havening	15	25	855	3	_ha_vening
heartening	14	4	673	3	heartening
hosteling	13	3	789	3	_hosteling
latening	9	7	1149	3	_la_tening
listening	10	12	895	3	_listening
mastering	12	23	1530	3	_mastering
moistening	13	4	623	3	moistening
neatening	10	3	835	3	nea_tening
plastering	13	3	924	3	plastering
rattening	10	28	876	3	_rattening
refastening	15	4	430	3	refastening
sharpening	16	4	488	3	sharpening
shattering	14	9	828	3	shattering
shortening	14	4	530	3	shortening
smartening	13	4	499	3	smartening
tautening	10	3	584	3	_tautening
unfastening	15	7	278	3	unfastening
whitening	16	3	510	3	wh_itening

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	140603	0.156	1145455.1
2	DLD Change Limit	140603	78	5.686	24727.9
3	Display Results	78	78	0.033	2363.6
	(SQL Overall)	178691	78	5.875	30415.5