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

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

77 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
subcastes	13	8	749	(None)
subcaste	12	8	785	1	subcaste_
outcastes	11	11	891	2	outcastes
subbases	12	3	906	2	subbas_es
subbasses	13	4	522	2	subbasses
subcauses	13	4	621	2	subcauses
subclasses	14	4	474	2	subclasses
subcutes	12	3	858	2	subc_utes
sublates	10	3	1500	2	subla_tes
bastes	8	53	3038	3	__b_astes
castes	8	56	3186	3	___castes
furcates	13	3	988	3	furca_tes
nutcases	10	8	579	3	nutcas_es
outcaste	10	11	961	3	outcaste_
outcasts	10	10	868	3	outcast_s
outwastes	12	12	769	3	outwastes
rubasses	10	3	549	3	rub_asses
subacute	12	4	575	3	subacute_
subbase	11	3	932	3	subbas_e_
subbasins	13	4	476	3	subbasins
subbass	11	3	803	3	subbas__s
subcause	12	6	582	3	subcause_
subcavities	18	5	448	3	subcavities
subcenter	13	4	707	3	subcenter
subcenters	14	4	616	3	subcenters
subchapter	19	5	237	3	subchapter
subchapters	20	5	204	3	subchapters
subchaser	16	4	431	3	subchas_er
subchasers	17	4	328	3	subchasers
subclass	12	4	662	3	subclas__s
subclassed	15	4	371	3	subclassed
subclauses	14	5	388	3	subclauses
subcluster	14	4	314	3	subcluster
subclusters	15	5	265	3	subclusters
subcodes	13	3	814	3	subc_odes
subcortex	20	4	375	3	subcortex
subcostal	13	4	456	3	subcostal
subcostals	14	5	343	3	subcostals
subcults	12	4	693	3	subcult_s
subcutis	12	4	629	3	subc_utis
sublate	9	3	1536	3	subla_te_
sublated	11	3	1150	3	subla_ted
subleases	11	4	865	3	subleas_es
subparts	12	4	690	3	subpart_s
subphases	16	4	576	3	subphas_es
subraces	12	3	1303	3	subra_ces
subsales	10	3	1012	3	subsa_les
subscales	13	4	734	3	subsca_les
subsets	9	28	1310	3	sub__sets
subsisted	12	4	578	3	subsisted
subsister	11	4	598	3	subsister
subsisters	12	4	502	3	subsisters
subsists	10	3	799	3	subsist_s
subsites	10	3	1278	3	sub_sites
substates	11	14	1033	3	substates
subsystem	16	5	239	3	subsystem
subsystems	17	5	183	3	subsystems
subtasks	14	4	449	3	subtas_ks
subtests	10	3	753	3	subtest_s
successes	13	4	564	3	successes
succusses	13	4	442	3	succusses
sucrases	10	3	1025	3	sucras_es
suitcases	11	4	445	3	suitcas_es
sulcate	9	3	1442	3	sulca_te_
sulcated	11	3	1037	3	sulca_ted
sulfates	11	3	1079	3	sulfa_tes
summates	12	26	1049	3	summa_tes
surbases	10	3	1000	3	surbas_es
surceases	11	5	747	3	surceas_es
suricates	11	3	1174	3	surica_tes
surpasses	11	4	553	3	surpasses
uncases	9	35	1655	3	_uncas_es
upcasts	11	18	564	3	_upcast_s
webcasted	17	4	197	3	webcasted
webcaster	16	4	238	3	webcaster
webcasters	17	4	214	3	webcasters
webcasts	15	4	331	3	webcast_s

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	148641	0.423	422437.4
2	DLD Change Limit	148641	77	7.453	19943.8
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	7.906	22601.9