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

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

56 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
disportments	17	5	535	(None)
disportment	16	5	665	1	disportment_
deportments	16	5	575	2	d_eportments
assortments	13	5	400	3	_assortments
comportments	20	9	434	3	comportments
departments	16	4	579	3	d_epartments
deportment	15	4	677	3	d_eportment_
despoilments	17	5	340	3	despoilments
disbarments	16	5	493	3	disbar_ments
discernments	17	8	519	3	discernments
discontents	14	4	754	3	discont_ents
dislodgments	17	8	321	3	dislodgments
disorients	11	7	779	3	dis_or_ients
disownments	17	11	490	3	dis_ownments
impartments	17	4	535	3	_impartments
apartments	14	4	570	4	__apartments
assortment	12	5	469	4	_assortment_
compartments	20	9	433	4	compartments
comportment	19	10	546	4	comportment_
department	15	4	681	4	d_epartment_
despisements	17	8	516	4	despisements
despoilment	16	5	368	4	despoilment_
disablements	17	5	491	4	disablements
disagreements	17	6	365	4	disagreements
disappointments	22	11	199	4	disappointments
disarmaments	17	6	394	4	disarmaments
disbandments	18	5	344	4	disbandments
disbarment	15	4	665	4	disbar_ment_
disbursements	18	5	391	4	disbursements
discernment	16	11	612	4	discernment_
discommends	19	6	277	4	disco_mmends
disconcertments	22	8	249	4	disco~~nce~~rtments
discontent	13	4	1025	4	discont_ent_
dislodgements	18	10	345	4	dislodgements
dislodgment	16	9	372	4	dislodgment_
disorient	10	4	1252	4	dis_or_ient_
disownment	16	11	583	4	dis_ownment_
disparagements	20	6	348	4	disparagements
dispersants	14	5	436	4	disper_sants
displacements	20	5	389	4	displacements
disported	13	3	1030	4	disport_e__d
disporting	14	3	982	4	disport_in_g
disports	11	11	1111	4	dispor____ts
disputants	13	4	406	4	disp_ut_ants
dissentients	13	5	422	4	dissentients
dissepiments	17	5	346	4	dissepiments
dissolvents	15	5	311	4	disso_lvents
distorters	11	4	716	4	distort_e_rs
distortions	12	4	661	4	distortion_s
divestments	17	15	516	4	di_vestments
divorcements	20	5	441	4	di_vorcements
impartment	16	4	649	4	_impartment_
impotents	13	4	700	4	_impo_t_ents
misorients	12	5	600	4	mis_or_ients
nilpotents	12	5	273	4	nilpo_t_ents
portents	10	35	1282	4	___port_ents

Search took 7 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	56	6.456	19329.3
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	6.876	25987.6