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

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

72 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
preassigned	15	5	260	(None)
reassigned	12	4	360	1	_reassigned
preassign	12	4	457	2	preassign__
preassigns	13	4	355	2	preassign_s
assigned	10	4	463	3	___assigned
misassigned	15	5	203	3	misassigned
preassigning	16	5	292	3	preassigning
preassured	13	4	453	3	preass_ured
previsioned	17	4	426	3	previsioned
realigned	11	4	533	3	_rea_ligned
reassign	9	5	542	3	_reassign__
reassigns	10	7	435	3	_reassign_s
redesigned	13	4	337	3	_redesigned
resigned	10	3	886	3	_re__signed
unassigned	12	6	247	3	_unassigned
arraigned	11	10	303	4	arra__igned
assignee	9	4	484	4	___assignee
assigner	9	4	485	4	___assigner
deraigned	12	4	409	4	dera__igned
designed	11	3	694	4	_de__signed
impassioned	16	5	293	4	impassioned
passaged	12	3	624	4	p__assag_ed
pensioned	12	4	665	4	p_e_nsioned
preabsorbed	18	5	199	4	preabsorbed
preachified	22	7	309	4	preachified
preadmitted	17	5	280	4	preadmitted
preaged	11	6	1233	4	prea___g_ed
prearranged	15	5	270	4	prearranged
preassembled	19	5	182	4	preassembled
preassure	11	4	562	4	preass_ure_
preassures	12	4	527	4	preass_ures
preattuned	13	4	281	4	prea_ttuned
predefined	17	4	427	4	predefi_ned
predesignated	18	5	231	4	predesignated
predestined	15	4	518	4	predestined
presaged	12	3	880	4	pre__sag_ed
prescind	13	3	839	4	pre_sci_n_d
prescinded	16	4	434	4	pre_scinded
preshipped	17	4	296	4	pre_shipped
presided	12	4	1055	4	pre__si_ded
presifted	15	3	687	4	pre__sifted
presignal	12	10	555	4	pre__signal
presignaled	15	5	238	4	pre__signaled
presliced	14	3	598	4	pre_sli_ced
pressed	10	33	1731	4	pre_ss___ed
pressing	11	25	1644	4	pre_ssi_n_g
pressingly	16	4	600	4	pre_ssingly
pressings	12	26	902	4	pre_ssi_ngs
pressured	12	3	733	4	pre_ss_ured
prestige	11	3	1073	4	pre_stig_e_
prestiges	12	3	1059	4	pre_stig_es
pretensioned	15	5	359	4	pretensioned
pretrained	13	5	706	4	pretrai_ned
previsited	16	4	518	4	previsi_ted
preweighed	20	4	221	4	pre_weighed
processioned	17	5	397	4	processioned
provisioned	17	5	397	4	provisioned
reasoned	9	4	1073	4	_rea_s_oned
reassailed	11	4	333	4	_reassailed
reasserted	11	4	541	4	_reasserted
reassessed	11	4	376	4	_reassessed
reassigning	13	4	364	4	_reassigning
reassignment	15	5	267	4	_reassignment
reassorted	11	4	436	4	_reassorted
reassumed	12	4	379	4	_reass_umed
reassured	10	4	610	4	_reass_ured
reconsigned	15	5	350	4	_reconsigned
refashioned	18	5	170	4	_refashioned
reigned	9	4	921	4	_re___igned
reshined	12	30	1112	4	_re_shi_ned
resigner	9	3	779	4	_re__signer
resined	8	45	2265	4	_re__si_ned

Search took 10 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	72	8.766	16976.8
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	9.219	19382.9