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

Here are the results of your fuzzy-string dictionary search for “cantillating” 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
cantillating	15	6	504	(None)
cantillation	14	4	669	2	cantillation
cantillations	15	4	573	2	cantillations
scintillating	16	6	219	2	scintillating
antiquating	21	4	643	3	_antiquating
cannulating	14	4	600	3	can_nulating
cantillate	12	4	734	3	cantillat__e
cantillated	14	4	512	3	cantillat_ed
cantillates	13	4	663	3	cantillat_es
canulating	13	4	954	3	can__ulating
capitulating	17	7	396	3	capitulating
captivating	19	4	488	3	capti_vating
castigating	15	4	600	3	casti_gating
conciliating	17	7	561	3	conciliating
constellating	16	5	326	3	constellating
titillating	12	4	370	3	_titillating
vacillating	17	4	461	3	va_cillating
ventilating	15	4	633	3	venti_lating
acetylating	17	5	327	4	acet_ylating
activating	16	4	785	4	_acti_vating
affiliating	18	4	416	4	_affiliating
angulating	12	4	781	4	_an_gulating
animating	12	3	1250	4	_an_i_mating
annihilating	16	5	308	4	_annihilating
antedating	12	7	755	4	_ant_edating
antiaging	11	4	967	4	_anti__aging
anticaking	17	4	760	4	_anti_caking
anticipating	17	5	626	4	_anticipating
anticling	12	3	1069	4	_anticl__ing
anticlotting	15	11	301	4	_anticlotting
antidoting	12	4	716	4	_anti_doting
antifoaming	17	5	411	4	_antifoaming
antihunting	15	7	393	4	_antihunting
antiwhaling	18	5	320	4	_antiwhaling
anvilling	13	3	683	4	_anvill__ing
articulating	15	5	676	4	_articulating
cachinnating	20	9	210	4	cachinnating
calculating	16	6	678	4	ca_lculating
calibrating	16	4	534	4	ca_librating
canalling	12	3	955	4	can_all__ing
cancellation	16	5	501	4	cancellation
cancellations	17	5	439	4	cancellations
cancelling	15	4	721	4	cancell__ing
cantilevering	19	6	142	4	cantilevering
castrating	13	4	977	4	cast__rating
catenating	13	4	868	4	ca_t_enating
cavilling	15	3	638	4	ca_vill__ing
cavitating	16	4	690	4	ca_vi_tating
collating	12	3	1276	4	c___ollating
confiscating	20	5	361	4	confiscating
conflating	16	4	1000	4	con__flating
constipating	17	7	539	4	consti_pating
contemplating	20	5	412	4	contemplating
cultivating	17	4	494	4	culti_vating
etiolating	11	4	697	4	__etiolating
fibrillating	18	5	270	4	fibrillating
gantleting	12	4	391	4	gant__leting
gastrulating	14	8	299	4	gastrulating
intimating	13	4	1082	4	_inti_mating
lancinating	14	4	544	4	lanci_nating
manipulating	17	5	374	4	manipulating
masticating	16	4	783	4	masti_cating
mutilating	13	4	907	4	_muti_lating
oscillating	14	4	397	4	_oscillating
patinating	13	3	987	4	pa_ti_nating
quantitating	22	5	292	4	quanti_tating
sanitating	11	4	964	4	san_i_tating
satiating	10	3	1180	4	sa_ti__ating
scintillation	15	9	300	4	scintillation
scintillations	16	6	275	4	scintillations
tailgating	12	4	490	4	ta__ilgating
variolating	15	4	492	4	va_riolating

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	72	7.906	15784.2
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	8.092	22082.4