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

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

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.

83 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
corsets	9	48	1980	(None)
cornets	9	48	2057	1	cornets
corses	8	44	3346	1	corse_s
corset	8	56	3622	1	corset_
corslets	10	3	827	1	corslets
corvets	12	47	1502	1	corvets
cosets	8	58	2440	1	co_sets
cossets	9	50	1428	1	cossets
worsets	10	55	1284	1	worsets
borshts	12	6	654	2	borshts
carets	8	53	3077	2	car_ets
carnets	9	39	1840	2	carnets
carpets	11	39	1533	2	carpets
carses	8	52	3365	2	carse_s
cermets	11	3	971	2	cermets
closets	9	46	1160	2	closets
coarsens	10	34	812	2	coarsens
coarsest	10	3	916	2	coarsest
coasts	8	57	1913	2	coas_ts
collets	9	35	1790	2	collets
comets	10	58	2358	2	co_mets
consents	10	27	1589	2	consents
copses	10	49	2247	2	copse_s
coquets	18	39	989	2	coquets
corbels	11	38	1359	2	corbels
corders	10	45	2087	2	corders
corers	8	52	3107	2	cor_ers
cores	7	63	6185	2	cor_e_s
corkers	13	41	1885	2	corkers
cormels	11	38	1337	2	cormels
corneas	9	47	1699	2	corneas
cornels	9	47	1666	2	cornels
corners	9	47	2331	2	corners
cornet	8	44	3673	2	cornet_
coronets	10	38	1436	2	coronets
corpses	11	39	1380	2	corpse_s
corrects	12	5	957	2	corrects
corsacs	11	3	901	2	corsacs
corse	7	50	3618	2	corse__
corselets	11	4	731	2	corselets
corseted	11	3	1147	2	corseted
corsetry	13	6	556	2	corsetry
corslet	9	3	1806	2	corslet_
corvees	12	46	1379	2	corvees
corves	11	51	2252	2	corve_s
corvet	11	46	2693	2	corvet_
cosecs	10	50	1521	2	co_secs
coses	7	69	4949	2	co_se_s
coset	7	57	4884	2	co_set_
coseys	11	52	1581	2	co_seys
cosset	8	41	2586	2	cosset_
costs	7	72	3114	2	co_s_ts
coursers	10	44	1229	2	coursers
courses	9	42	1889	2	course_s
covets	11	48	1964	2	co_vets
crests	8	52	1870	2	c_rests
cruets	8	53	1495	2	c_ruets
crusets	9	38	1104	2	crusets
curets	8	49	2234	2	cur_ets
cursers	9	43	1715	2	cursers
curses	8	53	2827	2	curse_s
curvets	12	39	991	2	curvets
dorsels	8	44	1257	2	dorsels
dorsers	8	35	1629	2	dorsers
forests	10	41	1495	2	forests
forgets	11	38	1379	2	forgets
gorgets	9	47	1178	2	gorgets
gorses	7	47	2329	2	gorse_s
hornets	10	41	1355	2	hornets
horses	9	47	2934	2	horse_s
horstes	10	45	1611	2	horstes
horsts	9	58	1751	2	hors_ts
morsels	9	41	1265	2	morsels
onsets	6	40	1354	2	_onsets
possets	9	42	1277	2	possets
rosets	6	58	1995	2	ro_sets
sorbets	9	30	1250	2	sorbets
torses	6	47	2795	2	torse_s
versets	10	39	1309	2	versets
worsens	10	46	1026	2	worsens
worses	9	55	2295	2	worse_s
worset	9	67	2658	2	worset_
worsts	9	60	1433	2	wors_ts

Search took 5 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	107671	0.126	1418182.5
2	DLD Change Limit	107671	83	4.060	26520.0
3	Display Results	83	83	0.033	2515.2
	(SQL Overall)	178691	83	4.219	42353.9