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

Here are the results of your fuzzy-string dictionary search for “redictated” with Change Limit: [1] [2] [3] [4]

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.

68 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
redictated	14	4	748	(None)
redictate	12	4	906	1	redictate_
redictates	13	4	823	1	redictates
dedicated	14	3	1025	2	dedic_ated
dictated	12	3	920	2	__dictated
medicated	15	4	1007	2	medic_ated
meditated	13	4	808	2	medi_tated
predicated	16	4	914	2	predic_ated
radicated	13	4	1012	2	radic_ated
reluctated	13	4	594	2	reluctated
abdicated	15	4	701	3	abdic_ated
crepitated	15	8	474	3	crepi_tated
dedicate	12	3	1280	3	dedic_ate_
dedicatee	13	4	1034	3	dedic_atee
dedicates	13	3	1169	3	dedic_ates
delectated	14	4	672	3	delectated
desiccated	16	4	499	3	desiccated
dictate	10	3	1166	3	__dictate_
dictates	11	3	1138	3	__dictates
educated	12	3	794	3	_educ_ated
eradicated	14	4	687	3	eradic_ated
eructated	12	4	564	3	_eructated
felicitated	17	4	356	3	felicitated
hesitated	13	7	778	3	hesi_tated
indicated	13	3	1095	3	indic_ated
levitated	13	4	641	3	levi_tated
mediated	12	30	1187	3	medi__ated
medicate	13	5	1324	3	medic_ate_
medicates	14	3	1211	3	medic_ates
meditate	11	3	1062	3	medi_tate_
meditates	12	3	981	3	medi_tates
nictated	11	3	779	3	__nictated
predicate	14	4	1178	3	predic_ate_
predicates	15	4	1082	3	predic_ates
predicted	15	3	891	3	predic__ted
radiated	10	25	1259	3	radi__ated
radicate	11	4	1287	3	radic_ate_
radicates	12	4	1207	3	radic_ates
recoated	11	34	1678	3	re__coated
recrated	11	29	1860	3	re__crated
redacted	12	4	1024	3	redac__ted
redated	9	31	2092	3	red___ated
redecorated	15	4	496	3	redecorated
rededicated	16	14	481	3	rededic_ated
redefeated	15	4	488	3	redefeated
redialed	10	3	1079	3	redi__aled
redictating	15	4	680	3	redictating
redigested	13	5	411	3	redigested
redirected	14	4	477	3	redirected
reductase	12	4	455	3	reductase_
reductases	13	4	428	3	reductases
reeducated	14	8	482	3	reeduc_ated
refitted	12	30	941	3	refi_t_ted
reinstated	11	4	728	3	reinstated
relocated	12	7	1081	3	reloc_ated
reluctate	11	4	692	3	reluctate_
reluctates	12	4	670	3	reluctates
remigrated	14	4	749	3	remigrated
remitted	11	33	1207	3	remi_t_ted
replicated	15	4	877	3	replic_ated
resinated	10	4	1328	3	resi_nated
resituated	11	4	732	3	resituated
restated	9	31	2018	3	re__stated
reticulated	14	12	778	3	reticulated
revibrated	16	4	544	3	revibrated
revictualed	17	5	148	3	revictualed
reviolated	14	4	625	3	reviolated
vesicated	15	11	765	3	vesic_ated

Search took 7 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	140603	0.406	440125.6
2	DLD Change Limit	140603	68	6.470	21731.5
3	Display Results	68	68	0.030	2266.7
	(SQL Overall)	178691	68	6.906	25874.7