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

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

73 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
appreciating	19	5	410	(None)
appreciation	18	5	530	2	appreciation
appreciations	19	6	477	2	appreciations
appreciative	21	5	396	2	appreciative
depreciating	18	4	504	2	depreciating
abbreviating	20	5	161	3	abbreviating
appreciate	16	5	524	3	appreciat__e
appreciated	18	5	422	3	appreciat_ed
appreciates	17	5	475	3	appreciat_es
appreciator	17	5	414	3	appreciat_or
appreciators	18	5	354	3	appreciators
appreciatory	21	5	322	3	appreciatory
approbating	18	4	458	3	appr_obating
appropriating	17	8	349	3	appropriating
approximating	27	6	180	3	approximating
deprecating	17	7	728	3	deprec_ating
imprecating	18	4	490	3	imprec_ating
speciating	15	4	812	3	_sp_eciating
accrediting	17	5	247	4	accredi_ting
affricating	20	4	396	4	affric_ating
aggregating	13	4	359	4	aggre_gating
alleviating	15	5	361	4	a_lleviating
altercating	14	5	560	4	alterc_ating
annunciating	15	5	237	4	annunciating
appealing	14	4	649	4	app_e__aling
appearing	14	3	689	4	app_e__aring
appeasing	14	4	634	4	app_e__asing
apperceiving	22	5	196	4	apperceiving
appertaining	17	5	251	4	appertaining
appetising	15	4	451	4	app_eti_sing
appetizing	24	4	540	4	app_eti_zing
appointing	15	4	532	4	app__ointing
appraising	15	4	576	4	appr_ai_sing
appreciable	19	5	385	4	apprecia_ble
appreciably	22	5	305	4	apprecia_bly
appreciatively	26	7	231	4	appreciatively
apprehending	21	5	249	4	apprehending
apprenticing	19	6	231	4	apprenticing
apprising	14	4	796	4	appr__i_sing
apprizing	23	4	719	4	appr__i_zing
arpeggiating	17	5	126	4	arpeggiating
asperating	13	4	956	4	asp_e_rating
asphyxiating	28	6	118	4	asphyxiating
associating	14	4	486	4	a_ssociating
brecciating	18	4	423	4	__brecciating
depreciatingly	23	13	138	4	depreciatingly
depreciation	17	4	708	4	depreciation
depreciations	18	4	658	4	depreciations
depreciative	20	8	409	4	depreciative
depredating	16	5	569	4	depre_dating
excruciating	24	5	237	4	excruciating
impregnating	18	5	284	4	impregnating
inappreciative	23	6	170	4	inappreciative
patriating	13	5	1020	4	patr__iating
perennating	14	4	554	4	_perennating
precasting	15	16	983	4	__precasting
precenting	15	10	1215	4	__precenting
precising	14	4	1327	4	__preci_sing
precutting	15	4	642	4	__precutting
predating	13	5	1465	4	__pre_dating
predicating	17	4	965	4	__predicating
predicting	16	4	987	4	__predicting
preheating	16	3	1072	4	__preheating
presifting	16	3	808	4	__presifting
reciting	11	31	1807	4	___reci_ting
recoating	12	13	1746	4	___recoating
recrating	12	13	1879	4	___recrating
spectating	15	4	662	4	_sp_ectating
unappreciation	20	6	196	4	unappreciation
unappreciations	21	8	163	4	unappreciations
unappreciative	23	8	160	4	unappreciative
uppercasing	18	5	276	4	upperc_asing
uppercutting	19	5	153	4	uppercutting

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	73	7.500	16638.7
3	Display Results	73	73	0.046	1587.0
	(SQL Overall)	178691	73	7.936	22516.5