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

Here are the results of your fuzzy-string dictionary search for “treasurable” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

102 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
treasurable	13	4	361	(None)
measurable	14	4	472	2	_measurable
pleasurable	15	5	241	2	pleasurable
treasonable	13	5	319	2	treasonable
censurable	14	4	565	3	_censurable
immeasurable	18	5	236	3	immeasurable
measurably	17	4	361	3	_measurably
mensurable	14	4	545	3	_mensurable
pleasurably	18	5	194	3	pleasurably
presumable	16	4	520	3	pre_sumable
reasonable	12	4	628	3	_reasonable
resumable	13	4	755	3	_re_sumable
tearable	10	15	1267	3	t_ea__rable
teasable	10	15	1117	3	t_eas__able
tenurable	11	4	742	3	t_e_nurable
treasonably	16	5	264	3	treasonably
treasure	8	4	675	3	treasur___e
treatable	11	3	932	3	trea__table
triturable	12	4	376	3	tr_iturable
unmeasurable	16	5	385	3	unmeasurable
assurable	11	4	601	4	__assurable
bearable	12	15	1236	4	_bea__rable
breakable	17	4	616	4	brea__kable
breathable	17	4	414	4	brea_thable
clearable	13	4	601	4	clea__rable
creatable	13	3	956	4	crea__table
creatural	11	4	490	4	creatura_l_
desirable	12	4	939	4	_de_sirable
endurable	12	4	773	4	__endurable
erasable	10	5	1104	4	er_as__able
graspable	14	4	487	4	gr_as_pable
hearable	13	16	1160	4	_hea__rable
immeasurably	21	6	231	4	immeasurably
immensurable	18	5	260	4	immensurable
insurable	11	10	1109	4	__insurable
leasable	10	15	1013	4	_leas__able
nonmeasurable	17	6	274	4	nonmeasurable
perdurable	15	4	475	4	_perdurable
preferable	17	4	672	4	pre_ferable
preservable	18	4	417	4	pre_servable
presumably	19	5	388	4	pre_sumably
procurable	16	4	486	4	pr_ocurable
reachable	16	12	965	4	_rea_chable
readable	11	3	1316	4	_rea__dable
realizable	21	4	533	4	_realizable
reapable	12	3	1139	4	_rea__pable
reasonably	15	4	457	4	_reasonably
reassemble	14	5	367	4	_reassemble
reassurance	13	14	276	4	_reassurance
recoupable	16	4	502	4	_recoupable
referable	14	3	962	4	_re_ferable
refusable	14	7	668	4	_re_fusable
refutable	14	7	786	4	_re_futable
registrable	14	5	293	4	_registrable
regulable	12	4	651	4	_re_gulable
renderable	13	9	715	4	_renderable
repairable	14	4	595	4	_repairable
reparable	13	5	995	4	_re_parable
reputable	13	7	912	4	_re_putable
resalable	11	3	873	4	_re_salable
rescuable	13	4	758	4	_re_scuable
reservable	15	4	637	4	_re_servable
respirable	14	4	602	4	_respirable
restable	10	16	1844	4	_re_s_table
restorable	12	4	675	4	_restorable
returnable	12	4	479	4	_re_turnable
reusable	10	8	1127	4	_re__usable
reverable	14	3	1036	4	_re_verable
saturable	11	4	663	4	__saturable
seasonable	12	4	493	4	_seasonable
securable	13	4	777	4	_se_curable
tabulable	13	4	404	4	t__abulable
tastable	10	15	1197	4	t__as_table
tasteable	11	4	612	4	t__asteable
teachable	16	13	760	4	t_ea_chable
temperable	16	4	581	4	t_emperable
testable	10	14	1262	4	t_e_s_table
thesaural	12	5	247	4	thesaura_l_
traceable	13	3	832	4	tr_a_ceable
trackable	17	3	674	4	tr_a_ckable
tractable	13	3	851	4	tr_a_ctable
tradable	11	3	987	4	tr_a__dable
tradeable	12	4	741	4	tr_a_deable
trailerable	13	5	282	4	trailerable
trainable	11	3	894	4	tr_a_inable
transferable	17	5	379	4	transferable
transfusable	17	5	242	4	transfusable
transmutable	16	5	301	4	transmutable
traversable	16	5	281	4	tr_aversable
treasured	10	4	498	4	treasur__ed
treasurer	9	4	425	4	treasur__er
treasurers	10	4	320	4	treasur_ers
treasures	9	4	663	4	treasur__es
treasuries	10	4	554	4	treasur_ies
treasuring	11	4	470	4	treasur_ing
treasury	11	4	379	4	treasur___y
tressure	8	4	648	4	tressur___e
trustable	11	4	712	4	tr_us_table
unendurable	14	5	428	4	unendurable
uninsurable	13	8	497	4	uninsurable
unreasonable	14	5	473	4	unreasonable
wearable	13	15	1055	4	_wea__rable

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	102	9.296	16008.9
3	Display Results	102	102	0.046	2217.4
	(SQL Overall)	178691	102	9.762	18304.8