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

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

84 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
valved	13	67	1104	(None)
calved	12	52	1545	1	calved
halved	13	48	1390	1	halved
salved	10	39	1642	1	salved
valued	10	40	1115	1	valued
valve	11	45	1593	1	valve_
valves	12	41	1378	1	valves
varved	13	41	1060	1	varved
balded	10	54	1751	2	balded
baled	8	54	3644	2	bal_ed
balked	13	52	1941	2	balked
balled	9	49	2689	2	balled
bivalved	17	4	268	2	bivalved
calked	13	46	1740	2	calked
called	9	41	2673	2	called
calmed	11	48	1638	2	calmed
calve	10	59	1992	2	calve_
calves	11	51	1928	2	calves
carved	12	43	2085	2	carved
caved	11	62	2756	2	ca_ved
delved	11	41	1275	2	delved
eaved	9	59	2450	2	ea_ved
evolved	14	30	558	2	evolved
galled	8	46	2285	2	galled
haled	9	53	3582	2	hal_ed
haloed	10	47	1759	2	haloed
halted	10	50	1960	2	halted
halve	11	48	1892	2	halve_
halves	12	47	1709	2	halves
helved	13	43	1370	2	helved
lalled	7	42	1875	2	lalled
laved	9	50	2859	2	la_ved
malfed	12	36	975	2	malfed
malled	9	46	2610	2	malled
malted	9	48	1985	2	malted
naled	6	55	2505	2	nal_ed
paled	8	55	3872	2	pal_ed
palled	9	46	2516	2	palled
palmed	11	43	1464	2	palmed
palped	11	45	1364	2	palped
paved	11	55	2526	2	pa_ved
raved	9	49	3143	2	ra_ved
salted	7	41	2120	2	salted
salve	8	50	2213	2	salve_
salver	9	46	1775	2	salver
salves	9	42	2176	2	salves
salvoed	11	30	706	2	salvoed
saved	9	51	2711	2	sa_ved
slaved	10	40	1704	2	slaved
solved	10	53	1293	2	solved
talced	9	38	1100	2	talced
talked	11	40	1540	2	talked
vailed	10	46	1929	2	vailed
vale	7	49	3734	2	val_e_
vales	8	54	3426	2	val_es
valet	8	43	3787	2	val_et
valeted	11	3	901	2	valeted
valid	9	46	1838	2	val_id
valley	12	43	1160	2	valley
valse	8	51	1752	2	valse_
valses	9	45	1461	2	valses
value	8	57	1909	2	value_
valuer	9	39	1144	2	valuer
values	9	43	1494	2	values
valval	12	39	886	2	valval
valvar	12	38	865	2	valvar
vamped	14	42	1101	2	vamped
vaned	9	46	2242	2	va_ned
vanned	10	46	1448	2	vanned
varied	10	48	1786	2	varied
varve	11	57	1685	2	varve_
varves	12	44	1478	2	varves
vatted	10	42	1473	2	vatted
vaulted	11	30	719	2	vaulted
vealed	10	39	1632	2	veal_ed
velvet	12	36	1375	2	velvet
vialed	10	51	1259	2	vial_ed
vialled	11	5	684	2	vialled
voled	9	53	2372	2	vol_ed
waived	13	45	1128	2	waived
waled	9	43	3099	2	wal_ed
walked	14	53	1378	2	walked
walled	10	40	2129	2	walled
waved	12	52	2358	2	wa_ved

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	84	3.296	25045.8
3	Display Results	84	84	0.033	2545.5
	(SQL Overall)	178691	84	3.439	51960.2