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

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

85 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
subscripts	16	5	323	(None)
subscript	15	4	466	1	subscript_
subscribes	16	4	487	2	subscribes
adscripts	14	4	232	3	_adscripts
conscripts	16	4	459	3	conscripts
coscripts	15	4	377	3	_coscripts
prescripts	16	4	474	3	prescripts
rescripts	13	7	457	3	_rescripts
scripts	11	50	937	3	___scripts
subscribe	15	5	500	3	subscri_be
subscribed	17	4	382	3	subscribed
subscriber	16	4	365	3	subscriber
subscribers	17	5	261	3	subscribers
subscription	18	5	312	3	subscription
subscriptions	19	5	282	3	subscript~~ion~~s
subseries	11	3	1293	3	subseri_es
subsists	10	3	799	3	subs__ists
superscripts	18	6	430	3	superscripts
abstricts	13	5	518	4	_abstricts
adscript	13	4	420	4	_adscript_
conscript	15	4	712	4	conscript_
coscript	14	5	663	4	_coscript_
manuscripts	17	5	140	4	manuscripts
outsprints	12	4	357	4	outsprints
outstrips	11	4	520	4	outstrip_s
postscripts	17	10	209	4	postscripts
prescript	15	4	703	4	prescript_
putschists	17	5	254	4	putschists
rescript	12	7	742	4	_rescript_
sacrists	10	3	956	4	s__acrists
scrips	10	53	1603	4	___scrip_s
script	10	57	1790	4	___script_
subacrid	13	5	464	4	subacri__d
subchiefs	19	4	274	4	sub_chiefs
subcults	12	4	693	4	sub_c_ults
subdistricts	17	6	170	4	subdistricts
subedits	11	4	671	4	sub_edi_ts
suberins	10	3	1509	4	sub_eri_ns
suberises	11	8	1345	4	sub_erises
suberizes	20	8	1183	4	sub_erizes
subgraphs	17	4	373	4	sub_graphs
sublimits	13	4	556	4	sublimi_ts
submarines	14	4	691	4	submarines
submarkets	18	12	315	4	submarkets
submits	11	3	975	4	sub__mi_ts
suboscines	14	4	496	4	subosc_ines
subparts	12	4	690	4	subpar__ts
subperiods	15	4	460	4	subperiods
subrents	10	3	1029	4	sub__rents
subrings	11	22	988	4	sub__rings
subscales	13	4	734	4	subsc_ales
subscribing	18	5	324	4	subscribing
subsections	15	9	710	4	subsections
subsects	12	26	790	4	subs__ects
subseres	10	3	1242	4	subser__es
subserves	14	4	718	4	subser_ves
subsets	9	28	1310	4	subs___ets
subshafts	17	4	309	4	subs_hafts
subshrubs	16	5	201	4	subshr_ubs
subsides	11	4	1082	4	subs__ides
subsidies	12	4	842	4	subsidi_es
subsidises	13	4	512	4	subsidises
subsidizes	22	4	508	4	subsidizes
subsist	9	3	1157	4	subs__ist_
subsite	9	4	1287	4	subs__i_te
subsites	10	3	1278	4	subs__ites
subskills	15	4	377	4	subs_kills
subsociety	17	5	275	4	subsociety
subsoils	10	7	665	4	subs_oi_ls
substrata	11	18	491	4	substr_ata
substrate	11	17	879	4	substr_ate
substrates	12	16	855	4	substrates
subtracts	13	4	636	4	sub_tracts
subtribes	13	4	623	4	sub_tribes
subunits	10	4	662	4	sub_uni_ts
subvariety	18	5	262	4	subvariety
subverts	13	3	697	4	subver__ts
summarists	14	10	470	4	summarists
sunscreens	12	5	209	4	sunscreens
sunsuits	8	4	596	4	suns_ui_ts
superscript	17	8	583	4	superscript_
surprints	11	4	528	4	su_rprints
transcripts	15	5	443	4	transcripts
typescripts	20	8	136	4	typescripts
unscripted	15	4	463	4	_unscripted

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.423	422437.4
2	DLD Change Limit	161450	85	9.390	17193.8
3	Display Results	85	85	0.033	2575.8
	(SQL Overall)	178691	85	9.846	18148.6