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

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

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.

37 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
lightfastness	20	6	131	(None)
lightfastnesses	22	6	143	2	lightfastnesses
lightfaces	19	7	309	4	lightfa__ce_s
lightfast	16	4	364	4	lightfast____
lightness	13	10	743	4	ligh____tness
lightsomeness	19	8	201	4	lightsomeness
rightfulness	19	9	489	4	rightf_ulness
sightlessness	16	5	415	4	sightlessness
tightfistedness	23	13	104	4	tightfistedness
colorfastness	18	6	125	5	colorfastness
delightfulness	22	6	189	5	delightf_ulness
distantness	12	5	433	5	di_st_antness
fastness	11	23	876	5	_____fastness
flightiness	18	4	389	5	flight___iness
frightfulness	23	6	320	5	frightf_ulness
gastness	9	27	847	5	__g___astness
ignorantness	13	11	186	5	_ignorantness
instantness	11	5	408	5	_inst_antness
intactness	12	4	431	5	_i_nt_actness
lighteners	14	4	498	5	light___eners
lightface	18	6	306	5	lightfa__ce__
lightfaced	20	7	225	5	lightfa__ce_d
lightless	13	8	607	5	ligh____tless
lightnesses	15	4	614	5	lightnes_se_s
lightplanes	17	5	239	5	light_plane_s
limitlessness	15	5	334	5	limitlessness
listlessness	11	4	582	5	li_stlessness
mightiness	16	4	509	5	might___iness
militantness	14	5	190	5	milit_antness
righteousness	17	6	392	5	righteousness
rightness	13	11	735	5	righ____tness
sightliness	15	7	456	5	sight__liness
slightness	14	5	480	5	sligh____tness
steadfastness	17	6	85	5	steadfastness
tightfisted	19	8	144	5	tightfist_e_d
tightness	13	8	660	5	tigh____tness
weightlessness	21	6	242	5	weightlessness

Search took 8 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	124790	0.160	1116818.8
2	DLD Change Limit	124790	37	7.593	16434.9
3	Display Results	37	37	0.013	2846.2
	(SQL Overall)	178691	37	7.766	23009.4