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

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

24 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
abbeys	13	53	842	(None)
abbes	9	67	2352	1	abbe_s
abbess	10	50	977	1	abbess
abbey	12	57	1493	1	abbey_
abbas	9	59	1864	2	abb_as
abbe	8	76	2719	2	abbe__
abbots	10	3	928	2	abbots
abets	7	56	2167	2	a_bets
ables	7	59	3554	2	able_s
abyes	10	55	1853	2	abye_s
abys	9	72	2188	2	a_b_ys
alleys	9	51	1330	2	alleys
ambers	10	45	1958	2	ambers
babels	10	52	1672	2	babels
babes	9	58	3411	2	babe_s
beys	9	138	2955	2	__beys
dabbers	12	38	1321	2	dabbers
ebbets	10	37	683	2	ebbets
gabbers	12	46	1283	2	gabbers
jabbers	18	36	1058	2	jabbers
nabbers	11	37	1046	2	nabbers
obeys	10	70	1064	2	_obeys
rabbets	11	27	942	2	rabbets
yabbers	14	38	935	2	yabbers

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	24	2.470	33421.5
3	Display Results	24	24	0.016	1500.0
	(SQL Overall)	178691	24	2.829	63164.0