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

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

84 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
subtexts	17	4	490	(None)
subtests	10	3	753	1	subtests
subtext	16	4	765	1	subtext_
subjects	19	22	653	2	subjects
sublets	9	26	1670	2	suble_ts
subnets	9	25	1208	2	subne_ts
subrents	10	3	1029	2	subrents
subsects	12	26	790	2	subsects
subsets	9	28	1310	2	subse_ts
subteens	10	3	742	2	subteens
subtends	11	3	617	2	subtends
subtest	9	5	1396	2	subtest_
subverts	13	3	697	2	subverts
urtexts	14	3	314	2	_urtexts
contexts	17	37	865	3	contexts
obtests	9	13	623	3	_obtests
outeats	7	22	1570	3	ou_teats
pretexts	17	3	560	3	pretexts
septets	9	9	895	3	septe_ts
sestets	7	9	1147	3	seste_ts
sextets	14	9	714	3	sexte_ts
sexts	12	51	1838	3	s___exts
stents	6	50	1945	3	s__tents
stets	5	54	2391	3	s__te_ts
subagents	12	4	500	3	subagents
subcells	12	4	628	3	subcells
subcults	12	4	693	3	subcults
subdeans	11	3	720	3	subdeans
subdebs	12	3	648	3	subde_bs
subdepots	14	4	316	3	subdepots
subducts	13	10	609	3	subducts
subedits	11	4	671	3	subedits
subers	8	57	2264	3	sub_e_rs
subfixes	20	20	749	3	subfixes
subgenus	11	4	575	3	subgenus
subheads	14	9	653	3	subheads
subitems	12	4	549	3	subite_ms
subject	18	25	863	3	subject_
sublet	8	28	2724	3	suble_t_
sublots	9	24	1091	3	sub_lots
submenus	12	4	590	3	submenus
submits	11	3	975	3	sub_mits
subnet	8	25	2093	3	subne_t_
subparts	12	4	690	3	subparts
subpenas	12	4	690	3	subpenas
subplots	12	5	577	3	subplots
subrent	9	3	1508	3	subrent_
subsect	11	26	1184	3	subsect_
subseres	10	3	1242	3	subseres
subset	8	31	2258	3	subse_t_
subsists	10	3	799	3	subsists
subtasks	14	4	449	3	subtasks
subtaxa	16	4	448	3	subtax_a
subtaxon	17	4	274	3	subtaxon
subtaxons	18	4	268	3	subtaxons
subteen	9	3	852	3	subte_en
subtenants	12	4	455	3	subtenants
subtend	10	3	710	3	subte_nd
subtextual	19	5	210	3	subtextual
subthemes	16	4	411	3	subthemes
subtilty	13	4	545	3	subtilty
subtlest	10	5	1136	3	subtlest_
subtlety	13	4	506	3	subtlety
subtones	10	3	1138	3	subtones
subtracts	13	4	636	3	subtracts
subtrends	12	4	406	3	subtrends
subtypes	15	4	455	3	subtypes
subunits	10	4	662	3	subunits
subvenes	13	3	963	3	subvenes
subvert	12	3	1289	3	subvert_
suets	5	51	2610	3	su__e_ts
suggests	10	4	471	3	suggests
suiters	7	36	1888	3	suite_rs
suites	6	37	2740	3	suite__s
sunbelts	10	4	467	3	sunbelts
sunkets	11	35	1128	3	sunke_ts
sunsets	7	29	1157	3	sunse_ts
surfeits	11	4	622	3	surfeits
surtaxes	15	3	651	3	surtaxes
surtouts	8	4	620	3	surtouts
suspects	12	5	486	3	suspects
suttees	7	41	1406	3	sutte_es
texts	12	55	1504	3	___texts
urtext	13	3	743	3	_urtext_

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	84	8.253	17710.2
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	8.439	21174.4