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

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

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
valve	11	45	1593	(None)
calve	10	59	1992	1	calve
halve	11	48	1892	1	halve
salve	8	50	2213	1	salve
vale	7	49	3734	1	val_e
valse	8	51	1752	1	valse
value	8	57	1909	1	value
valved	13	67	1104	1	valved
valves	12	41	1378	1	valves
varve	11	57	1685	1	varve
alae	4	56	4375	2	_alae
ale	3	65	7234	2	_al_e
alee	4	66	5232	2	_alee
alive	8	57	2251	2	_alive
alme	6	58	3216	2	_alme
aloe	4	55	4019	2	_aloe
ave	6	77	4870	2	_a_ve
bale	6	63	5384	2	bal_e
bivalve	15	4	359	2	bivalve
calved	12	52	1545	2	calved
calves	11	51	1928	2	calves
carve	10	62	2775	2	carve
cave	9	59	4126	2	ca_ve
clave	10	54	2015	2	clave
dale	5	56	4398	2	dal_e
delve	9	60	1826	2	delve
eave	7	57	3358	2	ea_ve
evolve	12	30	650	2	evolve
false	8	48	1812	2	false
fauve	11	47	1207	2	fauve
fave	10	55	3296	2	fa_ve
gale	5	63	4732	2	gal_e
gave	8	46	3405	2	ga_ve
hale	7	60	5283	2	hal_e
halva	11	54	1443	2	halva
halved	13	48	1390	2	halved
halves	12	47	1709	2	halves
have	10	61	3707	2	ha_ve
helve	11	50	1809	2	helve
kale	8	65	3375	2	kal_e
lave	7	56	4214	2	la_ve
male	6	60	5230	2	mal_e
mauve	10	40	1327	2	mauve
naive	8	51	1621	2	naive
nave	7	57	3231	2	na_ve
pale	6	60	5501	2	pal_e
parve	10	98	2485	2	parve
pave	9	61	3389	2	pa_ve
rale	4	50	5056	2	ral_e
rave	7	55	4209	2	ra_ve
sale	4	49	5970	2	sal_e
salved	10	39	1642	2	salved
salver	9	46	1775	2	salver
salves	9	42	2176	2	salves
salvo	8	44	1564	2	salvo
save	7	57	4136	2	sa_ve
slave	8	42	2403	2	slave
solve	8	56	1894	2	solve
tale	4	61	5416	2	tal_e
vague	9	65	1311	2	vague
vales	8	54	3426	2	vales
valet	8	43	3787	2	valet
valid	9	46	1839	2	valid
valine	9	46	2309	2	valine
valise	9	29	1764	2	valise
valley	12	43	1160	2	valley
valor	8	36	1489	2	valor
valses	9	45	1461	2	valses
valued	10	40	1115	2	valued
valuer	9	39	1144	2	valuer
values	9	43	1494	2	values
valval	12	39	886	2	valval
valvar	12	38	865	2	valvar
valvate	13	37	1081	2	valvate
valvule	13	4	366	2	valvule
vane	7	55	3469	2	va_ne
varved	13	41	1060	2	varved
varves	12	44	1478	2	varves
vase	7	56	2965	2	va_se
vav	9	58	2943	2	va_v_
vavs	10	57	2043	2	va_vs
velvet	12	36	1375	2	velvet
verve	11	54	1772	2	verve
vile	7	61	3980	2	vil_e
vive	10	54	2662	2	v_ive
vole	7	52	3698	2	vol_e
volte	8	53	2130	2	volte
volva	11	39	900	2	volva
vulva	11	44	880	2	vulva
vulvae	12	43	803	2	vulvae
waive	11	42	1460	2	waive
wale	7	45	4643	2	wal_e
wave	10	52	3473	2	wa_ve

Search took 2 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	53800	0.310	576422.6
2	DLD Change Limit	53800	93	1.406	38264.6
3	Display Results	93	93	0.016	5812.5
	(SQL Overall)	178691	93	1.732	103170.3