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

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

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
artilleries	11	8	454	(None)
artillerist	11	5	445	2	artillerist
artillerists	12	5	307	2	artillerists
grilleries	11	4	559	2	gr_illeries
railleries	10	4	664	2	_railleries
ancillaries	13	5	457	3	ancillaries
arteries	8	3	2148	3	art___eries
artillery	12	4	357	3	artiller__y
artillerymen	17	6	79	3	artillerymen
artistries	10	4	725	3	arti_stries
axillaries	17	4	487	3	a_xillaries
distilleries	13	5	282	3	distilleries
drolleries	11	4	544	3	dr_olleries
fritillaries	15	5	200	3	fritillaries
rifleries	12	4	768	3	_r_ifleries
adulteries	11	4	562	4	a_dulteries
aetiologies	12	4	898	4	aetiologies
alfilerias	13	15	287	4	alfi_lerias
allergies	10	13	778	4	a___llergies
altimetries	13	5	592	4	altimetries
anticaries	12	4	1247	4	anti_caries
antiheroes	13	4	717	4	anti_heroes
antiherpes	15	4	540	4	anti_herpes
antilogies	11	4	1031	4	anti_logies
antimeres	11	4	1089	4	anti_mer_es
antiquaries	20	5	632	4	antiquaries
antistories	11	4	937	4	antistories
archeries	14	4	1122	4	ar__cheries
argillites	11	4	348	4	argill_ites
arillodes	10	4	468	4	ar_ill_odes
articles	10	3	1024	4	articl___es
articulacies	16	6	478	4	articulacies
artilleryman	17	7	81	4	artilleryman
artinesses	10	8	1521	4	arti_nesses
auxiliaries	18	5	273	4	auxiliaries
baptisteries	16	5	239	4	baptisteries
braillers	11	3	555	4	brailler__s
briberies	13	4	833	4	br_i_beries
broideries	13	4	635	4	broi_deries
butleries	11	7	1007	4	but__leries
capillaries	15	5	445	4	capillaries
cartularies	13	4	537	4	cart_ularies
cutleries	11	7	921	4	cut__leries
drillers	9	42	972	4	dr_iller__s
farrieries	13	4	434	4	farri__eries
frillers	11	34	987	4	fr_iller__s
fripperies	17	4	358	4	fr_ipperies
fritillarias	15	6	145	4	fritillarias
fulleries	12	4	872	4	__fulleries
galleries	10	3	1170	4	__galleries
grillers	9	38	1081	4	gr_iller__s
grinderies	12	4	583	4	gr_inderies
helleries	12	26	1168	4	__helleries
jewelleries	21	5	155	4	jewelleries
maxillaries	20	5	310	4	maxillaries
millerites	12	4	793	4	__millerites
partialities	14	10	803	4	partialities
patisseries	13	5	290	4	patisseries
pillories	11	8	957	4	__pillories
priggeries	14	4	499	4	pr_iggeries
printeries	12	4	1063	4	pr_interies
ramillies	11	4	613	4	ramill__ies
rillettes	9	4	653	4	_r_illettes
rotisseries	11	5	303	4	rotisseries
sculleries	12	4	483	4	_sculleries
tilburies	11	4	434	4	__tilburies
tillered	9	3	744	4	__tiller_ed
tillering	10	3	788	4	__tillering
tillermen	11	4	359	4	__tillermen
tillers	7	34	1874	4	__tiller__s
trailerites	11	5	496	4	trai_lerites
trickeries	16	4	714	4	tr_ickeries
trillers	8	36	1349	4	tr_iller__s
vexillaries	21	5	287	4	vexillaries

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	74	9.173	16223.6
3	Display Results	74	74	0.046	1608.7
	(SQL Overall)	178691	74	9.639	18538.3