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

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

51 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
preobtaining	17	5	253	(None)
reobtaining	14	4	353	1	_reobtaining
preordaining	16	5	251	2	preordaining
obtaining	12	3	677	3	___obtaining
pertaining	13	4	799	3	p_e_rtaining
preobtain	13	4	399	3	preobta__in_
preobtained	16	5	276	3	preobtain_ed
preobtains	14	4	382	3	preobta__ins
pretraining	14	4	650	3	pre_training
reattaining	12	4	459	3	_reattaining
reordaining	13	4	345	3	_reordaining
retaining	10	21	1473	3	_re__taining
appertaining	17	5	251	4	appe_rtaining
bobtailing	15	4	351	4	__bobtailing
containing	13	4	1093	4	__containing
destaining	12	6	794	4	_de_staining
detaining	11	25	1047	4	_de__taining
foreordaining	18	6	107	4	foreordaining
preattuning	14	4	304	4	pre_attuning
prebaking	18	3	806	4	pre_b_a_king
prebinding	16	9	616	4	pre_b__inding
preboarding	17	4	427	4	pre_boarding
preboiling	15	4	640	4	pre_b_oiling
precleaning	16	4	426	4	preclea_ning
predefining	18	4	416	4	pre_defining
predestining	16	5	446	4	predestining
prenticing	15	4	788	4	pre_nt_icing
preopening	15	4	624	4	preo__pening
preplanning	16	4	369	4	pre_planning
preportioning	18	5	360	4	preportioning
prestamping	18	6	365	4	pre_stamping
pretaping	14	3	913	4	pre__ta_ping
pretasting	13	23	928	4	pre__tasting
prevailing	16	5	672	4	pre__vailing
prewarning	16	13	519	4	pre__warning
preweaning	16	4	563	4	pre_wea_ning
probating	14	3	1119	4	pr_ob_a_ting
proclaiming	18	4	387	4	pr_oclaiming
profaning	15	3	729	4	pr_o_fa_ning
propining	14	3	1013	4	pr_o__pining
rebaiting	12	3	1164	4	_re_b_aiting
redbaiting	14	4	626	4	_redb_aiting
refraining	14	3	726	4	_re_fraining
regaining	11	24	1108	4	_re__gaining
remaining	12	22	1279	4	_re__maining
reobtain	10	4	462	4	_reobta__in_
reobtained	13	4	339	4	_reobtain_ed
reobtains	11	4	443	4	_reobta__ins
restraining	12	4	753	4	_restraining
retailing	10	32	1473	4	_re__tailing
retraining	11	3	1024	4	_re_training

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	124790	0.373	479064.3
2	DLD Change Limit	124790	51	7.813	15972.1
3	Display Results	51	51	0.033	1545.5
	(SQL Overall)	178691	51	8.219	21741.2