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

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

78 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
curtained	12	6	550	(None)
curtailed	12	4	411	1	curtailed
captained	14	4	619	2	captained
certainer	11	4	619	2	certainer
contained	12	3	1089	2	contained
curtailer	11	4	382	2	curtailer
curtain	9	31	979	2	curtain__
curtains	10	25	970	2	curtain_s
curtsied	11	3	495	2	curtsi_ed
pertained	12	3	849	2	pertained
sustained	10	4	537	2	sustained
uncurtained	14	5	298	2	uncurtained
abstained	12	4	505	3	abstained
ascertained	14	5	229	3	ascertained
attained	9	9	735	3	_attained
bargained	13	4	495	3	bargained
brained	10	38	1610	3	_br_ained
burthened	15	4	396	3	burthened
caftaned	14	4	509	3	cafta_ned
cartoned	11	13	1283	3	cart_oned
cartooned	12	4	631	3	cartooned
certain	9	26	1221	3	certain__
certainest	12	4	886	3	certainest
certainly	14	4	315	3	certainly
certainty	14	4	319	3	certainty
chained	13	38	1269	3	c__hained
container	11	3	1107	3	container
craned	9	61	2165	3	c_r_a_ned
curarine	10	6	1070	3	curarine_
curarines	11	7	1054	3	curarines
curarized	21	7	640	3	curarized
curated	10	47	1758	3	cur_a_ted
curating	11	3	1429	3	curatin_g
curative	13	3	1040	3	curative_
curatives	14	3	782	3	curatives
curried	10	33	1365	3	cur_ri_ed
curtail	9	29	966	3	curtai__l
curtailers	12	4	340	3	curtailers
curtails	10	31	824	3	curtai_ls
curtaining	13	4	553	3	curtaining
curtainless	13	5	193	3	curtainless
curtate	9	3	1264	3	curta_te_
curtseyed	15	5	192	3	curtseyed
curtsies	10	3	873	3	curtsi_es
cutline	9	29	1454	3	cu_tline_
cutlines	10	24	1327	3	cu_tlines
destained	11	5	825	3	destained
detained	10	31	1164	3	_detained
detrained	11	5	891	3	detrained
distained	11	3	959	3	distained
drained	9	37	1325	3	_dr_ained
entrained	10	8	941	3	entrained
fountained	14	4	332	3	fountained
grained	9	38	1427	3	_gr_ained
mutined	10	33	1135	3	mu_t_ined
obtained	11	3	653	3	_obtained
ordained	10	3	517	3	_ordained
outgained	11	3	722	3	outgained
outlined	9	25	1295	3	ou_tlined
outraised	10	3	924	3	outraised
purloined	12	4	370	3	purloined
rained	7	50	2460	3	__r_ained
retained	9	30	1609	3	_retained
retrained	10	4	1131	3	retrained
sprained	11	3	843	3	spr_ained
stained	8	42	1534	3	__stained
strained	9	4	1225	3	str_ained
suntanned	10	4	401	3	suntanned
surtaxed	16	4	413	3	surta_xed
sustainer	9	4	478	3	sustainer
trained	8	41	1720	3	_tr_ained
turbaned	11	4	562	3	turba_ned
turbanned	12	4	299	3	turbanned
unstained	10	3	867	3	unstained
untainted	10	3	842	3	_untainted
untanned	9	27	996	3	_untanned
untrained	10	5	1099	3	_untrained
untwined	12	3	706	3	_untwined

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	148641	0.156	1145455.1
2	DLD Change Limit	148641	78	7.266	20457.1
3	Display Results	78	78	0.076	1026.3
	(SQL Overall)	178691	78	7.498	23831.8