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

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

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.

87 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
fenestrated	15	5	424	(None)
fenestrate	13	4	529	1	fenestrate_
defenestrated	18	6	214	2	defenestrated
fenestrae	12	4	378	2	fenestra_e_
penetrated	13	4	730	2	pene_trated
defenestrate	16	6	264	3	defenestrate_
defenestrates	17	6	246	3	defenestrates
denitrated	12	9	803	3	den_itrated
federated	14	3	842	3	fede__rated
fenestra	11	4	355	3	fenestra___
fenestral	12	4	411	3	fenestra__l
fenestration	15	9	607	3	fenestration
frustrated	14	4	410	3	f_rustrated
generated	11	3	1020	3	gene__rated
menstruated	14	7	374	3	men_struated
penetrate	11	4	923	3	pene_trate_
penetrates	12	4	872	3	pene_trates
sequestrated	22	5	217	3	sequestrated
venerated	13	3	995	3	vene__rated
castrated	12	3	951	4	__castrated
celebrated	15	5	622	4	cele_brated
cerebrated	15	4	634	4	cere_brated
concentrated	17	11	673	4	concentrated
consecrated	16	4	691	4	consecrated
deaerated	11	3	1111	4	deae__rated
decelerated	15	4	592	4	decelerated
degenerated	14	4	574	4	degenerated
delectated	14	4	672	4	delect_ated
demonstrated	16	13	489	4	demonstrated
denervated	15	4	511	4	dene_rvated
denigrated	13	6	697	4	den_igrated
denitrate	10	8	1053	4	den_itrate_
denitrates	11	6	951	4	den_itrates
dentated	10	4	1170	4	den__t_ated
desecrated	14	4	795	4	dese_crated
devastated	15	4	412	4	devast_ated
effectuated	20	5	199	4	effectuated
enervated	13	4	731	4	_ene_rvated
entreated	10	3	1097	4	_en__treated
enumerated	13	12	578	4	_enumerated
estated	8	37	1557	4	___est_ated
estrayed	12	3	639	4	___estrayed
estreated	10	3	955	4	___estreated
eventuated	14	10	371	4	_eventuated
execrated	19	3	835	4	_exe_crated
exenterated	19	6	479	4	_exenterated
federate	12	3	1088	4	fede__rate_
federates	13	3	1015	4	fede__rates
fenestrations	16	9	540	4	fenestrations
festinated	14	4	753	4	f__estinated
filtrated	13	4	596	4	f__iltrated
frustrate	12	4	558	4	f_rustrate_
frustrates	13	4	500	4	f_rustrates
generate	9	3	1290	4	gene__rate_
generates	10	3	1271	4	gene__rates
gestated	10	29	1057	4	__gest_ated
hebetated	15	4	466	4	hebe_t_ated
illustrated	12	6	273	4	illustrated
impetrated	15	4	436	4	impe_trated
instated	9	16	1334	4	_in_st_ated
lustrated	10	3	796	4	__lustrated
menstruate	12	4	441	4	men_struate_
menstruates	13	4	398	4	men_struates
nitrated	9	22	1315	4	__n_itrated
orchestrated	18	7	341	4	orchestrated
pedestaled	14	4	292	4	pedest_aled
perpetrated	16	7	507	4	perpetrated
prostrated	13	4	942	4	_prostrated
redecorated	15	4	496	4	redecorated
reestimated	14	4	595	4	re_estimated
regenerated	13	4	690	4	regenerated
reinstated	11	4	728	4	reinst_ated
remonstrated	15	14	557	4	remonstrated
renegotiated	14	5	236	4	renegotiated
renested	9	22	1295	4	renes___ted
restarted	10	4	1005	4	__restarted
restated	9	31	2018	4	__rest_ated
ringstraked	17	5	100	4	ringstraked
sensated	9	3	818	4	sen_s__ated
sequestrate	20	5	293	4	sequestrate_
sequestrates	21	5	248	4	sequestrates
uncastrated	14	4	538	4	uncastrated
unstated	9	16	1581	4	_un_st_ated
vegetated	14	4	508	4	vege_t_ated
venenated	13	4	590	4	vene__nated
venerate	11	3	1290	4	vene__rate_
venerates	12	3	1226	4	vene__rates

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	87	9.420	15798.2
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	9.889	18069.7