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

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

160 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
fustigation	15	4	521	(None)
fustigations	16	4	476	1	fustigations
castigation	14	4	797	2	castigation
fumigation	16	4	562	2	fu_migation
fustigating	16	5	405	2	fustigating
instigation	12	4	924	2	instigation
rustication	13	4	922	2	rustication
aestivation	14	4	792	3	aestivation
castigations	15	4	720	3	castigations
cultivation	16	11	641	3	cultivation
cuspidation	16	4	349	3	cuspidation
destination	12	4	1384	3	destination
estimation	12	4	1084	3	_estimation
estivation	13	4	981	3	_estivation
fasciation	15	4	683	3	fasci_ation
fascination	16	4	679	3	fascination
frustration	14	4	481	3	frust_ration
fulmination	16	5	588	3	fulmination
fumigations	17	4	492	3	fu_migations
fustigate	13	4	562	3	fustigat__e
fustigated	15	4	447	3	fustigat_ed
fustigates	14	4	514	3	fustigat_es
gustation	10	4	796	3	gust__ation
instigations	13	4	824	3	instigations
litigation	11	4	817	3	_litigation
lustration	10	4	835	3	lust_ration
mastication	15	6	1029	3	mastication
mitigation	13	4	864	3	_mitigation
multination	13	4	897	3	multination
mutilation	12	4	975	3	mu_tilation
pustulation	13	11	662	3	pustulation
rustications	14	4	856	3	rustications
suspiration	13	4	654	3	suspiration
urtication	12	4	911	3	_urtication
activation	15	6	1013	4	_activation
aestivations	15	4	748	4	aestivations
aspiration	12	4	999	4	_aspiration
assignation	12	4	437	4	_assignation
automation	12	4	914	4	au_tomation
busticating	16	4	530	4	busticating
butylation	15	4	372	4	bu_tylation
captivation	18	4	617	4	captivation
castigating	15	4	600	4	castigating
castigator	13	4	576	4	castigat_or
castration	12	4	1080	4	cast_ration
colligation	14	5	744	4	colligation
constipation	16	4	856	4	constipation
culmination	15	5	764	4	culmination
cultivations	17	4	559	4	cultivations
cuspidations	17	4	334	4	cuspidations
designation	13	4	748	4	des_ignation
destinations	13	4	1266	4	destinations
destitution	12	5	554	4	destitution
dissipation	14	4	721	4	dissipation
distillation	13	4	773	4	distillation
distinction	14	4	732	4	distinction
dubitation	13	7	733	4	du_bitation
duplication	16	4	729	4	duplication
erotization	20	4	1206	4	erotization
estimations	13	4	994	4	_estimations
estivations	14	4	927	4	_estivations
fabrication	18	4	660	4	fabrication
fasciations	16	4	626	4	fasci_ations
fascinations	17	4	637	4	fascinations
festinating	15	4	737	4	festinating
fetation	11	6	1314	4	f_et__ation
filiation	12	11	1024	4	f_ili_ation
filtration	13	4	643	4	filt_ration
fixation	18	3	707	4	f___ixation
floriation	13	6	779	4	flori_ation
flotation	12	6	781	4	flot__ation
fluctuation	16	5	307	4	fluct_uation
fluidization	25	5	360	4	fluidization
fluoridation	16	7	363	4	fluoridation
fluorination	15	9	471	4	fluorination
foliation	12	11	1079	4	f_oli_ation
fornication	16	4	595	4	fornication
frustrations	15	4	453	4	frust_rations
fulguration	15	12	333	4	fulguration
fulminations	17	4	503	4	fulminations
fumigating	17	4	465	4	fu_migating
fumigator	15	4	392	4	fu_migat_or
furcation	14	4	835	4	fu__rcation
fustian	10	3	690	4	fusti_a___n
gestation	10	3	1066	4	gest__ation
gustations	11	4	723	4	gust__ations
guttation	10	4	617	4	gu_t_tation
hesitation	13	4	963	4	hes_itation
initiation	10	4	1210	4	initi_ation
inspiration	13	4	837	4	inspiration
instigating	13	4	715	4	instigating
instigative	15	5	512	4	instigative
instigator	11	4	641	4	instigat_or
instillation	12	4	584	4	instillation
institution	11	4	529	4	institution
intimation	12	4	1304	4	_intimation
investigation	17	5	408	4	investigation
irrigation	11	4	780	4	_irrigation
jactitation	20	4	562	4	jactitation
jubilation	19	4	605	4	ju_bilation
justification	25	4	609	4	justification
levigation	14	4	702	4	_levigation
ligation	9	23	1309	4	___ligation
litigations	12	4	733	4	_litigations
lubrication	15	4	634	4	lubrication
lustrations	11	4	762	4	lust_rations
mastications	16	4	941	4	mastications
miscitation	15	4	777	4	miscitation
mitigations	14	4	762	4	_mitigations
motivation	15	4	808	4	_motivation
mutation	10	14	1288	4	mu_t__ation
mutilations	13	4	864	4	mu_tilations
navigation	14	4	600	4	_navigation
nutation	8	15	1310	4	nu_t__ation
obligation	13	4	678	4	_obligation
outstation	10	4	616	4	ou_tstation
passivation	16	10	474	4	passivation
patination	12	3	1257	4	_patination
pectination	15	4	1033	4	pectination
postulation	13	11	913	4	postulation
publication	17	4	657	4	publication
purgation	12	4	739	4	pu__rgation
pustulations	14	11	562	4	pustulations
quantitation	21	5	364	4	quantitation
quantization	30	5	504	4	quantization
quotation	18	14	697	4	quot__ation
resignation	12	4	747	4	res_ignation
respiration	13	5	1119	4	respiration
restation	9	3	1691	4	rest__ation
restitution	11	7	597	4	restitution
restoration	11	4	1209	4	restoration
rubrication	15	4	712	4	rubrication
ruination	9	3	1127	4	ru__ination
rumination	12	4	1083	4	ru_mination
rusticating	14	4	631	4	rusticating
rusticator	12	4	532	4	rusticat_or
satiation	9	3	1343	4	_sati_ation
situation	9	4	942	4	__situation
stagnation	11	4	554	4	__stagnation
station	7	27	1724	4	__st__ation
stiction	10	3	882	4	__sti_ction
striation	9	3	1348	4	__striation
subjugation	21	4	370	4	subjugation
sublimation	15	5	718	4	sublimation
subrogation	14	4	600	4	subrogation
substation	12	4	899	4	subst__ation
substitution	14	5	332	4	substitution
suffixation	24	5	286	4	suffixation
supination	12	4	988	4	su_pination
suspirations	14	4	585	4	suspirations
sustentation	12	5	502	4	sustentation
susurration	11	4	479	4	susurration
titivation	13	4	703	4	_titivation
unitization	20	4	813	4	unitization
urination	9	3	1217	4	_u_rination
urtications	13	4	803	4	_urtications
usurpation	12	4	381	4	_usurpation
ventilation	14	4	816	4	ventilation
visitation	13	4	859	4	vis_itation
vitiation	12	3	956	4	_viti_ation

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	148819	0.406	440125.6
2	DLD Change Limit	148819	160	8.360	17801.3
3	Display Results	160	160	0.080	2000.0
	(SQL Overall)	178691	160	8.846	20200.2