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

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

82 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
crevasses	14	4	414	(None)
crevasse	13	4	309	1	crevasse_
crevassed	15	4	320	1	crevassed
canvasses	14	28	604	2	canvasses
creases	9	40	2096	2	cre_a_ses
cresses	9	42	1981	2	cre__sses
crevalles	14	5	572	2	crevalles
repasses	10	18	1037	2	_repasses
brasses	9	38	1835	3	br__asses
camasses	12	38	897	3	c_amasses
canvases	13	34	952	3	canva_ses
canvassed	15	27	404	3	canvassed
canvasser	14	27	426	3	canvasser
canvassers	15	27	358	3	canvassers
carcasses	13	3	748	3	carcasses
caresses	10	3	1406	3	care__sses
ceases	8	44	2707	3	c_e_a_ses
cerastes	10	11	1109	3	c_erastes
cesses	8	42	2136	3	c_e__sses
chasses	12	40	1750	3	c__hasses
chesses	12	41	1263	3	che__sses
classes	9	47	1794	3	c__lasses
cleanses	10	35	814	3	cle_anses
clevises	13	3	690	3	clev_ises
compasses	15	4	739	3	compasses
crases	8	55	3231	3	cr__a_ses
crashes	12	46	1840	3	cr__ashes
crasser	9	41	1434	3	cr__asser
crassest	10	34	1152	3	cr__assest
crease	8	55	1957	3	cre_a_se_
creased	10	43	1558	3	cre_a_sed
creaser	9	44	1574	3	cre_a_ser
creasers	10	36	1284	3	cre_asers
creasier	10	32	1019	3	cre_asier
creasiest	11	22	994	3	cre_asiest
creates	9	52	2520	3	cre_a_tes
creeses	9	39	1462	3	cre__eses
creeshes	13	3	695	3	cre_eshes
cremates	12	42	1600	3	crema_tes
creolises	11	5	789	3	creolises
cresset	9	33	1994	3	cre__sset
cressets	10	30	910	3	cre__ssets
crevalle	13	4	616	3	crevalle_
crevassing	16	4	353	3	crevassing
crevices	15	3	671	3	crev_ices
crosses	9	42	2079	3	cr__osses
cuirasses	11	4	437	3	cuirasses
cutlasses	11	4	510	3	cutlasses
degasses	10	27	836	3	_degasses
dresses	8	37	1617	3	dre__sses
eyasses	10	38	802	3	__eyasses
frasses	10	43	1451	3	fr__asses
grasses	8	41	1734	3	gr__asses
greases	8	48	1671	3	gre_a_ses
kavasses	15	4	430	3	_kavasses
kvasses	14	36	550	3	__kvasses
megasses	11	30	774	3	_megasses
precesses	13	3	1046	3	precesses
premisses	13	28	876	3	premisses
prepastes	13	12	882	3	prepastes
presses	9	35	2315	3	pre__sses
pretastes	11	11	942	3	pretastes
prevalues	14	4	532	3	prevalues
previses	13	38	1428	3	prev_ises
prewashes	17	4	475	3	prewashes
reassess	8	3	651	3	_re_assess
recesses	10	3	1232	3	_recesses
rehashes	14	3	695	3	_rehashes
relapses	10	3	803	3	_relapses
repassed	11	22	927	3	_repassed
reraises	8	4	1564	3	_reraises
retastes	8	22	1290	3	_retastes
revalues	11	3	788	3	_revalues
reverses	11	25	1351	3	_reverses
revises	10	42	2053	3	_rev_ises
rewashes	14	4	703	3	_rewashes
rubasses	10	3	549	3	_rubasses
trasses	7	48	1932	3	tr__asses
trespasses	12	4	260	3	trespasses
tresses	7	37	1954	3	tre__sses
ureases	7	44	1672	3	ure_a_ses
wrasses	10	38	1259	3	wr__asses

Search took 9 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.436	409841.7
2	DLD Change Limit	148641	82	7.580	19609.6
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	8.046	22208.7