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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

147 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
vacuolation	16	4	440	(None)
vacuolations	17	4	378	1	vacuolations
maculation	14	5	1098	2	macu_lation
vacillation	16	4	532	2	vacillation
acylation	14	4	865	3	_ac_ylation
adulation	10	3	1101	3	_adu_lation
calculation	15	4	829	3	calcu_lation
ejaculation	20	9	613	3	ejacu_lation
evacuation	15	4	716	3	evacu__ation
maculations	15	6	962	3	macu_lations
osculation	12	4	967	3	oscu_lation
peculation	14	3	1199	3	pecu_lation
sacculation	15	4	784	3	sacculation
tabulation	12	4	781	3	tabu_lation
vacation	13	19	1189	3	vac___ation
vaccination	18	4	646	3	vaccination
vacillations	17	4	488	3	vacillations
vacuolate	14	4	522	3	vacuolat__e
vacuolated	16	4	397	3	vacuolat_ed
vallation	12	3	975	3	va__llation
valuation	12	4	997	3	valu__ation
violation	12	3	844	3	v__iolation
ablation	10	3	1243	4	_a__blation
abolition	11	4	705	4	_a_bolition
abrogation	13	10	733	4	_abrogation
absolution	12	4	440	4	_absolution
accumulation	18	15	380	4	accumulation
accusation	14	6	690	4	_accusation
acetylation	16	4	378	4	_acetylation
acidulation	14	10	540	4	_acidulation
activation	15	6	1013	4	_activation
actuation	11	3	1033	4	_ac_tuation
acylations	15	4	760	4	_ac_ylations
adoration	10	3	1131	4	_a_doration
adulations	11	3	1012	4	_adu_lations
advocation	16	4	574	4	_advocation
alation	7	29	2055	4	_a___lation
alkylation	17	4	382	4	_alkylation
allocation	12	4	857	4	_allocation
ambulation	14	4	787	4	_ambulation
angulation	11	4	955	4	_angulation
annotation	10	4	775	4	_annotation
annulation	10	6	895	4	_annulation
arcuation	11	4	1058	4	arcu__ation
arrogation	11	10	744	4	_arrogation
automation	12	4	914	4	_automation
avocation	14	16	899	4	_a_vocation
calculations	16	4	707	4	calcu_lations
cancelation	15	4	777	4	cancelation
cancellation	16	5	501	4	cancellation
carbonation	15	4	585	4	carbonation
caudation	12	6	999	4	ca_u_dation
causation	11	9	952	4	ca_u_sation
chelation	14	3	996	4	__chelation
circulation	15	4	939	4	circu_lation
coagulation	14	4	727	4	coagu_lation
collation	11	3	1399	4	__collation
conation	10	14	2088	4	__c_onation
consolation	13	4	1098	4	consolation
copulation	14	11	1195	4	copu_lation
cumulation	14	4	817	4	__cumulation
decollation	14	4	819	4	decollation
decoration	13	3	1442	4	dec_oration
decussation	14	4	430	4	decussation
desolation	11	3	1140	4	_desolation
ejaculations	21	9	521	4	ejacu_lations
emasculation	16	5	523	4	emascu_lation
emulation	11	3	1239	4	_emu_lation
escalation	12	4	887	4	esc_alation
etiolation	10	4	853	4	_etiolation
evacuations	16	4	630	4	evacu__ations
evaluation	13	5	818	4	evalu__ation
evaporation	16	4	555	4	eva_poration
exculpation	22	4	487	4	exculpation
fecundation	17	4	357	4	fecundation
granulation	12	4	655	4	granu_lation
gratulation	12	4	599	4	gratu_lation
halation	11	3	1385	4	ha___lation
immolation	14	4	610	4	_immolation
incubation	14	4	836	4	incu_bation
inculcation	15	5	724	4	inculcation
inculpation	15	4	677	4	inculpation
incurvation	16	4	698	4	incurvation
inoculation	13	5	871	4	inocu_lation
insolation	10	4	1021	4	_insolation
insulation	10	3	1166	4	insu_lation
isolation	9	3	1164	4	__isolation
jactation	18	3	814	4	jac__tation
jactitation	20	4	562	4	jactitation
jaculating	20	4	730	4	jacu_lating
laceration	12	4	957	4	lac_eration
laciniation	13	4	663	4	laciniation
lacrimation	15	4	626	4	lacrimation
lactation	11	3	1081	4	lac__tation
lallation	9	3	949	4	la__llation
laudation	10	8	813	4	la_u_dation
laureation	10	4	615	4	la_ureation
lobulation	12	4	723	4	lobu_lation
lucubration	15	5	300	4	lucubration
maceration	14	4	961	4	mac_eration
machicolation	22	11	227	4	machicolation
machination	18	10	682	4	machination
maculating	15	4	955	4	macu_lating
maturation	12	4	951	4	matu_ration
modulation	13	14	793	4	modu_lation
morulation	12	14	890	4	moru_lation
nodulation	11	12	799	4	nodu_lation
occultation	15	4	513	4	occultation
occupation	16	4	518	4	occu_pation
oscillation	13	4	550	4	oscillation
osculations	13	4	837	4	oscu_lations
ovulation	12	3	898	4	_ovu_lation
peculations	15	3	1028	4	pecu_lations
percolation	15	4	922	4	percolation
population	14	8	1002	4	popu_lation
quotation	18	14	697	4	__quotation
regulation	11	3	1205	4	regu_lation
sacculations	16	4	666	4	sacculations
salutation	10	4	890	4	salu_tation
saturation	10	4	980	4	satu_ration
scalation	11	3	1107	4	_sc_alation
simulation	12	6	958	4	simu_lation
solation	8	9	1615	4	___solation
speculation	15	4	754	4	specu_lation
spiculation	15	4	703	4	spicu_lation
sublation	11	3	1101	4	__sublation
tabulations	13	4	685	4	tabu_lations
ululation	9	3	809	4	_ulu_lation
undulation	11	4	710	4	undu_lation
vacations	14	19	1055	4	vac___ations
vaccinations	19	4	568	4	vaccinations
vacillating	17	4	462	4	vacillating
vacillator	15	4	350	4	vacillat_or
vacuolar	13	5	348	4	vacuola___r
validation	14	4	841	4	va_lidation
vallations	13	3	909	4	va__llations
valuations	13	4	878	4	valu__ations
variation	12	3	1239	4	va__riation
variegation	15	4	345	4	variegation
variolating	15	4	494	4	variolating
vasodilation	16	5	315	4	vasodilation
ventilation	14	4	816	4	ventilation
vesiculation	17	4	611	4	vesicu_lation
violations	13	3	796	4	v__iolations
vocation	13	23	1198	4	v___ocation
volition	11	7	917	4	v___olition
volution	11	9	860	4	v___olution

Search took 10 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	148819	0.486	367677.0
2	DLD Change Limit	148819	147	8.686	17133.2
3	Display Results	147	147	0.096	1531.3
	(SQL Overall)	178691	147	9.268	19280.4