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

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

83 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
impairments	17	5	387	(None)
impairment	16	4	468	1	impairment_
impalements	17	4	643	2	impalements
impartments	17	4	535	2	impartments
impaints	12	3	624	3	impai___nts
impairers	13	4	371	3	impair_e_rs
impalement	16	4	761	3	impalement_
impartment	16	4	649	3	impartment_
impeachments	23	5	268	3	impeachments
impediments	18	7	447	3	impediments
imperilments	18	15	434	3	imperilments
implements	16	4	785	3	imp_lements
ailments	10	3	943	4	___ailments
amassments	14	4	449	4	am_assments
amazements	23	4	531	4	am_azements
apartments	14	4	570	4	_apartments
attainments	13	5	394	4	attainments
bailments	13	4	646	4	__bailments
compartments	20	9	433	4	compartments
compliments	19	4	658	4	compli_ments
coparents	13	4	797	4	copa_r_ents
copayments	19	4	431	4	copa_yments
debarments	15	4	585	4	deba_rments
departments	16	4	579	4	departments
derailments	14	4	610	4	derailments
detainments	14	8	589	4	detainments
disbarments	16	5	493	4	disba_rments
embalmments	16	5	384	4	embalmments
embankments	21	18	364	4	embankments
embarkments	21	6	400	4	embarkments
embayments	19	4	451	4	emba_yments
emplacements	20	5	457	4	emplacements
employments	20	5	424	4	employments
empowerments	21	5	241	4	empowerments
entailments	13	4	635	4	entailments
experiments	22	5	591	4	experiments
garments	11	3	996	4	__ga_rments
imarets	9	13	864	4	im_a_r_e_ts
imbuements	16	4	502	4	im_buements
immurements	14	7	478	4	immurements
impaint	11	5	1122	4	impai___nt_
impaired	13	3	514	4	impair_e__d
impairer	12	4	486	4	impair_e__r
impairing	14	4	547	4	impair_in_g
impairs	11	3	582	4	impair____s
imparters	13	27	657	4	impa_rte_rs
imparts	11	29	853	4	impa_r___ts
impatiens	13	4	573	4	impa_tien_s
impatient	13	4	775	4	impa_tient_
impeachment	22	5	318	4	impeachment_
impediment	17	7	512	4	impediment_
impedimenta	18	7	345	4	impedimenta
impellents	14	4	436	4	imp_ellents
imperfects	19	4	288	4	imp_erfects
imperilment	17	14	498	4	imperilment_
impingements	19	5	341	4	impingements
implement	15	4	953	4	imp_lement_
impotents	13	4	700	4	imp__otents
impoundments	19	7	243	4	impoundments
impressments	18	5	396	4	impressments
imprests	12	4	631	4	imp__r_ests
imprints	12	4	730	4	imp__r_ints
imprisonments	19	6	199	4	imprisonments
improvements	21	7	397	4	improvements
inpatients	12	4	429	4	inpa_tients
interments	12	7	1621	4	i_nterments
margents	11	4	1013	4	_m_a_rgents
merriments	14	4	632	4	_merriments
muniments	13	4	614	4	_muni_ments
obtainments	15	5	349	4	obtainments
ordainments	14	5	354	4	ordainments
orpiments	13	4	600	4	orp_i_ments
paraments	13	5	1155	4	__paraments
parents	9	34	1812	4	__pa_r_ents
pavements	16	4	700	4	__pavements
payments	15	3	694	4	__pa_yments
pigments	13	3	734	4	__p_igments
raiments	10	3	990	4	__rai_ments
repairmen	13	4	333	4	repairmen__
repayments	17	4	490	4	repa_yments
repigments	15	4	634	4	rep_igments
sarments	10	3	1196	4	__sa_rments
varments	13	3	906	4	__va_rments

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	83	8.483	17543.2
3	Display Results	83	83	0.046	1804.3
	(SQL Overall)	178691	83	8.952	19961.0