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

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

100 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
caecally	15	4	770	(None)
cecally	14	5	939	1	c_ecally
caecal	10	37	1373	2	caeca_l_
carnally	13	3	952	2	carnally
casually	13	5	682	2	casually
catcall	11	3	915	2	catcall_
catcalls	12	3	832	2	catcalls
caudally	14	4	646	2	caudally
causally	13	5	661	2	causally
cavally	15	8	848	2	ca_vally
coevally	16	4	628	2	coevally
laically	13	3	898	2	laically
rascally	13	4	773	2	rascally
actually	13	6	685	3	actually
aerially	11	9	1191	3	_aerially
anally	9	5	1350	3	_a_nally
apically	15	3	983	3	apically
areally	10	4	1124	3	_areally
aurally	10	3	1054	3	_aurally
axially	17	3	723	3	_axially
banally	12	4	922	3	ba_nally
basally	12	3	796	3	ba_sally
basically	16	4	803	3	basically
buccally	17	4	462	3	buccally
caeca	9	39	1513	3	caeca___
capably	16	3	925	3	ca_pably
capitally	16	4	666	3	capitally
carefully	17	4	508	3	carefully
cascable	14	15	1062	3	cascable
casualty	13	4	447	3	casualty
catcalled	14	4	489	3	catcalled
catcaller	13	4	481	3	catcaller
catchall	15	4	623	3	catchall_
catchalls	16	4	549	3	catchalls
catchfly	21	4	333	3	catchfly
catfall	12	3	739	3	catfall_
catfalls	13	4	706	3	catfalls
cavalla	12	5	788	3	ca_valla
cavalry	15	5	496	3	ca_valry
cecal	9	46	1911	3	c_eca_l_
chally	14	43	1429	3	c__hally
cheaply	17	3	502	3	che_aply
chemically	22	4	831	3	chemically
chorally	16	3	810	3	chorally
civically	19	4	656	3	civically
cleanly	12	3	632	3	cle_anly
clearly	12	3	666	3	cle_arly
clerically	17	4	819	3	clerically
clinally	13	4	723	3	clinally
clonally	13	4	669	3	clonally
coastally	14	4	650	3	coastally
coaxially	21	14	457	3	coaxially
coequally	23	4	404	3	coequally
coitally	13	3	948	3	coitally
comically	18	3	1052	3	comically
conically	16	3	1281	3	conically
costally	13	3	973	3	costally
cranially	14	4	789	3	cranially
crevalle	13	4	616	3	crevalle
crucially	16	4	544	3	crucially
cubically	18	4	614	3	cubically
cynically	19	4	725	3	cynically
ducally	13	25	741	3	_ducally
epically	15	3	1058	3	epically
facially	16	3	764	3	facially
faecal	11	35	981	3	faeca_l_
fatally	13	3	989	3	fa_tally
faunally	14	4	543	3	faunally
fiscally	16	4	607	3	fiscally
focally	15	18	855	3	_focally
ideally	11	3	779	3	ide_ally
labially	13	3	698	3	labially
laterally	12	4	807	3	laterally
leally	9	40	1261	3	_le_ally
legally	11	3	813	3	_legally
locally	12	17	972	3	_locally
magically	17	4	896	3	magically
manically	16	3	1170	3	manically
manually	13	4	704	3	manually
mesally	12	11	979	3	_mesally
nasally	10	5	744	3	na_sally
navally	13	6	647	3	na_vally
panically	16	3	1043	3	panically
papally	14	3	797	3	pa_pally
penally	12	11	1177	3	_penally
racially	13	3	962	3	racially
radially	12	3	978	3	radially
radically	15	3	1042	3	radically
really	9	33	1561	3	_re_ally
recall	8	38	1573	3	_recall_
recalls	9	26	1362	3	_recalls
rectally	13	3	971	3	_rectally
regally	11	5	987	3	_regally
retally	10	4	1368	3	_retally
specially	16	4	734	3	specially
tarnally	11	3	827	3	tarnally
trevally	14	4	634	3	trevally
vagally	14	3	583	3	va_gally
venally	13	11	956	3	_venally
vocally	15	18	834	3	_vocally

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	146162	0.420	425454.8
2	DLD Change Limit	146162	100	7.516	19446.8
3	Display Results	100	100	0.046	2173.9
	(SQL Overall)	178691	100	7.982	22386.7