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

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

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
subscribers	17	5	261	(None)
subscriber	16	4	365	1	subscriber_
subscribes	16	4	487	1	subscribe_s
subscribe	15	5	500	2	subscribe__
subscribed	17	4	382	2	subscribe_d
describers	15	4	358	3	_describers
inscribers	14	4	264	3	_inscribers
prescribers	17	9	315	3	prescribers
proscribers	17	11	253	3	proscribers
scribers	12	30	796	3	___scribers
submariners	15	5	322	3	submariners
subscribing	18	5	324	3	subscribing
subscripts	16	5	323	3	subscri_pts
subseries	11	3	1293	3	subseri_e_s
subsiders	12	4	605	3	subs__iders
subsidizers	23	5	288	3	subsidizers
subsoilers	12	4	406	3	subs_oilers
subtribes	13	4	623	3	sub_tribe_s
subwriters	15	4	441	3	sub_writers
absorbers	13	5	398	4	_absor_bers
ascribes	12	4	619	4	__ascribe_s
bribers	11	41	1150	4	__b__ribers
conscribes	16	4	519	4	conscribe_s
describer	14	4	461	4	_describer_
describes	14	4	600	4	_describe_s
descriers	12	4	569	4	_descri_ers
inscriber	13	4	386	4	_inscriber_
inscribes	13	4	520	4	_inscribe_s
prescriber	16	8	488	4	prescriber_
prescribes	16	10	628	4	prescribe_s
proscriber	16	10	372	4	proscriber_
proscribes	16	12	535	4	proscribe_s
scriber	11	39	1097	4	___scriber_
scribes	11	37	1320	4	___scribe_s
skyscrapers	22	5	65	4	skyscrapers
subcenters	14	4	616	4	sub_centers
subchasers	17	4	328	4	sub_chasers
subchiefs	19	4	274	4	sub_chi_efs
subdividers	18	5	157	4	subdividers
suberises	11	8	1345	4	sub_erise_s
suberizes	20	8	1183	4	sub_erize_s
sublimers	13	4	577	4	sub__limers
submariner	14	4	407	4	submariner_
submarines	14	4	691	4	submarine_s
suborders	12	4	550	4	sub_or_ders
suborners	11	4	631	4	sub_or_ners
suboscines	14	4	496	4	subosc_ine_s
subscales	13	4	734	4	subsc_ale_s
subscript	15	4	466	4	subscri__pt
subseres	10	3	1242	4	subser__e_s
subserves	14	4	718	4	subser_ve_s
subshrubs	16	5	201	4	subshrub__s
subsider	11	3	824	4	subs__ider_
subsides	11	4	1082	4	subs__ide_s
subsidies	12	4	842	4	subsidi_e_s
subsidises	13	4	512	4	subsidise_s
subsidizer	22	5	399	4	subsidizer_
subsidizes	22	4	508	4	subsidize_s
subsisters	12	4	502	4	subs_isters
subsites	10	3	1278	4	subs__ite_s
subsoiler	11	4	532	4	subs_oiler_
substrates	12	16	855	4	substrate_s
subtribe	12	4	646	4	sub_tribe__
subverters	15	4	461	4	subver_ters
subwriter	14	4	562	4	sub_writer_
summarizers	24	13	282	4	summarizers
sunscreens	12	5	209	4	sunscr_eens
superscribes	18	5	514	4	superscribe_s
surprisers	12	4	363	4	su_rprisers
sustainers	10	4	413	4	su_stainers
transcribers	16	5	326	4	transcribers

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	148819	0.420	425454.8
2	DLD Change Limit	148819	71	8.673	17158.9
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	9.123	19586.9