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

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

75 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
fluctuating	17	5	260	(None)
fluctuation	16	5	307	2	fluctuation
fluctuations	17	5	256	2	fluctuations
actuating	12	3	923	3	__actuating
effectuating	21	5	178	3	effectuating
elucidating	15	4	369	3	elucidating
eructating	13	4	569	3	eruct_ating
flocculating	20	5	235	3	flocculating
fluctuant	14	5	228	3	fluctua__nt
fluctuate	14	4	311	3	fluctuat__e
fluctuated	16	4	249	3	fluctuat_ed
fluctuates	15	4	307	3	fluctuat_es
fluctuational	18	6	123	3	fluctuational
frustrating	15	4	426	3	frustrating
lactating	12	3	919	3	_lact_ating
lustrating	11	4	778	3	_lustrating
punctuating	16	4	310	3	punctuating
reluctating	14	4	576	3	reluct_ating
delectating	15	4	599	4	delect_ating
dictating	13	3	888	4	_dict_ating
educating	13	3	793	4	educ__ating
elucubrating	17	5	187	4	elucubrating
elutriating	12	4	507	4	elutriating
eluviating	14	4	489	4	elu_viating
enucleating	14	4	455	4	enucleating
evacuating	16	4	568	4	evac_uating
eventuating	15	4	325	4	eventuating
fascinating	17	4	525	4	fascinating
fecundating	18	5	238	4	fecundating
felicitating	18	5	332	4	felicitating
filtrating	14	4	597	4	f_iltrating
flatting	12	35	1125	4	fl_at__ting
flaunting	13	3	504	4	fl__aunting
flitting	12	30	1088	4	fl_it__ting
floating	12	31	1188	4	fl___oating
flouting	12	26	1047	4	fl__ou_ting
fluoridating	17	5	268	4	fluoridating
fluorinating	16	5	363	4	fluorinating
flustering	14	10	593	4	flust_ering
fluting	11	38	1509	4	fl___u_ting
fluttering	14	10	629	4	flu_ttering
fracturing	16	4	393	4	fractu_ring
fructifying	23	5	237	4	fructifying
fulgurating	16	4	296	4	fulgurating
fulminating	17	4	468	4	fulminating
fumigating	17	4	465	4	f_umigating
furcating	15	3	778	4	f_u_rcating
fustigating	16	5	405	4	f_ustigating
glaciating	14	4	560	4	glac_iating
glutting	10	24	764	4	glu_t__ting
habituating	17	4	323	4	habituating
illustrating	13	7	272	4	illustrating
infatuating	15	4	358	4	infatuating
lacerating	13	4	945	4	_lacerating
lecturing	12	3	730	4	_lectu_ring
liquating	19	4	631	4	_l_iquating
locating	11	3	1150	4	_loc__ating
lucubrating	16	5	278	4	_lucubrating
luxating	16	4	561	4	_lu__xating
micturating	16	4	488	4	_micturating
mutating	11	22	1175	4	_mu_t_ating
nictating	12	3	757	4	_nict_ating
nucleating	13	4	694	4	_nucleating
nutating	9	24	1195	4	_nu_t_ating
outdating	11	8	1086	4	_ou_tdating
outeating	10	8	1449	4	_ou_teating
outrating	10	9	1640	4	_ou_trating
placating	14	3	851	4	plac__ating
pustulating	14	4	524	4	_pustulating
resituating	12	4	754	4	resituating
situating	10	3	888	4	__situating
spectating	15	4	662	4	spect_ating
ulcerating	13	4	698	4	ul_cerating
ululating	10	3	664	4	ulu__lating
victualing	16	4	340	4	_victualing

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.466	383457.1
2	DLD Change Limit	148819	75	8.453	17605.5
3	Display Results	75	75	0.050	1500.0
	(SQL Overall)	178691	75	8.969	19923.2