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

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

146 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
fustigating	16	5	405	(None)
busticating	16	4	530	2	busticating
castigating	15	4	600	2	castigating
festinating	15	4	737	2	festinating
fumigating	17	4	465	2	fu_migating
fustigation	15	4	521	2	fustigation
fustigations	16	4	476	2	fustigations
instigating	13	4	715	2	instigating
rusticating	14	4	631	2	rusticating
aestivating	15	4	580	3	aestivating
auspicating	16	4	460	3	auspicating
cultivating	17	4	494	3	cultivating
estimating	13	4	888	3	_estimating
estivating	14	4	763	3	_estivating
fascinating	17	4	525	3	fascinating
frustrating	15	4	426	3	frust_rating
fulminating	17	4	468	3	fulminating
fustigate	13	4	562	3	fustigat__e
fustigated	15	4	447	3	fustigat_ed
fustigates	14	4	514	3	fustigat_es
litigating	12	4	674	3	_litigating
lustrating	11	4	778	3	lust_rating
masticating	16	4	783	3	masticating
mitigating	14	4	743	3	_mitigating
mutilating	13	4	908	3	mu_tilating
pustulating	14	4	524	3	pustulating
ultimating	13	8	680	3	_ultimating
urticating	13	4	735	3	_urticating
activating	16	4	786	4	_activating
aspirating	13	4	836	4	_aspirating
automating	13	8	930	4	au_tomating
bastinading	15	7	355	4	bastinading
butylating	16	4	458	4	bu_tylating
captivating	19	4	488	4	captivating
castigation	14	4	797	4	castigation
castigations	15	4	720	4	castigations
castrating	13	4	977	4	cast_rating
colligating	15	4	571	4	colligating
constipating	17	7	539	4	constipating
culminating	16	4	573	4	culminating
designating	14	4	607	4	des_ignating
destituting	13	15	516	4	destituting
dissipating	15	5	631	4	dissipating
duplicating	17	4	540	4	duplicating
estating	9	26	1499	4	_est__ating
estreating	11	7	1036	4	_estreating
fabricating	19	4	503	4	fabricating
fatiguing	14	4	305	4	f_atig_uing
fighting	16	27	1008	4	f___ighting
filiating	13	3	925	4	f_ili_ating
filtrating	14	4	597	4	filt_rating
fixating	19	3	618	4	f___ixating
flighting	17	3	610	4	f__lighting
fluctuating	17	5	260	4	fluct_uating
fluoridating	17	5	268	4	fluoridating
fluorinating	16	5	363	4	fluorinating
foliating	13	3	925	4	f_oli_ating
fornicating	17	7	487	4	fornicating
freighting	18	4	454	4	f_reighting
frighting	17	3	602	4	f__righting
fulgurating	16	4	296	4	fulgurating
fumigation	16	4	562	4	fu_migation
fumigations	17	4	492	4	fu_migations
furcating	15	3	778	4	fu__rcating
fusillading	16	9	159	4	fusillading
fustian	10	3	690	4	fusti_a__n_
fustians	11	4	640	4	fusti_a__ns
gestating	11	22	998	4	gest__ating
guesstimating	17	6	168	4	guesstimating
gunfighting	20	5	177	4	gunfighting
hesitating	14	4	800	4	hes_itating
initiating	11	4	962	4	initi_ating
instating	10	8	1221	4	inst__ating
instigation	12	4	924	4	instigation
instigations	13	4	824	4	instigations
instigative	15	5	512	4	instigative
instituting	12	4	480	4	instituting
intimating	13	4	1082	4	_intimating
investigating	18	5	334	4	investigating
irrigating	12	4	595	4	_irrigating
jubilating	20	4	523	4	ju_bilating
justifying	24	4	405	4	justi_fying
levigating	15	4	569	4	_levigating
ligating	10	22	1228	4	___ligating
lubricating	16	4	471	4	lubricating
mislighting	18	4	341	4	mislighting
mistreating	14	4	928	4	mistreating
motivating	16	4	680	4	_motivating
mutating	11	22	1175	4	mu_t__ating
navigating	15	4	500	4	_navigating
nictitating	14	4	438	4	nictitating
nutating	9	24	1195	4	nu_t__ating
obligating	14	4	581	4	_obligating
outdating	11	8	1086	4	ou_t_dating
outeating	10	8	1449	4	ou_t_eating
outfighting	19	4	331	4	outfighting
outgazing	20	3	714	4	ou_t_gazing
outrating	10	9	1640	4	ou_t_rating
outsitting	11	4	713	4	outsi_tting
outskating	15	3	685	4	ou_tskating
outstating	11	3	936	4	ou_tstating
passivating	17	4	378	4	passivating
patinating	13	3	988	4	_patinating
postdating	14	4	716	4	post_dating
postmating	15	4	860	4	post_mating
postulating	14	4	750	4	postulating
quantitating	22	5	292	4	quantitating
reestimating	15	4	593	4	reestimating
resighting	15	4	607	4	res_ighting
resinating	11	3	1373	4	res_inating
resituating	12	4	754	4	resituating
restating	10	23	1941	4	rest__ating
restituting	12	15	656	4	restituting
rubricating	16	4	510	4	rubricating
ruinating	10	3	959	4	ru__inating
ruminating	13	4	814	4	ru_minating
rustication	13	4	922	4	rustication
rustications	14	4	856	4	rustications
satiating	10	3	1181	4	_sati_ating
sighting	13	31	1086	4	__s_ighting
situating	10	3	888	4	__situating
slighting	14	3	637	4	__slighting
stagnating	12	5	497	4	__stagnating
stating	8	37	2516	4	__st__ating
stilting	9	33	1240	4	__sti_lting
stinting	9	34	1574	4	__sti_nting
striating	10	9	1419	4	__striating
subjugating	22	5	291	4	subjugating
sublimating	16	7	546	4	sublimating
subrogating	15	16	498	4	subrogating
substituting	15	5	324	4	substituting
supinating	13	5	783	4	su_pinating
surrogating	13	19	432	4	surrogating
susurrating	12	11	401	4	susurrating
titivating	14	4	532	4	_titivating
tittivating	15	5	259	4	tittivating
unsighting	15	8	444	4	_unsighting
unstating	10	7	1121	4	unst__ating
unstinting	11	4	730	4	unsti_nting
uplighting	17	4	336	4	_uplighting
uprighting	17	4	346	4	_uprighting
uptilting	12	3	471	4	_upti_lting
urinating	10	3	1065	4	_u_rinating
ventilating	15	4	634	4	ventilating
vesicating	16	4	690	4	ves_icating
vitiating	13	3	841	4	_viti_ating

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.420	425454.8
2	DLD Change Limit	148819	146	9.110	16335.8
3	Display Results	146	146	0.080	1825.0
	(SQL Overall)	178691	146	9.610	18594.3