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

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

64 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
detrainments	15	7	465	(None)
detainments	14	8	589	1	det_ainments
detrainment	14	9	538	1	detrainment_
derailments	14	4	610	2	de_railments
detainment	13	7	714	2	det_ainment_
detriments	13	4	736	2	detr_i_ments
entrainments	14	6	545	2	entrainments
refrainments	17	5	400	2	refrainments
attainments	13	5	394	3	_attainments
depravements	20	5	445	3	depravements
derailment	13	4	687	3	de_railment_
detachments	19	5	459	3	det_achments
detriment	12	4	969	3	detr_i_ment_
edutainments	15	5	249	3	edutainments
entrainment	13	5	662	3	entrainment_
obtainments	15	5	349	3	obt_ainments
refrainment	16	5	448	3	refrainment_
arraignments	15	5	316	4	_arraignments
ascertainments	18	6	174	4	ascertainments
astringents	12	5	391	4	astr_ingents
attainment	12	5	501	4	_attainment_
containments	16	5	578	4	containments
curtailments	16	5	202	4	curtailments
debarments	15	4	585	4	de_ba_rments
debasements	16	6	617	4	de_basements
debatements	16	5	604	4	de_batements
debridements	18	5	389	4	debridements
decampments	20	7	352	4	de_campments
decrements	15	4	938	4	decr__ements
defacements	19	4	607	4	de_facements
definements	17	4	711	4	de__finements
departments	16	4	579	4	de_partments
depravement	19	5	500	4	depravement_
derangements	16	6	582	4	de_rangements
designments	15	4	512	4	de_signments
despoilments	17	5	340	4	despoilments
detachment	18	4	588	4	det_achment_
detainees	10	26	715	4	det_ain_e_es
detainers	10	26	910	4	det_ain_e_rs
determents	13	10	1031	4	det__erments
determinants	15	5	347	4	determin_ants
dethronements	19	6	277	4	dethronements
detrained	11	5	891	4	detrain_e__d
detraining	12	6	767	4	detrain_in_g
detrains	9	4	1176	4	detrai___n_s
detrimental	14	5	485	4	detr_i_mental
detrimentals	15	5	395	4	detr_i_mentals
devilments	16	4	638	4	de__vilments
edutainment	14	5	258	4	edutainment_
eloinments	12	4	599	4	_e_loinments
enchainments	19	5	348	4	enchainments
entailments	13	4	635	4	_entailments
entertainments	16	7	245	4	entertainments
entrapments	15	4	629	4	entra_pments
merriments	14	4	632	4	me_rri_ments
nutriments	12	4	480	4	nutr_i_ments
obtainment	14	5	431	4	obt_ainment_
ordainments	14	5	354	4	_ordainments
preordainments	19	8	151	4	preordainments
raiments	10	3	990	4	___rai_ments
recruitments	16	11	339	4	recruitments
retrainees	10	4	639	4	retrain_e_es
tetrahymenas	20	6	115	4	tetrahymenas
trainmen	10	4	615	4	__trainmen__

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	124790	0.390	458182.1
2	DLD Change Limit	124790	64	7.830	15937.4
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	8.250	21659.5