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

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

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.

79 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
subculture	14	5	442	(None)
subcultured	16	6	326	1	subcultured
subcultures	15	5	458	1	subcultures
subcultural	15	5	371	2	subcultural
apiculture	14	13	457	3	apiculture
aquaculture	22	14	272	3	aquaculture
aquiculture	22	14	372	3	aquiculture
aviculture	15	14	458	3	aviculture
coculture	13	4	544	3	_coculture
culture	9	3	939	3	___culture
musculature	15	5	269	3	musculature
sculpture	13	4	374	3	s__culpture
sepulture	11	4	347	3	s_epulture
sericulture	13	6	463	3	sericulture
subclause	13	5	384	3	subc_lause
subcult	11	4	960	3	subcult___
subcults	12	4	692	3	subcult__s
subculturing	17	5	195	3	subculturing
tubulure	10	4	276	3	tub_ul_ure
uncultured	13	4	467	3	_uncultured
agriculture	14	5	404	4	agriculture
apicultures	15	13	491	4	apicultures
aquacultures	23	15	301	4	aquacultures
aquicultures	23	16	409	4	aquicultures
auscultate	12	5	310	4	auscultate
avicultures	16	15	499	4	avicultures
cocultured	15	4	395	4	_cocultured
cocultures	14	4	571	4	_cocultures
cubature	12	4	468	4	cub__ature
cultured	11	3	723	4	___cultured
cultures	10	3	1014	4	___cultures
juncture	17	4	390	4	junc__ture
mariculture	15	5	468	4	mariculture
monoculture	15	5	359	4	monoculture
multure	9	3	918	4	___multure
musculatures	16	5	226	4	musculatures
nunciature	12	5	283	4	nunciature
pisciculture	18	6	250	4	pisciculture
puncture	12	4	505	4	punc__ture
sculptured	15	4	274	4	s__culptured
sculptures	14	4	384	4	s__culptures
sepultures	12	4	383	4	s_epultures
sericultures	14	7	487	4	sericultures
silviculture	17	6	280	4	silviculture
structure	11	4	524	4	s_tructure
subacute	12	4	575	4	subacu_t__e
subaltern	11	4	324	4	sub_altern
subcaste	12	8	785	4	subcast__e
subcause	12	6	582	4	subc__ause
subcellar	13	4	363	4	subcellar_
subcellars	14	5	285	4	subcellars
subcenter	13	4	706	4	subcenter_
subcenters	14	4	615	4	subcenters
subclauses	14	5	387	4	subc_lauses
subclerk	16	4	379	4	subc_l_erk
subcluster	14	4	313	4	subcluster_
subclustered	17	5	122	4	subclustered
subclusters	15	5	264	4	subclusters
subcollege	15	5	251	4	subcollege
subculturally	20	7	210	4	subcultur~~all~~y
subcurative	18	5	440	4	subcurative
subcutes	12	3	857	4	subcu_t_es
subcutis	12	4	628	4	subcu_t_is
subcutises	14	4	461	4	subcu_tises
submultiple	17	6	119	4	submultiple
subrule	9	3	964	4	subrul___e
subseizure	21	5	176	4	subseizure
substitute	12	5	460	4	substitute
substructure	16	6	310	4	substructure
subulate	10	3	1274	4	sub_ul_ate
succulence	13	5	263	4	succulence
surculose	11	4	377	4	surcul_ose
suture	6	3	1320	4	s___u_ture
sylviculture	20	6	229	4	sylviculture
tubulures	11	4	261	4	tub_ul_ures
vasculature	16	8	268	4	vasculature
viniculture	16	5	366	4	viniculture
viticulture	16	5	368	4	viticulture
vulture	10	3	676	4	___vulture

Search took 10 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	161450	0.170	1051123.5
2	DLD Change Limit	161450	79	9.546	16912.8
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	9.762	18304.8