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

Here are the results of your fuzzy-string dictionary search for “subtitle” 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
subtitle	10	4	660	(None)
subtile	9	19	1262	1	subti_le
subtitled	12	4	471	1	subtitled
subtitles	11	5	685	1	subtitles
surtitle	8	4	528	1	surtitle
subfile	12	20	1050	2	subfi_le
subsite	9	4	1287	2	subsit_e
subtiler	10	20	857	2	subti_ler
subtilty	13	4	545	2	subtilty
subtle	8	21	1343	2	sub__tle
surtitles	9	4	563	2	surtitles
cubicle	13	3	700	3	cub_icle
cuittle	9	4	640	3	cuit_tle
cuticle	11	3	823	3	cu_ticle
cuttle	8	41	1389	3	cu_t_tle
ductile	10	4	848	3	ducti_le
entitle	7	6	1029	3	_entitle
futile	9	39	1495	3	fu_ti_le
guttle	7	41	1197	3	gu_t_tle
intitle	7	6	1058	3	_intitle
jubile	15	29	1026	3	jub_i_le
mistitle	10	3	852	3	mistitle
multiple	12	11	830	3	multiple
nontitle	8	4	694	3	nontitle
nubile	8	32	1271	3	nub_i_le
retitle	7	39	1309	3	_retitle
rutile	6	52	1768	3	ru_ti_le
scuttle	9	3	646	3	scut_tle
sectile	9	3	1197	3	secti_le
settle	6	39	1566	3	s_et_tle
sextile	14	3	857	3	sexti_le
shuttle	10	4	610	3	shut_tle
skittle	11	3	553	3	skit_tle
spittle	9	3	792	3	spit_tle
stifle	9	36	1190	3	s__tifle
stile	5	49	3157	3	s__ti_le
subfield	14	4	475	3	subfield
subfiles	13	17	1072	3	subfi_les
subitem	11	3	855	3	sub_item
subito	8	4	1045	3	sub_it_o
sublate	9	3	1536	3	sublat_e
sublime	11	3	1036	3	subli_me
subline	9	3	1689	3	subli_ne
submit	10	3	1267	3	submit__
submits	11	3	975	3	submit_s
submitted	14	4	523	3	submitted
submitter	13	4	528	3	submitter
subniche	15	5	425	3	subniche
subrule	9	3	964	3	sub_rule
subsale	9	3	1054	3	sub_sale
subscale	12	4	760	3	subscale
subside	10	4	1045	3	subsi_de
subsites	10	3	1278	3	subsites
substate	10	17	1109	3	substat_e
substitute	12	5	462	3	substitute
subtheme	15	4	433	3	subtheme
subtilely	14	4	495	3	subtilely
subtilest	11	4	881	3	subti_lest
subtilin	10	4	712	3	subtilin
subtilize	20	8	713	3	subtilize
subtilties	12	4	611	3	subtilties
subtitling	13	4	456	3	subtitling
subtler	9	29	1084	3	sub__tler
subtly	11	24	926	3	sub__tly
subtone	9	3	1034	3	subt_one
subtotal	10	4	626	3	subtotal
subtotaled	13	4	318	3	subtotaled
subtotals	11	4	499	3	subtotals
subtribe	12	4	646	3	subtribe
subtype	14	4	420	3	subt_ype
suitable	10	3	1089	3	suitable
suite	5	48	2956	3	su__it_e
sulfite	10	3	1047	3	sulfit_e
suttee	6	37	2154	3	su_t_tee
title	5	47	2107	3	___title
untitled	9	7	876	3	_untitled
utile	5	47	1893	3	_u_ti_le

Search took 7 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.406	440125.6
2	DLD Change Limit	146162	77	6.406	22816.4
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	6.845	26105.3