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

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

54 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
expendables	23	5	215	(None)
expendable	22	4	387	1	expendable_
expandable	22	4	312	2	expandable_
extendable	20	4	383	2	extendable_
dependable	16	4	579	3	dependable_
emendable	14	4	623	3	e_mendable_
expectable	23	4	506	3	expectable_
expellable	21	4	321	3	expellable_
extendible	20	5	295	3	extendible_
spendable	14	4	646	3	_spendable_
vendables	15	16	515	3	__vendables
amendable	14	4	605	4	_amendable_
appendages	16	5	324	4	appenda_ges
ascendable	15	4	398	4	ascendable_
bendable	13	15	1085	4	__bendable_
defendable	17	5	498	4	defendable_
dependably	19	5	454	4	dependabl_y
dependances	17	5	485	4	dependances
disenables	13	4	623	4	disen_ables
emendates	12	4	607	4	e_menda_tes
empennages	15	4	186	4	empenna_ges
employables	20	5	163	4	employables
enables	9	28	1312	4	___en_ables
excludable	22	5	254	4	excludable_
execrable	20	4	623	4	ex_ecrable_
expansible	21	5	355	4	expansible_
expectably	26	5	422	4	expectabl_y
expectances	24	9	334	4	expectances
expedites	19	4	616	4	expe_d_ites
expendabilities	27	7	437	4	expendabil~~iti~~es
expendability	28	5	384	4	expendability
expended	19	13	654	4	expend___ed
expender	18	13	684	4	expend___er
expenders	19	14	596	4	expend__ers
expenditures	22	14	120	4	expenditures
expends	17	21	708	4	expend____s
expenses	17	13	837	4	expen___ses
expiable	19	4	611	4	exp__iable_
explicable	23	4	434	4	explicable_
exportable	21	4	460	4	exportable_
exposable	20	4	479	4	exp_osable_
extensible	19	5	401	4	extensible_
extenuates	17	4	447	4	extenua_tes
extrudable	20	7	308	4	extrudable_
lendable	11	16	946	4	__lendable_
mendable	13	15	1058	4	__mendable_
nonexpendable	25	6	178	4	~~non~~expendable_
openable	12	4	701	4	_open_able_
pentacles	13	3	877	4	__pentacles
respectables	18	7	303	4	respectables
sendable	11	16	1204	4	__sendable_
unbendable	15	4	581	4	unbendable_
vendable	14	15	969	4	__vendable_
vendibles	15	16	458	4	__vendibles

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	54	8.893	16734.4
3	Display Results	54	54	0.030	1800.0
	(SQL Overall)	178691	54	9.343	19125.7