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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

110 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
cysts	10	59	1277	(None)
casts	7	72	3779	1	casts
cists	7	66	2453	1	cists
costs	7	72	3114	1	costs
cyst	9	63	2281	1	cyst_
xysts	15	55	812	1	xysts
basts	7	59	3693	2	basts
bests	7	59	3261	2	bests
busts	7	52	2769	2	busts
cants	7	70	3694	2	cants
carts	7	89	4629	2	carts
casas	7	53	2784	2	casas
cases	7	50	4838	2	cases
casks	11	57	2006	2	casks
cast	6	71	5990	2	cast_
caste	7	59	3236	2	caste
castes	8	56	3186	2	castes
casus	7	64	1925	2	casus
cats	6	63	5634	2	c_ats
celts	7	53	2578	2	celts
cents	7	47	3033	2	cents
cess	6	53	2605	2	ces_s
cesta	7	54	1948	2	cesta
cestas	8	50	1854	2	cestas
cesti	7	52	1742	2	cesti
cestos	8	47	1809	2	cestos
cestus	8	44	1291	2	cestus
chats	10	57	3009	2	chats
chests	11	49	1626	2	chests
chits	10	54	2457	2	chits
cist	6	72	4496	2	cist_
cistus	8	46	1134	2	cistus
clasts	8	48	1729	2	clasts
clots	7	56	2764	2	clots
coasts	8	57	1914	2	coasts
coats	7	56	3500	2	coats
colts	7	66	3329	2	colts
coots	7	56	3684	2	coots
coses	7	69	4949	2	coses
cosets	8	58	2440	2	cosets
coss	6	61	4349	2	cos_s
cost	6	80	5794	2	cost_
costa	7	55	2373	2	costa
cots	6	80	5484	2	c_ots
crests	8	52	1870	2	crests
crits	7	55	2757	2	crits
crusts	8	49	1654	2	crusts
crypts	13	39	774	2	crypts
cults	7	50	2255	2	cults
cunts	7	61	2512	2	cunts
cusks	11	49	1605	2	cusks
cusps	9	49	1367	2	cusps
cuss	6	54	3061	2	cus_s
custos	8	40	1431	2	custos
cuts	6	58	4115	2	c_uts
cyans	10	57	1481	2	cyans
cycas	12	65	1382	2	cycas
cyeses	11	5	1012	2	cyeses
cyesis	11	4	857	2	cyesis
cymas	12	64	1788	2	cymas
cymes	12	101	1892	2	cymes
cystic	13	27	1065	2	cystic
dusts	6	59	2356	2	dusts
easts	5	75	3032	2	easts
encysts	12	4	431	2	encysts
fasts	8	64	2968	2	fasts
fests	8	58	2804	2	fests
fists	8	55	2754	2	fists
gasts	6	66	2863	2	gasts
gests	6	60	2881	2	gests
gists	6	60	2619	2	gists
gusts	6	57	2279	2	gusts
hests	8	58	2993	2	hests
hists	8	63	2837	2	hists
hosts	8	55	2670	2	hosts
jests	12	59	2245	2	jests
justs	12	49	1826	2	justs
kists	9	58	2211	2	kists
kyats	12	50	1244	2	kyats
lasts	5	77	3126	2	lasts
lists	5	66	2869	2	lists
lusts	5	50	2280	2	lusts
lyses	8	45	1825	2	lyses
lysis	8	45	1146	2	lysis
masts	7	70	3576	2	masts
mists	7	66	3390	2	mists
mosts	7	60	2854	2	mosts
musts	7	55	2744	2	musts
nests	5	57	2800	2	nests
oasts	5	65	2918	2	oasts
oocysts	12	4	392	2	oocysts
ousts	5	52	2570	2	ousts
pasts	7	59	3650	2	pasts
pests	7	59	3327	2	pests
posts	7	52	2878	2	posts
rests	5	49	3587	2	rests
rusts	5	50	2699	2	rusts
ryots	8	53	1378	2	ryots
tests	5	65	3019	2	tests
trysts	9	44	879	2	trysts
vasts	8	64	2377	2	vasts
vests	8	53	2598	2	vests
wasts	8	74	3367	2	wasts
wests	8	57	2700	2	wests
wists	8	67	2852	2	wists
xyst	14	47	1407	2	xyst_
xysti	15	53	815	2	xysti
xystos	16	35	691	2	xystos
xystus	16	35	442	2	xystus
zests	14	54	1974	2	zests

Search took 6 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	53800	0.606	294869.6
2	DLD Change Limit	53800	110	5.033	10689.4
3	Display Results	110	110	0.203	541.9
	(SQL Overall)	178691	110	5.842	30587.3