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

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

63 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
valuer	9	39	1144	(None)
vaguer	10	44	844	1	vaguer
value	8	57	1909	1	value_
valued	10	40	1115	1	valued
valuers	10	32	894	1	valuers
values	9	43	1494	1	values
alder	6	54	2191	2	_alder
alter	5	48	2850	2	_alter
balder	9	53	1886	2	balder
baler	7	56	3527	2	bal_er
balker	12	45	1916	2	balker
baller	8	38	2520	2	baller
bluer	7	49	1849	2	_bluer
calker	12	49	1708	2	calker
caller	8	51	2548	2	caller
calmer	10	52	1693	2	calmer
faller	9	46	2123	2	faller
falser	9	39	1241	2	falser
falter	9	45	1905	2	falter
gluer	6	51	1677	2	_gluer
haler	8	50	3352	2	hal_er
halter	9	44	2088	2	halter
hauler	9	50	1512	2	hauler
mauler	8	44	1671	2	mauler
paler	7	54	3693	2	pal_er
palier	8	50	2356	2	palier
palmer	10	58	1654	2	palmer
palter	8	44	2326	2	palter
salter	6	43	2508	2	salter
saluter	7	35	1245	2	saluter
salver	9	46	1775	2	salver
taler	5	60	3486	2	tal_er
talker	10	39	1622	2	talker
taller	6	37	2196	2	taller
vague	9	65	1311	2	vague_
vainer	9	37	1457	2	vainer
vale	7	49	3734	2	val_e_
vales	8	54	3426	2	val_es
valet	8	43	3787	2	val_et
valkyr	16	3	240	2	valkyr
valley	12	43	1160	2	valley
valor	8	36	1489	2	val_or
valour	9	30	1037	2	valour
valse	8	51	1752	2	valse_
valses	9	45	1461	2	valses
valuta	9	3	874	2	valuta
valvar	12	38	865	2	valvar
valve	11	45	1593	2	valve_
valved	13	67	1104	2	valved
valves	12	41	1378	2	valves
vamper	13	42	1265	2	vamper
vanner	9	42	1584	2	vanner
vaquero	19	4	264	2	vaquero
varier	9	46	1935	2	varier
vaster	9	45	2102	2	vaster
vaulter	10	25	771	2	vaulter
vealer	9	40	1654	2	veal_er
vealier	10	27	1217	2	vealier
velure	9	3	977	2	velure
viler	8	63	2416	2	vil_er
voguer	10	46	840	2	voguer
waler	8	42	2926	2	wal_er
walker	13	39	1399	2	walker

Search took 3 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.346	516448.0
2	DLD Change Limit	82551	63	2.610	31628.7
3	Display Results	63	63	0.013	4846.2
	(SQL Overall)	178691	63	2.969	60185.6