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

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

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
restretching	18	5	289	(None)
resketching	21	4	227	2	res_ketching
restitching	17	4	400	2	rest_itching
retrenching	17	4	391	2	re_trenching
stretching	16	4	581	2	__stretching
entrenching	17	4	335	3	_entrenching
outstretching	19	6	115	3	outstretching
overstretching	23	6	176	3	overstretching
restressing	12	6	604	3	restre_ssing
restretch	14	7	387	3	restretch___
restretched	17	5	321	3	restretch_ed
restretches	16	5	350	3	restretch_es
restricting	14	4	930	3	restr_icting
reteaching	16	3	602	3	re_t_eaching
bedrenching	20	5	227	4	be_drenching
beseeching	18	4	336	4	bes__eeching
bestrewing	16	4	377	4	bestre__wing
betrothing	16	4	467	4	be_trot_hing
despatching	20	12	265	4	des_patching
destructing	15	4	611	4	destr_ucting
dethatching	21	4	224	4	de_thatching
estreating	11	7	1036	4	_estre_ating
hemstitching	23	7	179	4	hemst_itching
intrenching	17	4	407	4	_intrenching
misteaching	19	4	453	4	mist_eaching
outreaching	17	4	491	4	_outreaching
prestressing	15	8	397	4	prestre_ssing
reattaching	17	4	312	4	reat_taching
rebranching	19	4	338	4	re_branching
redirecting	15	4	561	4	redire_cting
reerecting	13	3	997	4	re_ere_cting
referencing	17	4	449	4	referenc_ing
refreshing	17	4	606	4	re_fre_shing
regretting	12	3	778	4	re_gret_ting
rematching	18	4	491	4	re__matching
repatching	18	4	499	4	re__patching
reproaching	19	4	430	4	re_proaching
rescreening	14	4	408	4	rescre_ening
researching	17	4	342	4	res_earching
resecting	12	28	1648	4	res__e_cting
reselecting	14	4	602	4	resele_cting
reservicing	17	5	342	4	reservic_ing
resetting	10	28	1629	4	res__et_ting
resettling	11	3	589	4	res__ettling
resmoothing	17	12	259	4	resmoot_hing
resorting	10	6	1461	4	resor_t__ing
respecting	15	4	988	4	res_pe_cting
respreading	15	4	517	4	respre_ading
restacking	17	3	718	4	rest__acking
restarting	11	3	1066	4	restart__ing
restating	10	23	1941	4	rest_at__ing
restituting	12	15	656	4	rest_ituting
restocking	17	4	570	4	rest__ocking
restraining	12	4	753	4	restr_aining
restriking	15	4	804	4	restr__iking
restring	9	15	1878	4	restr____ing
restringing	13	4	571	4	restr_inging
restriving	14	4	813	4	restr__iving
restructuring	16	7	279	4	restructuring
resurfacing	17	4	251	4	resurfac_ing
resurrecting	15	5	312	4	resurrecting
retching	14	34	1217	4	____retching
retouching	16	4	469	4	re_t_ouching
retracing	12	3	1329	4	re_tr_ac_ing
retracking	17	3	816	4	re_tr_acking
retracting	13	3	1193	4	re_tr_acting
retreading	12	12	848	4	re_tre_ading
retreating	11	14	1477	4	re_tre_ating
retroacting	14	4	728	4	re_troacting
reverencing	17	4	383	4	reverenc_ing
scratching	18	4	453	4	__scratching
screeching	18	4	364	4	__screeching
sketching	19	3	508	4	__s_ketching
stitching	15	4	710	4	__st_itching
stretchering	18	5	245	4	__stretchering
stretchier	15	4	448	4	__stretchier
trenching	15	22	765	4	___trenching
unstitching	17	4	264	4	unst_itching

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.390	458182.1
2	DLD Change Limit	124790	78	7.000	17827.1
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	7.436	24030.5