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

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

68 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
appreciation	18	5	528	(None)
appreciations	19	6	473	1	appreciations
appreciating	19	5	408	2	appreciating
appreciative	21	5	394	2	appreciative
appreciator	17	5	411	2	appreciat_or
depreciation	17	4	707	2	depreciation
unappreciation	20	6	196	2	unappreciation
abbreviation	19	117	526	3	abbreviation
appellation	15	6	412	3	app_ellation
apperception	17	9	345	3	apperception
application	17	4	747	3	applic_ation
appreciate	16	5	522	3	appreciat__e
appreciated	18	5	420	3	appreciat_ed
appreciates	17	5	472	3	appreciat_es
appreciators	18	5	351	3	appreciators
appreciatory	21	5	319	3	appreciatory
approbation	17	5	502	3	appr_obation
appropriation	16	5	382	3	appropriation
approximation	26	5	223	3	approximation
deprecation	16	4	895	3	deprec_ation
depreciations	18	4	654	3	depreciations
imprecation	17	4	654	3	imprec_ation
speciation	14	4	939	3	_sp_eciation
unappreciations	21	8	162	3	unappreciations
abbreviations	20	214	502	4	abbreviations
accreditation	18	11	287	4	accreditation
affectation	19	4	384	4	a_ffectation
aggregation	14	5	425	4	aggre_gation
alleviation	14	5	465	4	a_lleviation
altercation	13	4	701	4	alterc_ation
annunciation	14	6	289	4	annunciation
apparition	14	4	458	4	app_ari_tion
appellations	16	4	353	4	app_ellations
apperceptions	18	9	301	4	apperceptions
applications	18	4	677	4	applic_ations
apposition	14	4	658	4	app_osi_tion
appreciable	19	5	384	4	apprecia_ble
appreciably	22	5	304	4	apprecia_bly
appreciatively	26	7	230	4	appreciatively
apprehension	19	9	264	4	apprehension
approbations	18	5	424	4	appr_obations
appropriations	17	6	317	4	appropriations
approximations	27	6	196	4	approximations
arcuation	11	4	1058	4	a__r_cuation
asphyxiation	27	6	138	4	asphyxiation
association	13	4	615	4	a_ssociation
brecciation	17	4	477	4	__brecciation
deprecations	17	4	853	4	deprec_ations
depreciating	18	4	503	4	depreciating
depreciative	20	8	408	4	depreciative
depreciator	16	5	426	4	depreciat_or
depredation	15	4	691	4	depre_dation
excruciation	23	12	330	4	excruciation
expectation	22	6	648	4	exp_ectation
imprecations	18	4	624	4	imprec_ations
imprecision	17	5	390	4	impreci_sion
impregnation	17	5	401	4	impregnation
inappreciative	23	6	170	4	inappreciative
perennation	13	4	808	4	_perennation
precaution	14	4	723	4	__precaution
precision	13	4	1005	4	__preci_sion
predation	12	3	1346	4	__pre_dation
predication	16	4	1243	4	__predication
prediction	15	4	1030	4	__prediction
prelibation	15	12	866	4	__prelibation
recitation	12	3	1594	4	___recitation
speciations	15	4	847	4	_sp_eciations
unappreciative	23	8	160	4	unappreciative

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.140	1276364.3
2	DLD Change Limit	124790	68	8.736	14284.6
3	Display Results	68	68	0.030	2266.7
	(SQL Overall)	178691	68	8.906	20064.1