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

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

55 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
petticoated	16	5	211	(None)
petticoat	13	5	442	2	petticoat__
petticoats	14	5	251	2	petticoat_s
metricated	15	4	730	3	metric_ated
multicoated	16	5	457	3	multicoated
pettifogged	19	6	108	3	pettifogged
aestivated	14	10	629	4	aesti_vated
busticated	15	4	573	4	bustic_ated
dedicated	14	3	1025	4	de_dic_ated
denticulated	16	5	439	4	denticulated
desiccated	16	4	499	4	de_siccated
detoxicated	22	5	349	4	detoxic_ated
estimated	12	10	944	4	_esti_mated
estivated	13	10	832	4	_esti_vated
etiolated	10	4	707	4	_e_tiolated
exsiccated	22	4	249	4	_exsiccated
extirpated	20	4	312	4	_extirpated
extricated	20	6	708	4	extric_ated
festinated	14	4	753	4	festi_nated
gesticulated	16	5	454	4	gesticulated
helicopted	18	5	270	4	he_licopted
jettisoned	18	5	159	4	jettiso_ned
masticated	15	4	823	4	mastic_ated
medicated	15	4	1007	4	me_dic_ated
metricate	13	4	992	4	metric_ate_
metricates	14	4	912	4	metric_ates
participated	19	5	370	4	participated
patinated	12	39	1141	4	p_ati_nated
patriated	12	3	853	4	patri__ated
patriciate	14	4	632	4	patriciate_
patriciates	15	4	532	4	patriciates
pectinate	13	4	955	4	pecti_nate_
pepsinated	15	4	523	4	pepsi_nated
percolated	15	4	825	4	pe__rcolated
petiolate	11	4	915	4	pe_tiolate_
petioled	11	3	799	4	pe_ti_o_led
petitioned	13	4	417	4	petitio_ned
pettifogger	18	7	117	4	pettifogger
pettitoes	11	4	418	4	pettito__es
picoted	12	3	921	4	p___ico_ted
picrated	13	21	1011	4	p___icrated
plicated	13	3	1064	4	p__lic_ated
porticoed	14	4	542	4	portico__ed
predicated	16	4	914	4	predic_ated
recoated	11	34	1678	4	re___coated
redictated	14	4	748	4	re_dictated
replicated	15	4	877	4	replic_ated
reticulated	14	12	778	4	re_ticulated
rusticated	13	4	699	4	rustic_ated
tailcoated	13	4	328	4	__tailcoated
tittivated	14	4	290	4	titti_vated
urticated	12	4	769	4	_urtic_ated
vellicated	16	4	480	4	vellic_ated
ventilated	14	4	636	4	venti_lated
vesicated	15	11	765	4	ve_sic_ated

Search took 9 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	55	8.390	17737.7
3	Display Results	55	55	0.033	1666.7
	(SQL Overall)	178691	55	8.846	20200.2