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

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

66 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
chartreuses	16	5	221	(None)
chartreuse	15	5	194	1	chartreuse_
chanteuses	15	4	380	2	chant_euses
charmeuses	17	4	309	2	char_meuses
chanteuse	14	4	347	3	chant_euse_
charinesses	16	3	956	3	charinesses
charmeuse	16	4	259	3	char_meuse_
chartless	14	3	570	3	chartle_s_s
actresses	11	3	793	4	__actresses
apartnesses	13	4	682	4	apartnesses
cactuses	12	3	793	4	c_act__uses
caresses	10	3	1406	4	c_a__resses
caroluses	11	5	761	4	c_ar_oluses
carouses	10	6	1450	4	c_a__rouses
carrousel	11	7	437	4	c_ar_rousel
carrousels	12	5	326	4	c_ar_rousels
cartelises	12	4	768	4	c_artelises
carthorses	15	4	636	4	c_arthorses
cartridges	14	7	283	4	c_artridges
cateresses	12	4	835	4	c_ateresses
cathouses	14	3	943	4	c_a_thouses
ceratoduses	14	5	185	4	ceratoduses
cereuses	10	4	924	4	c___ereuses
chanterelles	17	5	190	4	chanterelles
chantries	14	3	1029	4	chantr__ies
charases	13	13	1276	4	cha__r_ases
chariness	14	3	1006	4	charine_s_s
charmless	16	3	358	4	charmle_s_s
chartered	15	15	839	4	chart_e_red
charterer	14	19	732	4	chart_e_rer
charterers	15	14	605	4	chart_erers
charters	13	41	1558	4	chart_e__rs
chartists	14	12	680	4	chart__ists
chasteness	15	4	652	4	chast_eness
chastenesses	17	4	631	4	chastenesses
chastises	14	3	770	4	chast__ises
chattinesses	17	5	515	4	chattinesses
choraguses	16	4	254	4	chor_aguses
choreguses	16	4	297	4	chor_eguses
choruses	13	3	998	4	ch__or_uses
citruses	10	3	748	4	c__itr_uses
coatdresses	14	4	394	4	coatdresses
courthouses	16	5	395	4	courthouses
curtnesses	12	3	837	4	c_urtnesses
enchantresses	18	10	132	4	enchantresses
fortresses	13	4	566	4	_fortresses
hardnesses	14	18	1054	4	_hardnesses
harnesses	12	18	1207	4	_har_nesses
harquebuses	25	5	130	4	_harquebuses
heartseases	14	5	259	4	heartseases
huntresses	13	4	528	4	_huntresses
mattresses	12	4	543	4	_mattresses
oratresses	10	4	549	4	ora_tresses
peartnesses	13	3	874	4	peartnesses
portresses	12	4	731	4	_portresses
sharpnesses	16	4	523	4	sharpnesses
shirtdresses	16	5	186	4	shirtdresses
shortnesses	14	4	679	4	shortnesses
smartnesses	13	3	714	4	smartnesses
swartnesses	14	3	671	4	swartnesses
tartnesses	10	11	1071	4	_tartnesses
therapeuses	16	5	205	4	therapeuses
traitresses	11	4	460	4	traitresses
waitresses	13	4	506	4	_waitresses
wardresses	14	4	541	4	_wardresses
whatnesses	16	3	573	4	wha_tnesses

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.483	369960.7
2	DLD Change Limit	148819	66	9.143	16276.8
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	9.656	18505.7