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

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

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.

83 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
unfastening	15	7	278	(None)
fastening	13	26	860	2	__fastening
refastening	15	4	430	2	refastening
unfaltering	15	4	326	2	unfaltering
chastening	16	5	652	3	_chastening
fastenings	14	27	390	3	__fastenings
fattening	13	28	783	3	__fattening
hastening	13	25	948	3	__hastening
neatening	10	3	835	3	_nea_tening
nonfattening	16	6	186	3	nonfattening
unfasten	11	4	484	3	unfaste__n_
unfastened	14	4	324	3	unfasten_ed
unfastens	12	4	298	3	unfaste__ns
unfettering	15	4	370	3	unfettering
unflattering	16	7	204	3	unflattering
battening	12	26	885	4	__battening
christening	17	4	340	4	christening
damascening	17	5	148	4	damascening
enfettering	15	4	323	4	enfettering
faltering	13	22	1111	4	__faltering
fasting	11	45	2283	4	__fast__ing
festering	13	24	1317	4	__festering
flattening	14	11	510	4	_flattening
fostering	13	24	1126	4	__fostering
glistening	12	9	428	4	_glistening
greatening	12	4	544	4	grea_tening
heartening	14	4	673	4	_heartening
infesting	13	10	951	4	infest__ing
latening	9	7	1149	4	__la_tening
listening	10	12	895	4	__listening
mastering	12	23	1530	4	__mastering
moistening	13	4	623	4	_moistening
nattering	10	22	1221	4	_n_attering
outfasting	14	4	633	4	outfast__ing
outmastering	15	5	295	4	outmastering
plastering	13	3	924	4	_plastering
rattening	10	28	876	4	__rattening
remastering	14	4	684	4	remastering
smartening	13	4	499	4	_smartening
softening	13	6	549	4	sof__tening
straitening	12	4	366	4	straitening
tautening	10	3	584	4	__tautening
unageing	10	3	627	4	un_a_ge_ing
unassuming	13	4	192	4	un_assuming
unbanning	12	3	589	4	unba__nning
unbeseeming	16	5	189	4	unbeseeming
unburdening	15	5	201	4	unburdening
unbuttoning	14	8	164	4	unbuttoning
uncasing	11	5	1100	4	uncas___ing
undesigning	14	5	344	4	undesigning
unearthing	14	5	437	4	uneart_hing
unfading	13	4	769	4	unfa___ding
unfailing	13	3	745	4	unfa__iling
unfalteringly	20	6	179	4	unfalteringly
unfeeling	13	3	711	4	unf__eeling
unfencing	15	4	595	4	unf___encing
unfitting	13	3	642	4	unf_it_ting
unfreeing	13	4	510	4	unf__reeing
unfreezing	23	4	334	4	unf_reezing
unhatting	13	3	587	4	unha_t_ting
unlashing	13	3	649	4	unlas__hing
unlatching	16	4	315	4	unla_tching
unloosening	12	5	156	4	unloosening
unmanning	12	4	587	4	unma__nning
unmasking	16	3	526	4	unmas__king
unmitering	13	4	500	4	un_mitering
unpretending	16	7	283	4	unpretending
unraveling	14	5	447	4	unra_veling
unreasoning	12	4	297	4	unreas_oning
unresting	10	3	1113	4	unrest__ing
unseeing	9	8	829	4	un__s_eeing
unsetting	10	8	899	4	un__setting
unsewing	12	8	743	4	un__s_ewing
unsexing	16	8	685	4	un__s_exing
unstating	10	7	1121	4	un__stating
unsteeling	11	4	518	4	un__steeling
unstepping	15	4	344	4	un__stepping
unstinting	11	4	730	4	un__stinting
unstring	9	3	1209	4	un__st_ring
untuning	9	3	794	4	un___tuning
unwaning	12	3	813	4	unwa___ning
unwavering	17	4	322	4	unwa_vering
upcasting	14	3	482	4	upcast__ing

Search took 10 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	148819	0.420	425454.8
2	DLD Change Limit	148819	83	8.643	17218.4
3	Display Results	83	83	0.046	1804.3
	(SQL Overall)	178691	83	9.109	19617.0