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

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

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.

23 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
whistlers	15	9	516	(None)
whistler	14	9	631	1	whistler_
whistles	14	10	821	1	whistle_s
whittlers	15	9	433	1	whittlers
chiselers	14	4	545	2	chiselers
epistlers	11	5	411	2	epistlers
hostlers	11	33	1048	2	_hostlers
hustlers	11	34	920	2	_hustlers
thistles	11	9	823	2	thistle_s
waisters	11	38	1152	2	waist_ers
waistless	12	3	509	2	waistless
warstlers	12	28	471	2	warstlers
whifflers	21	4	277	2	whifflers
whirlers	14	28	605	2	whi_rlers
whiskers	18	30	677	2	whis_kers
whispers	16	26	699	2	whis_pers
whistle	13	10	753	2	whistle__
whistled	15	9	578	2	whistle_d
whitters	14	35	940	2	whi_tters
whittler	14	9	519	2	whittler_
whittles	14	9	667	2	whittle_s
wrestlers	12	30	610	2	wrestlers
wristlets	12	4	447	2	wristlets

Search took 4 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	121436	0.140	1276364.3
2	DLD Change Limit	121436	23	3.486	34835.3
3	Display Results	23	23	0.013	1769.2
	(SQL Overall)	178691	23	3.639	49104.4