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

Here are the results of your fuzzy-string dictionary search for “estivation” with Change Limit: [1] [2] [3] [4]

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.

82 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
estivation	13	4	981	(None)
aestivation	14	4	792	1	aestivation
estimation	12	4	1084	1	estimation
estivations	14	4	927	1	estivations
activation	15	6	1013	2	activation
aestivations	15	4	748	2	aestivations
destination	12	4	1384	2	destination
estimations	13	4	994	2	estimations
estivating	14	4	763	2	estivating
estivator	12	4	629	2	estivat_or
motivation	15	4	808	2	motivation
titivation	13	4	703	2	titivation
activations	16	6	926	3	activations
aestivating	15	4	580	3	aestivating
aspiration	12	4	999	3	aspiration
captivation	18	4	617	3	captivation
castigation	14	4	797	3	castigation
cultivation	16	11	641	3	cultivation
deactivation	18	15	608	3	deactivation
deprivation	17	8	877	3	deprivation
derivation	14	7	1278	3	derivation
destinations	13	4	1266	3	destinations
destitution	12	5	554	3	destitution
elevation	12	3	923	3	e_levation
eluviation	13	7	661	3	eluviation
enervation	13	6	947	3	enervation
epilation	11	3	1296	3	e_pilation
equitation	19	4	834	3	equitation
erotization	20	4	1206	3	erotization
escalation	12	4	887	3	escalation
estimating	13	4	888	3	estimating
estimative	15	4	648	3	estimative
estimator	11	4	742	3	estimat_or
estivate	11	10	1000	3	estivat__e
estivated	13	10	832	3	estivat_ed
estivates	12	10	975	3	estivat_es
estivators	13	4	592	3	estivators
etiolation	10	4	853	3	e_tiolation
excavation	22	4	543	3	excavation
excitation	19	4	1017	3	excitation
expiation	18	7	1042	3	expi_ation
expiration	19	6	1071	3	expiration
extinction	19	4	477	3	extinction
extirpation	20	8	492	3	extirpation
extrication	20	4	979	3	extrication
exuviation	20	11	634	3	exuviation
fustigation	15	4	521	3	fustigation
gestation	10	3	1066	3	gest__ation
hesitation	13	4	963	3	hes_itation
instigation	12	4	924	3	instigation
intimation	12	4	1304	3	intimation
litigation	11	4	817	3	litigation
mastication	15	6	1029	3	mastication
mitigation	13	4	864	3	mitigation
motivations	16	4	709	3	motivations
mutilation	12	4	975	3	mutilation
passivation	16	10	474	3	passivation
patination	12	3	1257	3	patination
pectination	15	4	1033	3	pectination
privation	14	3	1117	3	_privation
reactivation	17	17	695	3	reactivation
remotivation	17	4	743	3	remotivation
reservation	14	8	914	3	reservation
respiration	13	5	1119	3	respiration
restation	9	3	1691	3	rest__ation
restitution	11	7	597	3	restitution
restoration	11	4	1209	3	restoration
rustication	13	4	922	3	rustication
salivation	13	4	981	3	salivation
salvation	12	3	929	3	_salvation
satiation	9	3	1343	3	sati_ation
seriation	9	3	1806	3	seri_ation
situation	9	4	942	3	_situation
solvation	12	3	777	3	_solvation
starvation	13	4	549	3	_starvation
station	7	27	1724	3	_st__ation
stiction	10	3	882	3	_sti_ction
striation	9	3	1348	3	_striation
titivations	14	4	626	3	titivations
urtication	12	4	911	3	urtication
ventilation	14	4	816	3	ventilation
vitiation	12	3	956	3	viti_ation

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	140603	0.406	440125.6
2	DLD Change Limit	140603	82	6.626	21219.9
3	Display Results	82	82	0.046	1782.6
	(SQL Overall)	178691	82	7.078	25246.0