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

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

59 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
resign	7	42	1258	(None)
design	8	40	893	1	design
reign	6	50	1519	1	re_ign
resigns	8	39	1096	1	resigns
resin	5	41	3105	1	resi_n
assign	7	3	678	2	assign
benign	9	3	831	2	benign
cosign	9	5	878	2	cosign
deign	7	43	1280	2	de_ign
designs	9	32	831	2	designs
ensign	7	3	752	2	ensign
feign	9	42	1071	2	fe_ign
lesion	6	47	1506	2	lesion
mesian	8	43	1550	2	mesian
rasing	7	43	3083	2	rasing
reagin	7	49	1553	2	reagin
realign	8	3	876	2	realign
reassign	9	5	542	2	reassign
redesign	10	4	507	2	redesign
reding	8	38	2556	2	reding
region	7	46	1490	2	region
reigns	7	48	1175	2	re_igns
rein	4	60	4089	2	re_i_n
rejig	13	38	1012	2	rejig_
rejigs	14	36	809	2	rejigs
renig	6	45	1891	2	renig_
renigs	7	43	1459	2	renigs
renin	5	48	3003	2	reni_n
repin	7	53	2470	2	repi_n
repugn	9	4	649	2	repugn
rerig	6	40	1848	2	rerig_
rerigs	7	40	1479	2	rerigs
resawn	9	39	995	2	resawn
reseen	6	43	1841	2	reseen
resewn	9	45	981	2	resewn
resid	6	41	2409	2	resi_d
reside	7	42	2493	2	reside
resids	7	42	1915	2	resids
resift	9	40	1772	2	resift
resight	11	5	1064	2	resight
resigned	10	3	886	2	resigned
resigner	9	3	779	2	resigner
resile	6	46	2767	2	resile
resilin	7	29	1397	2	resilin
resins	6	45	2877	2	resins
resiny	9	46	1736	2	resiny
resist	6	45	2453	2	resist
resit	5	42	4104	2	resi_t
resite	6	41	2845	2	resite
resits	6	47	2556	2	resits
resize	15	41	1772	2	resize
resown	9	41	1292	2	resown
resting	8	50	3118	2	resting
reusing	8	25	1678	2	reusing
rewin	8	56	2396	2	rewi_n
rising	7	40	2588	2	rising
rosin	5	53	2531	2	rosi_n
rosing	7	39	2559	2	rosing
sign	5	55	2305	2	__sign

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	59	2.283	36159.0
3	Display Results	59	59	0.013	4538.5
	(SQL Overall)	178691	59	2.639	67711.6