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

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

93 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
bacterially	18	11	496	(None)
arterially	13	4	733	2	_arterially
bacterial	13	4	836	2	bacteria_l_
bacterials	14	4	633	2	bacteria_ls
materially	15	4	800	2	ma_terially
abacterial	14	5	437	3	abacteria_l_
actuarially	16	10	231	3	_actuarially
aerially	11	9	1191	3	_a__erially
bacteria	12	4	898	3	bacteria___
bacterias	13	4	928	3	bacteria__s
bactericidally	24	6	91	3	bactericidally
bacteriology	20	5	288	3	bacteriology
banteringly	17	4	387	3	banteringly
lacteally	14	4	447	3	lacte__ally
laterally	12	4	807	3	la_ter_ally
maternally	15	4	576	3	ma_ternally
paternally	15	4	586	3	pa_ternally
pictorially	18	5	481	3	pictorially
sartorially	14	5	441	3	sartorially
vectorially	19	5	390	3	vectorially
acerbically	20	4	467	4	_ac_erbically
actinally	14	4	823	4	_act_inally
actinically	18	4	708	4	_actinically
actually	13	6	685	4	_act__ually
adverbially	20	5	169	4	_adverbially
alterably	14	4	720	4	_alter_ably
anteriorly	13	5	402	4	_anteriorly
armorially	15	4	492	4	_armorially
arterial	8	3	1363	4	_arteria_l_
arterials	9	4	969	4	_arteria_ls
astrally	11	4	888	4	_ast_r_ally
bactericide	18	5	257	4	bactericide
bacterin	12	4	1027	4	bacteri___n
bacterins	13	4	1064	4	bacteri__ns
bacteriocin	17	6	265	4	bacteriocin
bacterium	15	4	667	4	bacteri__um
bacteriuria	15	5	196	4	bacteriuria
bacterize	22	4	765	4	bacteri__ze
bacterized	24	4	628	4	bacteri_zed
bacterizes	23	4	796	4	bacteri_zes
bacterizing	25	4	610	4	bacterizing
banderilla	13	5	262	4	banderi_lla
baptismally	20	5	99	4	baptismally
barbarically	21	5	309	4	barbarically
bathetically	22	4	735	4	bathetically
bestially	14	4	704	4	best__ially
bilaterally	16	5	307	4	bilater_ally
butterball	14	5	280	4	butterball_
butterballs	15	5	227	4	butterballs
clerically	17	4	819	4	__clerically
doctrinally	17	5	355	4	doct_rinally
editorially	15	5	426	4	editorially
enterally	12	4	1001	4	_enter_ally
esoterically	17	12	612	4	esoterically
eternally	12	4	749	4	__eternally
exoterically	24	13	577	4	exoterically
externally	20	4	554	4	_externally
facially	16	3	764	4	fac___ially
factionally	19	4	639	4	factionally
factorial	14	4	702	4	factoria_l_
factorials	15	4	469	4	factoria_ls
factually	17	4	466	4	fact__ually
falteringly	18	4	314	4	falteringly
fraternally	17	5	349	4	fraternally
hysterically	23	5	489	4	hysterically
imperially	17	4	684	4	_imperially
internally	13	4	1009	4	_internally
literally	12	4	834	4	_liter_ally
magisterially	19	6	165	4	magisterially
managerially	18	5	230	4	managerially
martially	14	4	818	4	mart__ially
masterfully	19	8	271	4	masterfully
material	10	3	1410	4	ma_teria_l_
materiality	16	5	607	4	ma_teriality
materials	11	5	1079	4	ma_teria_ls
naturally	12	4	652	4	na_tur_ally
nocturnally	16	5	242	4	nocturnally
notarially	13	4	468	4	_notarially
partially	14	4	903	4	part__ially
pastorally	15	6	544	4	pastor_ally
racially	13	3	962	4	rac___ially
satirically	16	4	683	4	sa_tirically
serially	11	9	1284	4	___serially
sterically	15	4	1049	4	__sterically
subaerially	16	5	364	4	subaerially
tactically	17	4	975	4	tact_ically
tactually	14	4	500	4	tact__ually
tattersall	10	5	206	4	tattersall_
tattersalls	11	5	193	4	tattersalls
tinctorially	17	5	244	4	tinctorially
waterfall	15	4	458	4	wa_terfall_
waterfalls	16	4	476	4	wa_terfalls
waterily	14	3	878	4	wa_teri__ly

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.170	1051123.5
2	DLD Change Limit	148819	93	9.550	15583.1
3	Display Results	93	93	0.046	2021.7
	(SQL Overall)	178691	93	9.766	18297.3