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

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

83 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
constraining	15	5	454	(None)
constringing	16	5	356	2	constr_inging
containing	13	4	1093	2	con_t_aining
conscribing	18	5	390	3	conscr_ibing
constrain	11	4	933	3	constra__in_
constrained	14	4	535	3	constrain_ed
constrains	12	4	972	3	constra__ins
constraint	12	4	1113	3	constra__int
constraints	13	4	620	3	constrain_ts
constricting	17	4	702	3	constricting
constructing	17	4	675	3	constructing
construing	13	4	744	3	constr__uing
contracting	16	6	1047	3	con_tracting
contrasting	14	5	935	3	con_trasting
contravening	18	5	356	3	con_travening
contriving	16	4	819	3	con_tr_iving
coxswaining	24	5	186	3	coxs_waining
distraining	13	4	698	3	_distraining
entraining	11	4	764	3	_en_training
mistraining	14	4	650	3	_mistraining
restraining	12	4	753	3	_restraining
straining	10	4	1056	3	___straining
abstaining	13	4	457	4	_abst_aining
bowstringing	19	7	158	4	bowstr_inging
captaining	15	4	607	4	c_apt_aining
castrating	13	4	977	4	c_astra_ting
centralising	15	5	593	4	cen_tralising
centralizing	24	5	805	4	cen_tralizing
cocaptaining	19	10	191	4	cocaptaining
cocktailing	20	5	278	4	cockt_ailing
complaining	18	4	473	4	co_mplaining
concerning	15	4	890	4	concer__ning
concertizing	26	5	563	4	concertizing
confining	15	3	999	4	con___fining
conjoining	20	4	610	4	con__joining
conscripting	19	5	402	4	conscripting
consecrating	17	4	794	4	consecra_ting
conservatizing	29	8	309	4	conservatizing
conserving	16	3	975	4	conser__ving
consigning	14	4	678	4	cons__igning
consociating	17	5	557	4	consociating
consorting	13	4	1074	4	consor__ting
conspiring	15	4	655	4	cons__piring
consternating	16	5	497	4	consternating
constipating	17	7	539	4	constipating
constituting	15	5	465	4	constituting
constrainedly	19	6	157	4	constrainedly
constringe	13	4	585	4	constr_in_ge
constringed	15	4	359	4	constr_inged
constringent	15	9	371	4	constr_ingent
constringes	14	4	504	4	constr_inges
contacting	15	6	1007	4	con_t_acting
contemning	15	7	706	4	con_t_emning
continuing	13	4	819	4	con_t__inuing
contradicting	19	5	407	4	con_tradicting
controlling	14	4	542	4	con_trolling
cornbraiding	18	6	160	4	cornbraiding
cosmolining	16	5	370	4	co_smolining
costarring	13	4	539	4	co_st_arring
curtaining	13	4	553	4	c_urt_aining
destaining	12	6	794	4	_dest_aining
detraining	12	6	767	4	__detraining
distaining	12	4	890	4	_dist_aining
engraining	12	4	522	4	_en_graining
enshrining	14	6	461	4	_enshr_ining
fountaining	15	10	364	4	fount_aining
ingraining	12	4	562	4	_in_graining
inshrining	14	10	458	4	_inshr_ining
obtaining	12	3	677	4	_o_bt_aining
ostracising	14	4	387	4	_o_stracising
ostracizing	23	4	456	4	_o_stracizing
outgaining	12	3	709	4	_o_utgaining
outraising	11	3	990	4	_o_utraising
overstraining	17	5	413	4	overstraining
overtraining	16	4	602	4	overtraining
pretraining	14	4	650	4	_pretraining
retraining	11	3	1024	4	__retraining
spraining	12	4	815	4	___spraining
staining	9	4	1337	4	___st_aining
sustaining	11	4	588	4	_sust_aining
training	9	30	1586	4	____training
unstrapping	16	5	291	4	_unstrapping
unstringing	13	4	402	4	_unstr_inging

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	124790	0.373	479064.3
2	DLD Change Limit	124790	83	6.673	18700.7
3	Display Results	83	83	0.046	1804.3
	(SQL Overall)	178691	83	7.092	25196.1