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

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

82 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
subsiders	12	4	605	(None)
subsider	11	3	824	1	subsider_
subsides	11	4	1082	1	subside_s
outsiders	10	23	666	2	outsiders
subideas	11	4	644	2	sub_ideas
sublimers	13	4	577	2	sublimers
suborders	12	4	550	2	suborders
subside	10	4	1045	2	subside__
subsided	12	5	766	2	subside_d
subsidies	12	4	842	2	subsidies
subsidizers	23	5	288	2	subsidizers
subsisters	12	4	502	2	subsisters
subsites	10	3	1278	2	subsite_s
subsoilers	12	4	406	2	subsoilers
abiders	10	40	1108	3	_ab_iders
biders	9	48	2280	3	__b_iders
considers	12	3	893	3	considers
curbsides	14	4	448	3	curbside_s
fubsier	12	36	776	3	fubsi_er_
guiders	9	41	1111	3	gu__iders
insiders	9	4	776	3	_insiders
outriders	10	23	722	3	outriders
outsider	9	26	964	3	outsider_
outsides	9	25	1323	3	outside_s
presiders	12	4	821	3	presiders
residers	9	33	1188	3	_residers
seasides	9	3	874	3	seaside_s
sliders	8	35	1522	3	s__liders
spiders	10	39	1441	3	s__piders
striders	9	44	1212	3	s_triders
subadars	11	12	509	3	sub_adars
subahdars	15	4	229	3	subahdars
subcodes	13	3	814	3	subcode_s
subdebs	12	3	648	3	sub__debs
subdividers	18	5	157	3	subdividers
subduers	11	8	636	3	sub_duers
subers	8	57	2264	3	sub___ers
subfiles	13	17	1072	3	subfile_s
subfixes	20	20	749	3	subfixe_s
subidea	10	3	753	3	sub_ide_a
subitems	12	4	549	3	sub_items
sublimer	12	3	761	3	sublimer_
sublimes	12	3	1003	3	sublime_s
sublines	10	3	1578	3	subline_s
submitters	14	4	444	3	submitters
suborder	11	4	666	3	suborder_
suborners	11	4	631	3	suborners
suboxides	19	4	499	3	suboxide_s
subsales	10	3	1012	3	subsale_s
subscribers	17	5	261	3	subscribers
subsere	9	3	1144	3	subs__ere
subseres	10	3	1242	3	subs__eres
subsets	9	28	1310	3	subs__ets
subsidence	15	5	402	3	subsidence
subsidences	16	5	377	3	subsidences
subsidiary	16	5	298	3	subsidiary
subsiding	13	4	634	3	subsiding
subsidise	12	4	529	3	subsidise
subsidises	13	4	512	3	subsidises
subsidize	21	4	518	3	subsidize
subsidizer	22	5	399	3	subsidizer_
subsidizes	22	4	508	3	subsidizes
subsidy	13	4	597	3	subsid__y
subsister	11	4	598	3	subsister_
subsists	10	3	799	3	subsi_sts
subsite	9	4	1287	3	subsite__
subsoiler	11	4	532	3	subsoiler_
subsumes	12	4	692	3	subsume_s
subtiler	10	20	857	3	subtiler_
subvicars	16	4	383	3	subvicars
subwriters	15	4	441	3	subwriters
sudsers	8	33	1042	3	suds__ers
sudsier	8	6	878	3	sudsi_er_
sufficers	17	20	453	3	sufficers
suicides	11	3	908	3	suicide_s
suiters	7	36	1888	3	su__iters
sulfides	12	3	805	3	sulfide_s
sunders	8	41	2005	3	su__nders
surmisers	11	4	520	3	surmisers
survivers	15	4	388	3	survivers
topsiders	12	4	302	3	topsiders
upsides	10	31	963	3	_upside_s

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	148641	0.436	409841.7
2	DLD Change Limit	148641	82	7.000	21234.4
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	7.469	23924.4