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

Here are the results of your fuzzy-string dictionary search for “varias” with Change Limit: [1] [2] [3]

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.

86 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
varias	9	50	1990	(None)
arias	5	54	3802	1	_arias
varas	8	60	2819	1	var_as
varia	8	58	2420	1	varia_
varies	9	43	3087	1	varies
varnas	9	42	1282	1	varnas
agrias	7	43	1539	2	agrias
alias	5	58	3460	2	_alias
amias	7	58	3146	2	_amias
areas	5	59	3577	2	_areas
aria	4	62	4542	2	_aria_
arils	5	87	3220	2	_arils
arras	5	56	2613	2	_arras
barcas	10	10	1660	2	barcas
capias	10	3	1835	2	capias
cardias	10	7	1509	2	cardias
caries	8	51	4762	2	caries
carinas	9	36	2238	2	carinas
caritas	9	33	1694	2	caritas
cerias	8	33	2197	2	cerias
darics	9	43	1411	2	darics
facias	11	34	1580	2	facias
farinas	10	32	1523	2	farinas
ferias	9	50	2039	2	ferias
jarinas	14	37	1218	2	jarinas
karmas	12	30	1373	2	karmas
lamias	8	50	2061	2	lamias
lariat	6	6	2904	2	lariat
lariats	7	6	1505	2	lariats
laris	5	47	3746	2	lari_s
larvas	9	3	1023	2	larvas
latrias	7	19	1321	2	latrias
mafias	11	39	1357	2	mafias
manias	8	40	2903	2	manias
maras	7	54	4328	2	mar_as
maria	7	50	3288	2	maria_
marinas	9	35	1937	2	marinas
markas	12	47	1700	2	markas
nairas	6	3	1277	2	nairas
narial	6	3	1795	2	narial
naris	5	57	3529	2	nari_s
norias	6	55	1818	2	norias
ovarial	10	3	761	2	ovarial
ovarian	10	3	764	2	ovarian
ovaries	10	3	1265	2	ovaries
paras	7	61	4304	2	par_as
pariah	11	43	2058	2	pariah
pariahs	12	38	1234	2	pariahs
parian	8	32	2396	2	parian
parians	9	35	1973	2	parians
paries	8	47	4251	2	paries
paris	7	51	4594	2	pari_s
parkas	12	50	1802	2	parkas
raias	5	46	3112	2	ra_ias
rias	4	55	4059	2	__rias
sarins	6	39	3262	2	sarins
saris	5	45	4495	2	sari_s
sharias	10	25	1600	2	sharias
tafias	9	31	1196	2	tafias
tarsias	7	40	1337	2	tarsias
vaginas	11	29	881	2	vaginas
vails	8	58	2593	2	va_ils
vairs	8	50	1913	2	va_irs
vakils	13	3	759	2	vakils
vandas	10	39	1599	2	vandas
vara	7	55	3088	2	var_a_
variant	10	3	1680	2	variant
variants	11	3	920	2	variants
variate	10	13	1643	2	variate
variates	11	12	1497	2	variates
varices	12	33	1357	2	varices
varied	10	48	1786	2	varied
varier	9	46	1935	2	varier
variers	10	37	1266	2	variers
variolas	11	6	853	2	variolas
various	10	31	1310	2	various
varix	15	43	1350	2	vari_x
varna	8	45	1617	2	varna_
vars	7	57	4207	2	var__s
varus	8	59	2118	2	var_us
varves	12	44	1478	2	varves
veritas	10	30	1275	2	veritas
vigias	10	41	1089	2	vigias
virgas	10	4	888	2	virgas
zamias	17	42	1292	2	zamias
zaribas	18	3	604	2	zaribas

Search took 4 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	82551	0.110	1624463.6
2	DLD Change Limit	82551	86	3.000	27517.0
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	3.140	56908.0