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

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

85 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
theses	9	65	1797	(None)
thebes	11	59	1449	1	thebes
themes	11	53	1925	1	themes
theres	9	65	2547	1	theres
these	8	65	1901	1	these_
thesis	9	49	1373	1	thesis
thesps	11	44	826	1	thesps
tmeses	8	57	1224	1	tmeses
antheses	11	3	1147	2	antheses
apheses	12	6	1070	2	apheses
beses	7	58	3072	2	_beses
chases	11	51	2823	2	chases
cheeses	12	36	1310	2	cheeses
chess	10	50	1692	2	ches_s
chesses	12	41	1263	2	chesses
chests	11	49	1626	2	chests
choses	11	58	2513	2	choses
cyeses	11	5	1012	2	cyeses
dieses	7	52	1869	2	dieses
emeses	8	61	1496	2	emeses
eses	4	53	3610	2	__eses
estheses	11	3	778	2	estheses
ethenes	10	33	1387	2	ethenes
ethoses	10	3	1176	2	ethoses
ghees	9	52	1555	2	ghe_es
hebes	10	55	2167	2	_hebes
hemes	10	50	3108	2	_hemes
heres	8	62	4590	2	_heres
hests	8	58	2993	2	_hests
hexes	15	51	2304	2	_hexes
hoses	8	54	4318	2	_hoses
leses	5	49	3081	2	_leses
phases	11	46	1840	2	phases
physes	14	39	978	2	physes
rhemes	11	59	1318	2	rhemes
rhesus	9	3	620	2	rhesus
rhuses	9	49	1179	2	rhuses
tasses	6	48	2676	2	tasses
tawses	9	49	1319	2	tawses
teases	6	54	2627	2	teases
tees	4	53	5358	2	t_e_es
teles	5	45	3600	2	t_eles
teleses	7	3	1312	2	teleses
tenses	6	47	2255	2	tenses
testes	6	51	2582	2	t_estes
tests	5	65	3019	2	t_ests
thanes	9	49	1898	2	thanes
thebe	10	75	1543	2	thebe_
thee	7	80	3906	2	the_e_
thefts	12	38	792	2	thefts
thegns	10	54	743	2	thegns
theines	10	40	1323	2	theines
theins	9	50	1542	2	theins
theirs	9	46	1035	2	theirs
theisms	12	3	776	2	theisms
theists	10	3	915	2	theists
theme	10	59	2173	2	theme_
themed	12	59	1258	2	themed
thens	8	59	2183	2	the_ns
there	8	75	2739	2	there_
thermes	12	62	1461	2	thermes
therms	11	59	1487	2	therms
thesp	10	54	1031	2	thes_p
thetas	9	30	1157	2	thetas
thews	11	74	1619	2	the_ws
thieves	13	4	690	2	thieves
tholes	9	49	1978	2	tholes
those	8	52	1814	2	those_
threes	9	71	1732	2	threes
threshes	14	3	738	2	threshes
throes	9	75	1867	2	throes
thymes	14	48	1074	2	thymes
thyrses	13	3	502	2	thyrses
tmesis	8	52	979	2	tmesis
torses	6	47	2795	2	torses
tosses	6	52	2539	2	tosses
touses	6	42	2967	2	touses
trees	5	58	3576	2	tre_es
tress	5	54	2316	2	tres_s
tresses	7	37	1954	2	tresses
tsetses	7	8	545	2	tsetses
tusses	6	49	2124	2	tusses
tyees	8	60	1945	2	tye_es
wheres	12	59	1743	2	wheres
yeses	8	51	1932	2	_yeses

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	85	2.390	34540.2
3	Display Results	85	85	0.033	2575.8
	(SQL Overall)	178691	85	2.766	64602.7