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

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

62 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
assignments	14	5	332	(None)
assignment	13	5	389	1	assignment_
alignments	13	4	463	2	a_lignments
designments	15	4	512	2	designments
reassignments	16	6	211	2	reassignments
alignment	12	4	637	3	a_lignment_
arraignments	15	5	316	3	arraignments
assessments	12	5	293	3	assessments
assignats	10	4	400	3	assign__ats
assignees	10	4	350	3	assign_e_es
assigners	10	4	441	3	assign_e_rs
assoilments	13	5	361	3	assoilments
assortments	13	5	400	3	assortments
assuagements	15	5	297	3	assuagements
consignments	17	5	393	3	consignments
designment	14	4	605	3	designment_
reassignment	15	5	267	3	reassignment_
abridgements	18	5	304	4	abridgements
abridgments	17	5	293	4	abridgments
adornments	13	4	516	4	a_dornments
advisements	17	5	482	4	advisements
affixments	25	4	307	4	affi_xments
ailments	10	3	943	4	a__i_lments
alightments	17	9	276	4	a_lightments
aliments	10	3	1109	4	a_li__ments
alinements	12	4	713	4	a_linements
anointments	13	5	543	4	anointments
arguments	12	5	657	4	a__rguments
arraignment	14	5	361	4	arraignment_
ascendents	13	4	424	4	a_scendents
assents	7	45	1222	4	ass____ents
assessment	12	5	361	4	assessment_
assignat	9	4	568	4	assign__at_
assigned	10	4	463	4	assign_e__d
assignee	9	4	484	4	assign_e__e
assigner	9	4	485	4	assign_e__r
assigning	11	4	467	4	assign_in_g
assignors	10	4	324	4	assign__ors
assigns	8	3	619	4	assig___n_s
assistants	10	5	344	4	assi_stants
assoilment	12	5	409	4	assoilment_
assonants	9	4	424	4	ass_on_ants
assortment	12	5	469	4	assortment_
assuagement	14	6	349	4	assuagement_
astringents	12	5	391	4	astringents
attainments	13	5	394	4	attainments
attornments	13	5	395	4	attornments
augments	11	3	783	4	a__ug_ments
bassinets	11	4	632	4	bassi_n_e_ts
consignment	16	5	461	4	consignment_
disownments	17	11	490	4	disownments
eloinments	12	4	599	4	eloi_nments
figments	14	4	694	4	__fig_ments
ligaments	12	4	620	4	__ligaments
misalignments	18	6	217	4	misalignments
pigments	13	3	734	4	__pig_ments
realignments	15	5	329	4	realignments
repigments	15	4	634	4	repig_ments
segments	11	3	890	4	__seg_ments
shipments	16	25	470	4	_shi_pments
signalments	14	7	226	4	__signalments
signets	8	33	1150	4	__sign_e_ts

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.470	380193.6
2	DLD Change Limit	148819	62	8.373	17773.7
3	Display Results	62	62	0.033	1878.8
	(SQL Overall)	178691	62	8.876	20131.9