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

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

69 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
subtilty	13	4	545	(None)
subtility	14	4	660	1	subtility
subtile	9	19	1262	2	subtil_e
subtilely	14	4	495	2	subtilely
subtiler	10	20	857	2	subtiler
subtilin	10	4	712	2	subtilin
subtitle	10	4	660	2	subtitle
subtlety	13	4	506	2	subtlety
subtly	11	24	926	2	subt_l_y
dubiety	13	4	459	3	dub_iety
ductility	15	4	485	3	ductility
dustily	11	32	1153	3	dustil_y
fustily	13	31	1138	3	fustil_y
futility	14	4	698	3	fu_tility
guilty	10	41	823	3	gu__ilty
gustily	11	30	1090	3	gustil_y
lustily	10	36	1124	3	lustil_y
mustily	12	36	1363	3	mustil_y
nubility	13	4	779	3	nub_ility
nuttily	10	30	863	3	nuttil_y
rustily	10	31	1299	3	rustil_y
ruttily	10	33	861	3	ruttil_y
saltily	10	3	1054	3	saltil_y
satiety	10	3	820	3	s_atiety
sectility	14	4	737	3	sectility
silty	8	47	2163	3	s___ilty
smuttily	13	4	427	3	smuttil_y
sobriety	13	4	390	3	sobriety
sootily	10	18	1052	3	sootil_y
stilly	9	37	1409	3	s__tilly
stilt	5	48	3198	3	s__tilt_
stilts	6	79	1531	3	s__tilts
stubbily	15	6	424	3	stubbil_y
suability	14	4	859	3	suability
suavity	13	3	632	3	suavi_ty
subcult	11	4	960	3	subcult_
subcults	12	4	693	3	subcults
subfile	12	20	1050	3	subfil_e
subfiles	13	17	1072	3	subfiles
subito	8	4	1045	3	sub_i_to
sublimity	16	4	493	3	sublimity
submit	10	3	1267	3	submi_t_
submits	11	3	975	3	submi_ts
subsidy	13	4	597	3	subsi_dy
subsist	9	3	1157	3	subsist_
subsists	10	3	799	3	subsists
subsite	9	4	1287	3	subsi_te
subtest	9	5	1396	3	subtest_
subtests	10	3	753	3	subtests
subtext	16	4	765	3	subtext_
subtexts	17	4	490	3	subtexts
subtilest	11	4	881	3	subtilest
subtilins	11	4	717	3	subtilins
subtilize	20	8	713	3	subtilize
subtilties	12	4	611	3	subtilties
subtitled	12	4	471	3	subtitled
subtitles	11	5	685	3	subtitles
subtle	8	21	1343	3	subt_l_e
subtler	9	29	1084	3	subt_ler
sulkily	14	21	811	3	sulkil_y
sultrily	11	4	649	3	sultril_y
sunnily	10	3	783	3	sunnil_y
surlily	10	3	1000	3	surlil_y
surtitle	8	4	528	3	surtitle
tuftily	13	3	557	3	tuftil_y
ubiety	11	3	591	3	_ub_iety
uptilt	8	4	1080	3	_uptilt_
uptilts	9	3	473	3	_uptilts
utility	10	3	871	3	_u_tility

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	146162	0.420	425454.8
2	DLD Change Limit	146162	69	7.093	20606.5
3	Display Results	69	69	0.033	2090.9
	(SQL Overall)	178691	69	7.546	23680.2