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

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

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
deferrables	17	5	228	(None)
deferrable	16	4	485	1	deferrable_
deferrals	13	4	368	2	deferra_l_s
deterrable	13	4	572	2	deterrable_
defendable	17	5	498	3	defendable_
deferral	12	4	435	3	deferra_l__
deformable	18	4	419	3	deformable_
delectables	16	14	433	3	delectables
desirables	13	4	421	3	de_sirables
referable	14	3	962	3	refe_rable_
referrals	12	4	350	3	referra_l_s
venerables	15	4	435	3	vene_rables
averrable	14	10	541	4	_averrable_
conferrable	18	4	582	4	conferrable_
deaerates	10	3	1364	4	deae_ra_tes
deceivable	18	4	502	4	deceivable_
declarable	15	4	498	4	declarable_
defeasances	17	5	228	4	defeasances
defeasible	16	4	352	4	defeasible_
defecates	15	3	859	4	defe_ca_tes
defensible	16	4	459	4	defensible_
deferences	16	7	787	4	defe_rences
deferred	13	10	636	4	deferr___ed
deferrer	12	13	559	4	deferr___er
deferrers	13	11	515	4	deferr__ers
definable	15	4	777	4	def_inable_
deflectable	19	4	380	4	deflectable_
defrayable	19	4	325	4	defrayable_
delectable	15	24	738	4	delectable_
delegable	13	13	664	4	dele_gable_
deletable	12	14	950	4	dele_table_
demurrages	14	4	233	4	demurra_ges
demurrals	12	4	302	4	demurra_l_s
denervates	14	4	593	4	denerva_tes
dependable	16	4	579	4	dependable_
deplorable	15	4	507	4	deplorable_
deportable	15	4	565	4	deportable_
desecrates	13	4	884	4	desecra_tes
desirable	12	4	939	4	de_sirable_
detectable	15	13	660	4	detectable_
deterrences	14	5	518	4	deterrences
detestable	13	13	650	4	detestable_
deverbals	15	4	410	4	deverba_l_s
disenables	13	4	623	4	dise_nables
durables	11	23	701	4	d___urables
errable	9	3	1218	4	___errable_
execrable	20	4	623	4	_execrable_
ferrates	11	30	1342	4	__ferra_tes
ferrules	11	3	616	4	__ferr_ules
generable	12	3	866	4	gene_rable_
inerrable	11	4	1016	4	_inerrable_
inferable	14	4	1127	4	infe_rable_
inferrible	15	4	562	4	inferrible_
miserables	14	4	561	4	mise_rables
nondeferrable	19	6	254	4	~~non~~deferrable_
observables	18	5	201	4	observables
penetrable	14	4	604	4	penetrable_
preferable	17	4	672	4	prefe_rable_
receivables	18	5	246	4	receivables
referral	11	4	441	4	referra_l__
reformable	17	4	529	4	reformable_
renewables	15	4	340	4	rene_wables
reservable	15	4	637	4	reservable_
returnables	13	5	212	4	returnables
reverable	14	3	1036	4	reve_rable_
reversibles	16	8	285	4	reversibles
severable	14	3	854	4	seve_rable_
vegetables	16	4	270	4	vege_tables
venerable	14	3	848	4	vene_rable_
wearables	14	15	501	4	__wearables

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	70	8.720	17066.4
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	9.170	19486.5