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

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

43 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
redfins	11	3	992	(None)
redfin	10	3	1022	1	redfin_
beduins	10	3	912	2	beduins
elfins	9	48	1094	2	_elfins
reagins	8	42	1564	2	reagins
recoins	9	40	1924	2	recoins
redans	7	54	2102	2	red_ans
reddens	9	25	978	2	reddens
redding	10	32	1851	2	redding
redefies	12	7	1016	2	redefies
redefine	12	3	897	2	redefine
redefines	13	4	741	2	redefines
redfish	14	3	779	2	redfish
redias	7	45	2360	2	red_ias
reding	8	38	2556	2	red_ing
redips	9	37	1384	2	red_ips
redline	8	42	1883	2	redline
redlines	9	39	1608	2	redlines
redoing	9	35	1673	2	redoing
redons	7	52	2218	2	red_ons
redries	8	37	2171	2	redries
redskins	13	8	587	2	redskins
redwing	12	28	1198	2	redwing
redwings	13	30	573	2	redwings
reefing	11	40	1686	2	reefing
reffing	14	37	1217	2	reffing
refind	10	47	1707	2	re_find
refinds	11	45	1212	2	re_finds
refine	9	52	2569	2	re_fine
refines	10	54	2634	2	re_fines
refits	9	40	1765	2	re_fits
regains	8	43	1658	2	regains
reifies	10	42	1828	2	reifies
reins	5	62	3456	2	re__ins
rejoins	14	31	1138	2	rejoins
remains	9	41	1791	2	remains
renins	6	45	2645	2	re_nins
rennins	7	40	1341	2	rennins
repins	8	49	2431	2	re_pins
requins	16	3	1020	2	requins
resins	6	45	2877	2	re_sins
retains	7	45	2225	2	retains
rewins	9	50	2082	2	re_wins

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.360	496363.9
2	DLD Change Limit	107671	43	3.296	32667.2
3	Display Results	43	43	0.013	3307.7
	(SQL Overall)	178691	43	3.669	48702.9