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

Here are the results of your fuzzy-string dictionary search for “prevalues” 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
prevalues	14	4	532	(None)
prevalue	13	4	507	1	prevalue_
prevalued	15	4	455	1	prevalued
revalues	11	3	788	1	_revalues
crevalles	14	5	572	2	crevalles
devalues	12	3	585	2	_devalues
presales	10	3	1526	2	presal_es
prevues	12	3	926	2	prev__ues
revalue	10	3	815	2	_revalue_
revalued	12	3	702	2	_revalued
crevalle	13	4	616	3	crevalle_
crevasses	14	4	414	3	crevasses
devalue	11	3	601	3	_devalue_
devalued	13	3	501	3	_devalued
disvalues	13	4	450	3	disvalues
misvalues	14	4	468	3	misvalues
outvalues	12	4	430	3	outvalues
overvalues	16	4	496	3	overvalues
percales	12	3	1380	3	percal_es
pervades	14	3	735	3	perva_des
preaches	15	32	1489	3	pre_aches
prealter	10	4	886	3	pre_alter
prealters	11	4	777	3	pre_alters
prebakes	16	3	901	3	preba_kes
precludes	14	4	505	3	pre_cludes
predates	11	6	1581	3	preda_tes
prefaces	15	3	1106	3	prefa_ces
prefades	14	3	953	3	prefa_des
prefiles	13	31	1344	3	prefil_es
pregames	13	3	900	3	prega_mes
prelacies	13	3	1005	3	prelacies
prelates	10	4	1857	3	prela_tes
prelatures	12	4	573	3	prelatures
preludes	11	3	783	3	pre__ludes
prematures	14	4	706	3	prematures
prenames	12	3	1164	3	prena_mes
prepares	12	20	1416	3	prepa_res
prepastes	13	12	882	3	prepastes
prepaves	15	18	919	3	prepa_ves
preplaces	15	7	875	3	preplaces
presages	11	3	1220	3	presa_ges
presale	9	4	1635	3	presal_e_
presolves	14	5	653	3	presolves
pretapes	12	28	1153	3	preta_pes
pretastes	11	11	942	3	pretastes
prevailed	15	3	604	3	prevailed
prevailer	14	4	515	3	prevailer
prevailers	15	12	383	3	prevailers
prevails	13	3	766	3	preva_ils
prevalences	18	4	509	3	prevalences
prevalent	14	12	806	3	prevalent
prevalents	15	9	497	3	prevalents
prevaluing	16	4	427	3	prevaluing
previous	13	3	782	3	previou_s
previses	13	38	1428	3	prev_ises
prevue	11	7	916	3	prev__ue_
prevued	13	3	714	3	prev__ued
prewashes	17	4	475	3	prewashes
privacies	16	4	680	3	privacies
privates	13	18	1237	3	priva_tes
reales	6	49	3412	3	_re_al_es
regales	8	35	2079	3	_regal_es
reglues	8	3	871	3	_re_glues
resales	7	47	2490	3	_resal_es
resalutes	9	4	743	3	_resalutes
revaluates	13	24	679	3	_revaluates
revenues	11	3	866	3	_revenues
reviles	10	44	2135	3	_revil_es
revolves	14	27	862	3	_revolves
revues	9	8	1390	3	_rev__ues
trevallies	13	4	346	3	trevallies
trevallys	15	4	221	3	trevallys
trivalves	15	4	414	3	trivalves
values	9	43	1494	3	___values

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	148641	0.420	425454.8
2	DLD Change Limit	148641	74	6.610	22487.3
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	7.060	25310.3