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

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

82 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
cantonments	15	5	441	(None)
cantonment	14	4	597	1	cantonment_
abandonments	17	169	542	3	abandonments
atonements	12	4	720	3	_a_tonements
attornments	13	5	395	3	_attornments
canzonets	20	4	448	3	canzon_e_ts
catchments	19	4	445	3	ca_tchments
containments	16	5	578	3	containments
contentments	16	5	548	3	contentments
continents	12	4	956	3	contin_ents
contingents	14	4	637	3	contingents
controlments	16	8	444	3	controlments
abandonment	16	190	586	4	abandonment_
adornments	13	4	516	4	_adornments
alignments	13	4	463	4	_alignments
allotments	12	4	446	4	_allotments
annulments	12	4	465	4	_annulments
anointments	13	5	543	4	_anointments
atonement	11	4	905	4	_a_tonement_
attainments	13	5	394	4	_attainments
attornment	12	7	458	4	_attornment_
attunements	13	5	372	4	_attunements
banishments	18	6	429	4	banishments
battements	14	5	581	4	ba_ttements
battlements	15	4	496	4	battlements
cajolements	22	5	416	4	cajolements
cannoneers	12	4	332	4	cannon_eers
canoness	10	3	939	4	can_on_e_ss
canonists	11	5	851	4	can_on_ists
canteens	10	3	857	4	cant__een_s
cantilenas	12	4	386	4	cant_ilenas
cantoned	11	14	1152	4	canton_e__d
cantoning	12	3	1088	4	canton_in_g
cantons	9	52	2120	4	canto___n_s
canyoneers	15	4	294	4	canyon_eers
canyonings	16	4	287	4	canyon_ings
canzones	19	3	915	4	canzon_e__s
canzonet	19	4	1058	4	canzon_e_t_
casements	13	4	858	4	ca__sements
castanets	11	4	633	4	castan_e_ts
catchment	18	4	629	4	ca_tchment_
catmints	12	3	666	4	ca_t__mints
centones	10	3	1366	4	centon_e__s
comments	14	29	1388	4	c___omments
components	16	4	694	4	compon_ents
concents	12	25	1660	4	c___oncents
concernments	18	6	524	4	concernments
condiments	15	4	819	4	con_diments
conferments	18	4	832	4	conferments
confinements	19	5	494	4	confinements
consents	10	27	1589	4	c___onsents
consignments	17	5	393	4	consignments
consonants	12	4	648	4	conson_ants
containment	15	5	744	4	containment_
contentment	15	5	666	4	contentment_
contents	10	40	1821	4	c___ontents
continent	11	4	1563	4	contin_ent_
contingent	13	4	908	4	contingent_
continuants	13	12	532	4	continuants
controlment	15	9	578	4	controlment_
convents	13	26	1460	4	c___onvents
cotangents	13	4	416	4	c_otangents
denotements	14	4	686	4	denotements
endowments	16	4	551	4	_endowments
enjoyments	22	5	407	4	_enjoyments
enrolments	12	4	685	4	_enrolments
entombments	17	5	357	4	_entombments
extolments	19	4	440	4	_extolments
hatchments	20	4	388	4	ha_tchments
intendments	14	5	570	4	_intendments
interments	12	7	1621	4	_interments
internments	13	5	1028	4	_internments
inurnments	12	4	593	4	_inurnments
malcontents	15	11	261	4	malcontents
managements	16	5	531	4	managements
ointments	11	6	665	4	oint__ments
santonins	9	4	845	4	santon_in_s
sentiments	12	4	827	4	sent_iments
tanglements	14	5	473	4	tanglements
torments	10	3	1045	4	___torments
wantoners	12	11	667	4	wanton_e_rs
wantonness	13	4	284	4	wantonne_ss

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.156	1145455.1
2	DLD Change Limit	148819	82	9.266	16060.8
3	Display Results	82	82	0.046	1782.6
	(SQL Overall)	178691	82	9.468	18873.2