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

Here are the results of your fuzzy-string dictionary search for “values” 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
values	9	43	1494	(None)
vales	8	54	3426	1	val_es
valses	9	45	1461	1	valses
value	8	57	1909	1	value_
valued	10	40	1115	1	valued
valuer	9	39	1144	1	valuer
valuers	10	32	894	1	valuers
valves	12	41	1378	1	valves
agues	6	49	1905	2	_agues
ales	4	70	6710	2	_al_es
almes	7	51	2654	2	_almes
aloes	5	49	3367	2	_aloes
alums	7	57	2060	2	_alums
bales	7	62	5008	2	bal_es
blues	7	51	2704	2	_blues
calces	10	44	2005	2	calces
calques	18	27	1019	2	calques
calves	11	51	1928	2	calves
calxes	15	41	1303	2	calxes
caules	8	59	2725	2	caules
clues	7	46	2303	2	_clues
dales	6	64	3974	2	dal_es
dalles	7	42	2206	2	dalles
devalues	12	3	585	2	devalues
falces	11	52	1600	2	falces
flues	8	46	2692	2	_flues
gales	6	54	4248	2	gal_es
glues	6	51	2568	2	_glues
hales	8	54	4984	2	hal_es
haloes	9	46	2386	2	haloes
halves	12	47	1709	2	halves
kales	9	57	3098	2	kal_es
lues	4	59	4355	2	__lues
males	7	50	4979	2	mal_es
pales	7	57	5380	2	pal_es
rales	5	49	4749	2	ral_es
revalues	11	3	788	2	revalues
sales	5	60	5559	2	sal_es
salutes	7	37	1625	2	salutes
salves	9	42	2176	2	salves
slues	5	45	2717	2	_slues
tales	5	54	5137	2	tal_es
taluks	10	41	828	2	taluks
talus	5	54	2326	2	talu_s
taluses	7	3	1121	2	taluses
vague	9	65	1311	2	vague_
vaguer	10	44	844	2	vaguer
vaguest	11	3	733	2	vaguest
vagus	9	67	1381	2	vagu_s
vale	7	49	3734	2	val_e_
valet	8	43	3787	2	val_et
valets	9	37	1562	2	valets
valgus	10	4	710	2	valgus
valguses	12	3	423	2	valguses
valines	10	45	2021	2	valines
valise	9	29	1764	2	valise
valises	10	35	1626	2	valises
valley	12	43	1160	2	valley
valleys	13	40	748	2	valleys
valors	9	34	1377	2	valors
valours	10	24	874	2	valours
valse	8	51	1752	2	valse_
valuates	11	28	1120	2	valuates
valuta	9	3	874	2	valuta
valutas	10	3	653	2	valutas
valve	11	45	1593	2	valve_
valved	13	67	1104	2	valved
valvules	14	4	347	2	valvules
vanes	8	51	3097	2	va_nes
varies	9	43	3087	2	varies
varus	8	59	2118	2	varu_s
varuses	10	3	1062	2	varuses
varves	12	44	1478	2	varves
vases	8	46	2626	2	va_ses
vatus	8	61	1464	2	vatu_s
vaults	9	45	1167	2	vaults
vaus	7	59	2892	2	va_u_s
velures	10	3	909	2	velures
venues	9	51	1520	2	venues
vogues	10	40	1192	2	vogues
voles	8	62	3404	2	vol_es
voltes	9	49	1558	2	voltes
volumes	12	29	823	2	volumes
volutes	10	27	1098	2	volutes
wales	8	61	4283	2	wal_es
walies	9	53	2452	2	walies

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.343	520965.0
2	DLD Change Limit	82551	86	2.453	33653.1
3	Display Results	86	86	0.033	2606.1
	(SQL Overall)	178691	86	2.829	63164.0