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

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

89 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
cassette	10	4	781	(None)
casette	9	3	1039	1	ca_sette
cassettes	11	4	670	1	cassettes
bassett	9	42	1386	2	bassett_
bassetted	12	4	469	2	bassetted
bassetts	10	40	737	2	bassetts
caseate	9	3	1478	2	ca_seate
casettes	10	3	965	2	ca_settes
cassene	9	31	1154	2	casse_ne
fossette	11	4	526	2	fossette
anisette	8	4	677	3	anisette
ariette	7	3	1237	3	_ariette
assent	6	51	1995	3	_assent_
assented	9	5	751	3	_assented
assenter	8	6	770	3	_assenter
assents	7	45	1222	3	_assents
assert	6	49	2258	3	_assert_
asserted	9	5	790	3	_asserted
asserter	8	7	757	3	_asserter
asserts	7	43	1179	3	_asserts
asset	5	59	3226	3	_asse_t_
assets	6	56	1766	3	_asse_ts
baguette	11	10	593	3	baguette
barbette	12	4	911	3	barbette
barrette	10	3	978	3	barrette
basset	8	52	2538	3	basse_t_
basseted	11	3	674	3	basseted
bassets	9	64	1482	3	basse_ts
cabalette	13	4	489	3	cabalette
cabretta	12	4	484	3	cabretta
calceate	12	3	986	3	calceate
calotte	9	5	1056	3	ca_lotte
casease	9	3	932	3	ca_sease
caseated	11	3	1071	3	ca_seated
caseates	10	3	1371	3	ca_seates
casemate	12	3	984	3	casemate
caseose	9	3	916	3	ca_seose
caserne	9	37	1006	3	ca_serne
casket	12	48	2099	3	caske_t_
casketed	15	3	495	3	casketed
caskets	13	39	1017	3	caske_ts
cassata	9	3	814	3	cass_ata
cassatas	10	3	668	3	cassatas
cassena	9	28	784	3	casse_na
cassenas	10	31	748	3	cassenas
cassenes	10	36	1129	3	cassenes
casserole	11	4	440	3	casserole
cassine	9	38	1728	3	cass_ine
caste	7	59	3236	3	ca_s__te
castle	8	49	1896	3	ca_s_tle
castrate	10	3	1386	3	castrate
causerie	10	7	827	3	causerie
cavetti	12	4	542	3	ca_vetti
cavetto	12	4	545	3	ca_vetto
classmate	13	4	486	3	classmate
coquette	19	7	659	3	coquette
corvette	13	3	809	3	corvette
cosset	8	41	2586	3	cosse_t_
cosseted	11	7	834	3	cosseted
cossets	9	50	1428	3	cosse_ts
crassest	10	34	1152	3	crassest_
curette	9	3	978	3	c_urette
cuvette	12	3	583	3	c_uvette
diskette	13	4	675	3	diskette
falsetto	11	4	369	3	falsetto
fossettes	12	4	508	3	fossettes
frisette	11	9	548	3	frisette
galette	8	42	1269	3	ga_lette
gazette	17	35	736	3	ga_zette
grisette	9	9	465	3	grisette
layette	10	3	713	3	la_yette
maquette	19	4	611	3	maquette
masseter	10	3	706	3	masseter
masseuse	10	4	425	3	masseuse
musette	9	3	843	3	_musette
nauseate	8	4	589	3	nauseate
navette	10	3	698	3	na_vette
noisette	8	4	631	3	noisette
palette	9	36	1398	3	pa_lette
pallette	10	3	951	3	pallette
palmette	12	4	773	3	palmette
parkette	14	13	802	3	parkette
passee	8	45	2202	3	passe__e
poussette	11	4	331	3	poussette
raclette	10	4	764	3	raclette
rosette	7	3	1037	3	_rosette
tasset	6	59	2531	3	tasse_t_
tassets	7	50	1277	3	tasse_ts
wadsetted	14	4	262	3	wadsetted

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.156	1145455.1
2	DLD Change Limit	146162	89	7.423	19690.4
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	7.609	23484.2