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

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

21 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
chippie	16	29	769	(None)
chappie	16	29	866	1	chappie
chippier	17	29	767	1	chippier
chippies	17	30	976	1	chippies
hippie	13	28	1124	1	_hippie
chappies	17	26	1010	2	chappies
cheapie	14	3	756	2	cheapie
chipped	17	41	1081	2	chipped
chipper	16	39	1258	2	chipper
chippiest	18	25	681	2	chippiest
chipping	18	38	979	2	chipping
chippy	18	43	761	2	chipp_y
chirpier	15	27	630	2	chirpier
choppier	17	28	665	2	choppier
crappie	13	29	899	2	crappie
cripple	13	37	858	2	cripple
croppie	13	27	880	2	croppie
hippier	14	32	1210	2	_hippier
hippies	14	28	1375	2	_hippies
whippier	18	26	582	2	whippier
yippie	13	27	784	2	_yippie

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	107671	0.356	501941.0
2	DLD Change Limit	107671	21	3.266	32967.2
3	Display Results	21	21	0.016	1312.5
	(SQL Overall)	178691	21	3.638	49117.9