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

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

76 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
viatica	12	4	586	(None)
viatic	11	3	1145	1	viatic_
viatical	13	4	706	1	viatical
aviatic	12	3	924	2	aviatic_
sciatica	12	10	611	2	sciatica
vatic	10	3	1642	2	v_atic_
vatical	12	3	998	2	v_atical
viaticals	14	4	407	2	viaticals
viaticum	15	4	273	2	viaticum
arabica	11	4	728	3	arabica
aviating	12	3	1102	3	aviating
aviation	11	3	1274	3	aviation
aviatrice	14	4	307	3	aviatrice
biotic	10	38	1661	3	biotic_
biotical	12	4	886	3	biotical
biotics	11	38	1217	3	biotics
diptyca	15	4	274	3	diptyca
distich	13	3	1217	3	distich
enatic	8	3	1756	3	enatic_
erotica	9	28	1151	3	erotica
exotica	16	25	760	3	exotica
fistic	11	8	1257	3	fistic_
hepatica	15	17	759	3	hepatica
himatia	12	4	859	3	himati_a
iatric	8	3	1217	3	_iatric_
iatrical	10	4	927	3	_iatrical
ictic	9	3	1180	3	_ictic_
intima	8	19	1003	3	_intima
latina	6	56	2114	3	_latina
miotic	10	37	1575	3	miotic_
miotics	11	27	1065	3	miotics
pataca	10	3	1119	3	_pataca
patina	8	60	2219	3	_patina
phatic	13	30	1441	3	phatic_
pianic	10	37	1412	3	pianic_
piratic	11	3	1429	3	piratic_
piratical	13	4	867	3	piratical
platina	9	44	1364	3	platina
riata	5	46	1802	3	riat__a
sciatic	11	9	1017	3	sciatic_
sciaticas	13	10	482	3	sciaticas
sciatics	12	11	727	3	sciatics
sialic	8	3	1363	3	sialic_
silica	8	3	1124	3	si_lica
static	8	31	1868	3	static_
statical	10	3	942	3	statical
statice	9	26	1403	3	statice
statics	9	33	1453	3	statics
swastica	13	8	415	3	swastica
uratic	8	30	1636	3	uratic_
vagina	10	27	1093	3	v_agina
varia	8	58	2420	3	v_ari_a
venatic	12	3	1152	3	venatic_
venatical	14	4	679	3	venatical
vertical	13	4	1043	3	vertical
vesica	11	15	791	3	v_esica
viaduct	13	4	407	3	viaduct
vialing	11	36	1416	3	vialing
viaticums	16	4	217	3	viaticums
viator	9	32	1183	3	viat_or
viators	10	27	1202	3	viators
victim	13	3	769	3	victi_m
victims	14	3	600	3	victims
vigia	9	48	1327	3	vi_gi_a
villatic	13	4	623	3	villatic_
vimina	11	33	994	3	vi_mina
vinca	10	53	1516	3	vi__nca
vinic	10	3	1497	3	vi_nic_
vista	8	54	1660	3	vist__a
vita	7	58	2852	3	vi_t__a
vitric	11	25	1011	3	vitric_
vitrics	12	19	855	3	vitrics
vitta	8	50	1517	3	vi_t_ta
vivaria	13	4	698	3	vivari_a
vomica	13	3	638	3	v_omica
vortical	13	4	886	3	vortical

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	76	6.110	21935.7
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	6.546	27297.7