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

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

60 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
preassigning	16	5	292	(None)
reassigning	13	4	364	1	_reassigning
assigning	11	4	467	3	___assigning
misassigning	16	5	218	3	misassigning
preassign	12	4	457	3	preassig__n_
preassigned	15	5	260	3	preassign_ed
preassigns	13	4	355	3	preassig__ns
preassuring	14	4	382	3	preass_uring
previsioning	18	8	408	3	previsioning
realigning	12	4	593	3	_rea_ligning
redesigning	14	4	365	3	_redesigning
resigning	11	3	946	3	_re__signing
arraigning	12	4	278	4	arra__igning
breadwinning	19	12	119	4	breadwinning
deraigning	13	4	410	4	dera__igning
designing	12	3	662	4	_de__signing
impassioning	17	5	278	4	impassioning
passaging	13	4	561	4	p__assag_ing
pensioning	13	4	591	4	p_e_nsioning
preabsorbing	19	5	197	4	preabsorbing
preachifying	26	5	234	4	preachifying
preadmitting	18	5	276	4	preadmitting
prearranging	16	5	265	4	prearranging
preattuning	14	4	304	4	prea_ttuning
predefining	18	4	416	4	predefi_ning
predesignating	19	6	255	4	predesignating
predestining	16	5	446	4	predestining
presaging	13	3	939	4	pre__sag_ing
prescinding	17	4	485	4	pre_scinding
preshipping	18	5	289	4	pre_shipping
presiding	13	5	1090	4	pre__si_ding
presifting	16	3	808	4	pre__sifting
presignaling	16	5	285	4	pre__signaling
presignify	19	5	243	4	pre__signify
preslicing	15	4	636	4	pre_sli_cing
pressgang	13	4	277	4	pre_ss_g_ang
pressing	11	25	1644	4	pre_ss___ing
pressuring	13	4	651	4	pre_ss_uring
pretensioning	16	6	280	4	pretensioning
pretraining	14	4	650	4	pretrai_ning
previsiting	17	4	554	4	previsi_ting
preweighing	21	4	233	4	pre_weighing
processioning	18	5	374	4	processioning
provisioning	18	8	359	4	provisioning
reasoning	10	3	1020	4	_rea_s_oning
reassailing	12	4	410	4	_reassailing
reasserting	12	4	615	4	_reasserting
reassessing	12	4	399	4	_reassessing
reassign	9	5	542	4	_reassig__n_
reassigned	12	4	360	4	_reassign_ed
reassignment	15	5	267	4	_reassignment
reassigns	10	7	435	4	_reassig__ns
reassorting	12	4	502	4	_reassorting
reassuming	13	4	370	4	_reass_uming
reassuring	11	5	594	4	_reass_uring
reconsigning	16	5	344	4	_reconsigning
refashioning	19	5	217	4	_refashioning
reigning	10	3	988	4	_re___igning
reshining	13	3	1074	4	_re_shi_ning
resining	9	29	1955	4	_re__si_ning

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.390	458182.1
2	DLD Change Limit	124790	60	7.093	17593.4
3	Display Results	60	60	0.046	1304.3
	(SQL Overall)	178691	60	7.529	23733.7