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

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

74 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
bacterias	13	4	928	(None)
bacteria	12	4	898	1	bacteria_
bacterial	13	4	835	1	bacterial
bacterials	14	4	633	1	bacterials
bacterins	13	4	1064	1	bacterins
abacterial	14	5	436	2	abacterial
asterias	8	3	1700	2	_asterias
bacteremias	17	7	218	2	bacteremias
bacterin	12	4	1027	2	bacteri_n
bacterium	15	4	667	2	bacterium
bacterize	22	4	765	2	bacterize
bacterizes	23	4	796	2	bacterizes
bacteroids	15	4	519	2	bacteroids
batteries	11	6	1511	2	batteries
hatterias	12	5	874	2	hatterias
santerias	9	3	1183	2	santerias
acedias	10	3	977	3	_ac_edias
actinias	10	18	1084	3	_actinias
apteria	9	3	1291	3	_apteria_
arterial	8	3	1362	3	_arterial
arterials	9	4	969	3	_arterials
arteries	8	3	2148	3	_arteries
asteria	7	3	1617	3	_asteria_
babesias	12	4	611	3	ba_besias
baccaras	14	4	691	3	baccar_as
backers	15	38	2188	3	backer__s
bacteremia	16	10	228	3	bacteremia_
bacterially	18	11	496	3	bacterially
bacteriurias	16	6	191	3	bacte~~riu~~rias
bacterized	24	4	628	3	bacterized
bacteroid	14	5	624	3	bacteroid
baiters	9	46	1930	3	baiter__s
bakeries	14	3	1219	3	ba_keries
ballerinas	12	4	459	3	ballerinas
banterers	11	24	1000	3	banterers
bantering	12	24	1423	3	bantering
banters	9	46	2311	3	banter__s
baptisias	13	4	430	3	baptisias
barterers	11	26	963	3	barterers
bartering	12	23	1364	3	bartering
barters	9	42	2303	3	barter__s
basters	9	49	3030	3	baster__s
battalias	11	4	480	3	battalias
batterers	11	31	1071	3	batterers
batterie	10	7	1153	3	batteri_e
battering	12	27	1514	3	battering
batters	9	46	2601	3	batter__s
booteries	11	3	1277	3	booteries
butteries	11	7	1176	3	butteries
cachexias	23	6	338	3	cachexias
cafeterias	15	5	377	3	cafeterias
catteries	11	8	1552	3	catteries
cauteries	11	6	1539	3	cauteries
cerias	8	33	2198	3	__c_erias
eateries	8	3	2431	3	ea_teries
factorial	14	4	702	3	factorial
factorials	15	4	469	3	factorials
factories	14	8	1009	3	factories
gallerias	10	4	713	3	gallerias
hatteria	11	3	786	3	hatteria_
hysterias	15	4	714	3	hysterias
icterics	12	4	705	3	_icterics
latrias	7	19	1321	3	la_t_rias
listerias	9	5	922	3	listerias
masteries	11	10	1849	3	masteries
material	10	3	1409	3	ma_terial
materials	11	5	1079	3	ma_terials
rancherias	15	4	409	3	rancherias
santeras	8	3	1106	3	santer_as
santeria	8	3	1164	3	santeria_
taquerias	18	4	353	3	taquerias
victorias	14	4	652	3	victorias
wasteries	12	11	1534	3	wasteries
wisterias	12	4	809	3	wisterias

Search took 8 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	148641	0.156	1145455.1
2	DLD Change Limit	148641	74	7.126	20859.0
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	7.312	24438.0