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

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

70 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
subserve	13	4	646	(None)
subsere	9	3	1144	1	subser_e
subserved	15	4	514	1	subserved
subserves	14	4	718	1	subserves
observe	12	4	532	2	_observe
outserve	11	15	720	2	outserve
submerge	13	4	551	2	submerge
submerse	12	3	763	2	submerse
subsense	10	4	696	2	subsense
subseres	10	3	1242	2	subseres
subseries	11	3	1293	2	subseries
auberge	10	4	563	3	aub_erge
conserve	13	3	992	3	conserve
deserve	11	10	870	3	_deserve
disserve	12	8	744	3	disserve
observed	14	4	437	3	_observed
observer	13	4	472	3	_observer
observes	13	4	616	3	_observes
outserved	13	13	646	3	outserved
outserves	12	14	737	3	outserves
preserve	13	10	880	3	preserve
reobserve	14	4	246	3	reobserve
reserve	10	10	1120	3	_reserve
serve	8	54	2596	3	___serve
suasive	10	3	785	3	suas_ive
suber	7	49	2450	3	sub_er__
suberic	11	3	1221	3	sub_eric
suberin	9	3	1456	3	sub_erin
suberise	10	8	1393	3	sub_erise
suberize	19	8	1215	3	sub_erize
suberose	10	10	969	3	sub_erose
subers	8	57	2264	3	sub_er_s
subgenre	11	4	487	3	subgenre
sublease	10	3	838	3	sublease
sublevel	13	8	478	3	suble_vel
submerged	15	4	460	3	submerged
submerges	14	4	628	3	submerges
submersed	14	4	586	3	submersed
submerses	13	4	800	3	submerses
subsale	9	3	1054	3	subs_ale
subscale	12	4	760	3	subscale
subscribe	15	5	500	3	subscribe
subsea	8	26	1019	3	subse__a
subsect	11	26	1184	3	subse_ct
subsects	12	26	790	3	subsects
subsenses	11	4	747	3	subsenses
subservient	16	5	423	3	subservient
subserving	16	4	496	3	subserving
subset	8	31	2258	3	subse__t
subsets	9	28	1310	3	subse_ts
subshrub	15	4	236	3	subshrub
subside	10	4	1045	3	subs_ide
subsite	9	4	1287	3	subs_ite
subspace	14	4	568	3	subspace
substage	11	11	718	3	substage
substate	10	17	1109	3	substate
substrate	11	17	879	3	substrate
subsume	11	4	671	3	subs_ume
subvene	12	3	849	3	subve_ne
subversive	18	4	400	3	subversive
subvert	12	3	1289	3	subver_t
subverted	15	4	544	3	subverted
subverter	14	4	527	3	subverter
subverts	13	3	697	3	subverts
subzero	18	3	561	3	subzer_o
sudser	7	35	1128	3	sudser__
sudsers	8	33	1042	3	sudser_s
swerve	12	5	629	3	s__werve
unnerve	10	6	665	3	_unnerve
unserved	12	4	1023	3	_unserved

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.406	440125.6
2	DLD Change Limit	146162	70	6.626	22058.9
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	7.062	25303.2