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

Here are the results of your fuzzy-string dictionary search for “compartments” 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
compartments	20	9	433	(None)
compartment	19	9	508	1	compartment_
comportments	20	9	434	1	comportments
compartmental	21	6	248	2	compartmental
compartmented	22	6	186	2	compartmented
comportment	19	10	546	2	comportment_
impartments	17	4	535	2	_impartments
apartments	14	4	570	3	__apartments
bombardments	21	5	171	3	bombardments
commandments	18	5	295	3	commandments
commitments	16	5	386	3	com_mitments
compartmenting	23	6	168	3	compartmenting
complements	19	4	818	3	comp_lements
compliments	19	4	658	3	comp_liments
coparents	13	4	797	3	co_par__ents
copayments	19	4	431	3	co_pa_yments
departments	16	4	579	3	_departments
impartment	16	4	649	3	_impartment_
accompaniments	24	6	145	4	accompaniments
apartment	13	4	703	4	__apartment_
bombardment	20	6	237	4	bombardment_
comanagements	20	6	273	4	comanagements
combatants	16	5	344	4	comba_t_ants
commandment	17	5	382	4	commandment_
comments	14	29	1388	4	com____ments
commitment	15	5	517	4	com_mitment_
compacters	18	24	702	4	compact_e_rs
compactest	18	4	504	4	compact_est_
compactions	19	4	654	4	compaction_s
compactness	19	5	330	4	compactne_ss
comparatists	18	5	373	4	comparatists
comparers	15	31	939	4	compar__e_rs
compares	14	38	1643	4	compar__e__s
comparisons	17	5	397	4	comparison_s
comparted	16	33	842	4	compart_e__d
comparting	17	18	838	4	compart_in_g
comparts	14	42	1083	4	compar____ts
compatriots	17	5	354	4	compa_triots
competent	15	4	1125	4	comp_et_ent_
complement	18	5	1010	4	comp_lement_
compliment	18	4	840	4	comp_liment_
components	16	4	694	4	comp__onents
comprehends	21	10	321	4	comp_rehends
concernments	18	6	524	4	concernments
conferments	18	4	832	4	confer_ments
containments	16	5	578	4	containments
contentments	16	5	548	4	contentments
coparent	12	4	1225	4	co_par__ent_
copartners	14	4	357	4	co_partne_rs
copayment	18	4	589	4	co_pa_yment_
copresents	14	4	645	4	co_p_resents
couplements	17	5	619	4	coup_lements
department	15	4	681	4	_department_
deportments	16	5	575	4	_deportments
disportments	17	5	535	4	disportments
embarkments	21	6	400	4	_embarkments
encompassments	22	6	157	4	encompassments
godparents	14	5	197	4	godpar__ents
impairments	17	5	387	4	_impairments
impalements	17	4	643	4	_impalements
nonparents	12	4	607	4	nonpar__ents
nonpayments	18	5	415	4	nonpa_yments
paraments	13	5	1155	4	___paraments
temperaments	18	5	366	4	temperaments

Search took 8 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.453	394461.4
2	DLD Change Limit	124790	64	6.640	18793.7
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	7.126	25075.9