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

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

65 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
recodes	10	29	1863	(None)
decodes	11	39	1498	1	decodes
precodes	13	7	1157	1	precodes
recedes	10	28	1606	1	recedes
recode	9	36	1871	1	recode_
recoded	11	31	1504	1	recoded
becomes	13	29	1196	2	becomes
codes	8	62	4729	2	__codes
decades	11	36	1551	2	decades
decides	11	42	1765	2	decides
decode	10	44	1474	2	decode_
decoded	12	32	1239	2	decoded
decoder	11	37	1229	2	decoder
decoders	12	28	1041	2	decoders
encodes	10	3	1064	2	encodes
epodes	9	43	1556	2	_epodes
erodes	7	48	1988	2	_erodes
geodes	8	4	1215	2	ge_odes
precedes	13	3	1071	2	precedes
precode	12	3	1185	2	precode_
precoded	14	3	886	2	precoded
rebodies	11	3	916	2	rebodies
rebores	9	53	1916	2	rebores
recanes	9	32	2226	2	recanes
recces	10	6	1491	2	rec_ces
recede	9	55	1553	2	recede_
receded	11	27	1304	2	receded
recipes	11	33	1446	2	recipes
recites	9	35	2458	2	recites
recoals	9	42	1463	2	recoals
recoats	9	26	1664	2	recoats
recocks	15	47	1146	2	recocks
recoils	9	38	1487	2	recoils
recoins	9	40	1924	2	recoins
recombs	13	3	675	2	recombs
recons	8	49	2299	2	reco_ns
recooks	13	47	1123	2	recooks
recopies	12	3	1374	2	recopies
recorded	12	25	1107	2	recorded
recorder	11	24	963	2	recorder
recorders	12	18	795	2	recorders
records	10	52	1392	2	records
recorks	13	48	1302	2	recorks
recoups	11	8	884	2	recoups
recover	12	43	1262	2	recover
recovers	13	35	1112	2	recovers
recuses	9	46	1946	2	recuses
redes	6	51	3913	2	re__des
redoes	7	46	2377	2	redo_es
redoxes	15	3	1088	2	redoxes
remodel	10	3	809	2	remodel
remodels	11	3	567	2	remodels
remotes	9	45	2161	2	remotes
removes	12	45	1471	2	removes
reposes	9	40	2126	2	reposes
rescores	10	54	1569	2	rescores
resides	8	45	2328	2	resides
resods	7	41	1630	2	resod_s
resoles	7	38	2365	2	resoles
revokes	14	42	1250	2	revokes
revotes	10	47	1639	2	revotes
rezones	16	32	1394	2	rezones
rodes	6	140	3908	2	r__odes
secedes	10	37	1198	2	secedes
secondes	11	3	813	2	secondes

Search took 5 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.390	458182.1
2	DLD Change Limit	107671	65	3.656	29450.5
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	4.062	43990.9