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

Here are the results of your fuzzy-string dictionary search for “prevalue” with Change Limit: [1] [2] [3] [4]

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.

74 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
prevalue	13	4	507	(None)
prevalued	15	4	455	1	prevalued
prevalues	14	4	532	1	prevalues
revalue	10	3	815	1	_revalue
crevalle	13	4	616	2	crevalle
devalue	11	3	601	2	_devalue
presale	9	4	1635	2	presal_e
prevue	11	7	916	2	prev__ue
revalued	12	3	702	2	_revalued
revalues	11	3	788	2	_revalues
crevalles	14	5	572	3	crevalles
crevasse	13	4	309	3	crevasse
devalued	13	3	501	3	_devalued
devalues	12	3	585	3	_devalues
disvalue	12	4	443	3	disvalue
misvalue	13	4	468	3	misvalue
outvalue	11	4	423	3	outvalue
overvalue	15	4	545	3	overvalue
percale	11	3	1409	3	percal_e
pervade	13	3	702	3	perva_de
prealter	10	4	886	3	pre_alter
prebade	12	3	1028	3	preba_de
prebake	15	3	909	3	preba_ke
precavae	15	4	481	3	precavae
preclude	13	4	490	3	pre_clude
predate	10	6	1689	3	preda_te
preface	14	5	1092	3	prefa_ce
prefade	13	3	901	3	prefa_de
prefile	12	34	1318	3	prefil_e
preflame	15	4	591	3	preflame
pregame	12	3	955	3	prega_me
prelate	9	5	1969	3	prela_te
prelature	11	4	627	3	prelature
prelude	10	3	801	3	pre__lude
premade	12	3	1144	3	prema_de
premature	13	4	779	3	premature
prename	11	4	1264	3	prena_me
prepare	11	19	1362	3	prepa_re
prepaste	12	13	908	3	prepaste
prepave	14	22	887	3	prepa_ve
preplace	14	8	898	3	preplace
prerace	11	4	1412	3	prera_ce
presage	10	3	1229	3	presa_ge
presales	10	3	1526	3	presales
presolve	13	4	707	3	presolve
pretape	11	35	1162	3	preta_pe
pretaste	10	13	952	3	pretaste
prevail	12	3	824	3	preva_il
prevailed	15	3	604	3	prevailed
prevailer	14	4	515	3	prevailer
prevails	13	3	766	3	prevails
prevalence	17	4	548	3	prevalence
prevalent	14	12	806	3	prevalent
prevaluing	16	4	427	3	prevaluing
previable	16	4	753	3	previable
previous	13	3	782	3	previous
previse	12	37	1379	3	prev_ise
prevued	13	3	714	3	prev__ued
prevues	12	3	926	3	prev__ues
private	12	15	1326	3	priva_te
provable	15	3	909	3	provable
regale	7	48	2145	3	_regal_e
reglue	7	3	970	3	_re_glue
resale	6	40	2554	3	_resal_e
resalute	8	5	741	3	_resalute
revaluate	12	27	710	3	_revaluate
revenue	10	3	953	3	_revenue
revile	9	49	2161	3	_revil_e
revolute	11	7	679	3	_revolute
revolve	13	32	837	3	_revolve
revue	8	11	1445	3	_rev__ue
trevally	14	4	634	3	trevally
trivalve	14	4	394	3	trivalve
value	8	57	1909	3	___value

Search took 8 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	146162	0.406	440125.6
2	DLD Change Limit	146162	74	7.390	19778.3
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	7.826	22833.0