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

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

76 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
crevalle	13	4	616	(None)
crevalles	14	5	572	1	crevalles
coevally	16	4	628	2	coevally
crenelle	10	4	633	2	crenelle
crevasse	13	4	309	2	crevasse
prevalue	13	4	507	2	prevalue
revalue	10	3	815	2	_revalue
trevally	14	4	634	2	trevally
areally	10	4	1124	3	are_ally
caecally	15	4	770	3	caecally
caravelle	14	4	470	3	caravelle
cavalla	12	5	788	3	c_avalla
cavally	15	8	848	3	c_avally
cecally	14	5	939	3	c_ecally
cenacle	11	3	912	3	c_enacle
chenille	13	5	459	3	chenille
chevalet	16	5	812	3	chevalet
chevalier	17	4	361	3	chevalier
chewable	18	3	544	3	chewable
cleavable	16	4	447	3	cleavable
coeval	11	3	889	3	coeva_l_
coevals	12	3	787	3	coeva_ls
coevolve	16	4	296	3	coevolve
cradle	9	33	1316	3	cr__adle
crease	8	55	1957	3	cre_a_se
creatable	13	3	956	3	creatable
create	8	51	2638	3	cre_a_te
credal	9	3	1167	3	creda_l_
credible	13	4	602	3	credible
cremate	11	38	1618	3	crema_te
crenate	9	33	1711	3	crena_te
crenelled	12	4	540	3	crenelled
crenelles	11	4	673	3	crenelles
creole	8	9	1373	3	cre__ole
crevassed	15	4	320	3	crevassed
crevasses	14	4	414	3	crevasses
crevice	14	3	615	3	crev_ice
devalue	11	3	601	3	_devalue
drivable	14	3	802	3	drivable
presale	9	4	1635	3	presa_le
prevail	12	3	824	3	prevail_
prevailed	15	3	604	3	prevailed
prevailer	14	4	515	3	prevailer
prevails	13	3	766	3	prevails
prevalued	15	4	455	3	prevalued
prevalues	14	4	532	3	prevalues
previable	16	4	753	3	previable
provable	15	3	909	3	provable
really	9	33	1561	3	_re_ally
recall	8	38	1572	3	_recall_
recalled	11	3	1080	3	_recalled
recaller	10	3	932	3	_recaller
recalls	9	26	1362	3	_recalls
refall	9	43	1439	3	_refall_
refallen	11	3	621	3	_refallen
refalls	10	33	1224	3	_refalls
regale	7	48	2145	3	_rega_le
regally	11	5	987	3	_regally
resale	6	40	2554	3	_resa_le
retable	9	18	2040	3	_retable
retally	10	4	1368	3	_retally
revalued	12	3	702	3	_revalued
revalues	11	3	788	3	_revalues
reveille	11	4	533	3	_reveille
revelled	12	37	1274	3	_revelled
reveller	11	29	1219	3	_reveller
revile	9	49	2161	3	_rev_ile
revolve	13	32	837	3	_revolve
rivalled	12	3	609	3	_rivalled
screwable	16	4	484	3	screwable
servable	13	3	1009	3	servable
treacle	9	3	997	3	tre_acle
treadle	8	3	1010	3	tre_adle
trevallies	13	4	346	3	trevallies
trevallys	15	4	221	3	trevallys
trivalve	14	4	394	3	trivalve

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	76	7.063	20694.0
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	7.499	23828.6