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

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

71 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
subplots	12	5	577	(None)
sublots	9	24	1091	1	sub_lots
subplot	11	5	813	1	subplot_
outplots	10	8	636	2	outplots
sublets	9	26	1670	2	sub_lets
sublot	8	23	1552	2	sub_lot_
subparts	12	4	690	2	subparts
bibelots	12	9	513	3	bibelots
blots	7	56	2617	3	__b_lots
complots	14	3	816	3	complots
coplots	11	5	1159	3	_coplots
marplots	12	4	563	3	marplots
nubilous	10	4	484	3	nubilous
outplods	11	10	561	3	outplods
outplot	9	10	948	3	outplot_
plots	7	50	2567	3	___plots
replots	9	34	1263	3	_replots
sabots	8	3	1470	3	sab__ots
sabulous	10	4	612	3	sabulous
sandlots	9	3	829	3	sandlots
sexpots	16	3	629	3	sexp_ots
shallots	11	31	950	3	shallots
slots	5	48	3053	3	s___lots
splats	8	48	1730	3	s__plats
splits	8	54	1641	3	s__plits
spots	7	44	2411	3	s__p_ots
subabbots	12	4	187	3	subabbots
subatoms	12	4	588	3	subatoms
subblock	18	4	367	3	subblock
subblocks	19	4	300	3	subblocks
subclans	12	4	741	3	subclans
subclass	12	4	662	3	subclass
subcools	12	4	575	3	subcools
subcults	12	4	693	3	subcults
subdepots	14	4	316	3	subdepots
subducts	13	10	609	3	subducts
subedits	11	4	671	3	subedits
suberous	10	3	1179	3	suberous
subfloor	13	12	290	3	subfloor
subfloors	14	11	261	3	subfloors
subjects	19	22	653	3	subjects
sublate	9	3	1536	3	sub_late
sublates	10	3	1500	3	sub_lates
sublet	8	28	2724	3	sub_let_
submits	11	3	975	3	sub_mits
subnets	9	25	1208	3	sub_nets
subpart	11	3	1112	3	subpart_
subpenas	12	4	690	3	subpenas
subpolar	12	4	518	3	subpolar
subrents	10	3	1029	3	subrents
subsects	12	26	790	3	subsects
subsets	9	28	1310	3	sub_sets
subsists	10	3	799	3	subsists
subtests	10	3	753	3	subtests
subtexts	17	4	490	3	subtexts
subtlest	10	5	1136	3	subtlest
subtlety	13	4	506	3	subtlety
subulate	10	3	1274	3	subulate
subunits	10	4	662	3	subunits
subverts	13	3	697	3	subverts
sunbelts	10	4	467	3	sunbel_ts
sunglows	12	4	408	3	sunglows
sunspots	10	4	508	3	sunspots
supplants	13	4	487	3	supplants
supples	11	5	1128	3	suppl_es
supplest	12	4	894	3	supplest
supplies	12	6	883	3	supplies
supports	12	4	651	3	supports
surplus	9	3	679	3	surpl_us
suspects	12	5	486	3	suspects
tubulous	10	4	537	3	tubulous

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	71	6.220	23498.7
3	Display Results	71	71	0.016	4437.5
	(SQL Overall)	178691	71	6.642	26903.2