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

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

31 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
unsightliness	17	6	251	(None)
knightliness	20	5	273	2	kn_ightliness
sightliness	15	7	456	2	__sightliness
unsightliest	16	5	219	2	unsightli_est
unsightlinesses	19	6	221	2	unsightlinesses
sightlines	14	6	575	3	__sightline_s
sprightliness	19	6	209	3	sprightliness
unsightlier	15	5	166	3	unsightli_e_r
almightiness	18	5	191	4	almight_iness
flightiness	18	4	389	4	_flight_iness
knightlinesses	22	8	244	4	kn_ightlinesses
mightiness	16	4	509	4	__might_iness
naughtiness	15	4	238	4	_naught_iness
nightless	13	8	607	4	_n_ightl__ess
nightlifes	17	9	375	4	_n_ightlife_s
nightlives	17	6	380	4	_n_ightlive_s
sightless	13	8	592	4	__sightl__ess
sightliest	14	4	510	4	__sightli_est
sightline	13	4	568	4	__sightline__
sightlinesses	17	4	386	4	__sightlinesses
unearthliness	16	5	239	4	unearthliness
ungodliness	13	5	278	4	un__godliness
unholiness	13	4	498	4	un___holiness
unkindliness	17	7	259	4	unki_ndliness
unlikeliness	16	5	251	4	unli_keliness
unseemliness	14	5	236	4	uns_eemliness
unsighting	15	8	444	4	unsight_in__g
untimeliness	14	5	350	4	unti_meliness
uprightness	17	5	285	4	upright__ness
uptightness	17	5	214	4	uptight__ness
weightiness	18	4	326	4	_weight_iness

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	95024	0.126	1418182.5
2	DLD Change Limit	95024	31	7.436	12778.9
3	Display Results	31	31	0.016	1937.5
	(SQL Overall)	178691	31	7.578	23580.2