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

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

65 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
preobtained	16	5	276	(None)
reobtained	13	4	339	1	_reobtained
preobtain	13	4	399	2	preobtain__
preobtains	14	4	382	2	preobtain_s
preordained	15	5	282	2	preordained
obtained	11	3	653	3	___obtained
pertained	12	3	850	3	p_e_rtained
preobtaining	17	5	253	3	preobtaining
pretrained	13	5	706	3	pre_trained
reattained	11	4	458	3	_reattained
reobtain	10	4	462	3	_reobtain__
reobtains	11	4	443	3	_reobtain_s
reordained	12	4	344	3	_reordained
retained	9	30	1609	3	_re__tained
appertained	16	5	352	4	appe_rtained
bobtailed	14	4	319	4	__bobtailed
contained	12	3	1089	4	__contained
destained	11	5	825	4	_de_stained
detained	10	31	1164	4	_de__tained
foreordained	17	6	138	4	foreordained
harebrained	17	5	242	4	hare_brained
obtainer	10	4	579	4	___obtainer
preattuned	13	4	281	4	pre_attuned
prebaked	17	3	717	4	pre_b_a_ked
prebind	12	38	1064	4	pre_b__in_d
preboarded	16	6	389	4	pre_boarded
preboiled	14	5	578	4	pre_b_oiled
precleaned	15	4	380	4	preclea_ned
predefined	17	4	427	4	pre_defined
predestined	15	4	518	4	predestined
prenticed	14	11	806	4	pre_nt_iced
preordain	12	12	449	4	preordain__
preordains	13	12	452	4	preordain_s
preowned	14	3	521	4	preo___wned
preplanned	15	4	350	4	pre_planned
preportioned	17	5	425	4	preportioned
prerogatived	19	5	263	4	prerogatived
prestamped	17	4	296	4	pre_stamped
pretaped	13	33	913	4	pre__ta_ped
pretasted	12	14	796	4	pre__tasted
prettied	11	5	925	4	pre__tti_ed
prevailed	15	3	604	4	pre__vailed
prewarned	15	9	477	4	pre__warned
proband	12	27	1024	4	pr_ob_a_n_d
probated	13	4	1086	4	pr_ob_a_ted
probating	14	3	1119	4	pr_obatin_g
probationer	15	6	377	4	pr_obationer
probative	16	4	917	4	pr_obative_
procaine	12	3	1227	4	pr_o_caine_
procaines	13	3	1152	4	pr_o_caines
proclaimed	17	4	325	4	pr_oclaimed
profaned	14	20	797	4	pr_o_fa_ned
propined	13	31	1150	4	pr_o__pined
protamine	13	13	1091	4	pr_o_tamine_
protamines	14	14	980	4	pr_o_tamines
rebaited	11	4	1054	4	_re_b_aited
redbaited	13	4	471	4	_redb_aited
refrained	13	4	722	4	_re_frained
regained	10	21	1124	4	_re__gained
remained	11	24	1289	4	_re__mained
reobtaining	14	4	353	4	_reobtaining
restrained	11	4	841	4	_restrained
retailed	9	41	1396	4	_re__tailed
retainer	8	29	1381	4	_re__tainer
retrained	10	4	1131	4	_re_trained

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.420	425454.8
2	DLD Change Limit	148819	65	9.423	15793.2
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	9.873	18099.0