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

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

79 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
valued	10	40	1115	(None)
value	8	57	1909	1	value_
valuer	9	39	1144	1	valuer
values	9	43	1494	1	values
valved	13	67	1104	1	valved
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
blued	8	45	2032	2	_blued
calked	13	46	1740	2	calked
called	9	41	2673	2	called
calmed	11	48	1638	2	calmed
calqued	19	30	652	2	calqued
calved	12	52	1545	2	calved
clued	8	49	1768	2	_clued
devalued	13	3	501	2	devalued
flued	9	50	2125	2	_flued
galled	8	46	2286	2	galled
glued	7	51	1836	2	_glued
haled	9	53	3582	2	hal_ed
haloed	10	47	1760	2	haloed
halted	10	50	1960	2	halted
halved	13	48	1390	2	halved
hauled	10	44	1521	2	hauled
lalled	7	42	1875	2	lalled
malfed	12	36	976	2	malfed
malled	9	46	2611	2	malled
malted	9	48	1986	2	malted
mauled	9	48	1782	2	mauled
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
revalued	12	3	702	2	revalued
salted	7	41	2120	2	salted
saluted	8	45	1171	2	saluted
salved	10	39	1642	2	salved
slued	6	42	2051	2	_slued
tabued	9	43	1040	2	tabued
talced	9	38	1100	2	talced
talked	11	40	1540	2	talked
unvalued	12	6	631	2	unvalued
vague	9	65	1311	2	vague_
vaguer	10	44	844	2	vaguer
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	1839	2	val_id
valley	12	43	1160	2	valley
valse	8	51	1752	2	valse_
valses	9	45	1461	2	valses
valuated	12	23	920	2	valuated
valuers	10	32	894	2	valuers
valuta	9	3	874	2	valuta
valve	11	45	1593	2	valve_
valves	12	41	1378	2	valves
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
varved	13	41	1060	2	varved
vatted	10	42	1473	2	vatted
vaulted	11	30	719	2	vaulted
vealed	10	39	1632	2	veal_ed
velured	11	3	668	2	velured
vialed	10	51	1259	2	vial_ed
vialled	11	5	684	2	vialled
vogued	11	45	763	2	vogued
voled	9	53	2372	2	vol_ed
volumed	13	28	568	2	volumed
voluted	11	29	794	2	voluted
waled	9	43	3099	2	wal_ed
walked	14	53	1378	2	walked
walled	10	40	2129	2	walled
wauled	10	47	1396	2	wauled

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.236	757165.3
2	DLD Change Limit	82551	79	2.966	27832.4
3	Display Results	79	79	0.016	4937.5
	(SQL Overall)	178691	79	3.218	55528.6