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

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

90 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
mistending	14	4	795	(None)
distending	13	4	833	1	distending
missending	14	4	649	1	missending
dispending	15	4	792	2	dispending
intending	11	3	998	2	_intending
listening	10	12	895	2	listen_ing
misbinding	16	4	506	2	misbinding
misfeeding	17	4	499	2	misfeeding
misleading	14	4	683	2	misleading
mispenning	15	4	577	2	mispenning
misreading	14	4	826	2	misreading
misspending	17	4	365	2	misspending
misterming	15	3	860	2	misterming
mistuning	12	3	767	2	mistun_ing
moistening	13	4	623	2	moisten_ing
ascending	13	3	628	3	_ascending
attending	11	13	637	3	_attending
bartending	14	4	491	3	bartending
besteading	14	4	603	3	besteading
contending	14	4	912	3	contending
descending	15	4	611	3	descending
disbanding	15	4	558	3	disbanding
dispensing	14	4	823	3	dispensing
dissenting	12	13	1029	3	dissenting
distancing	14	4	708	3	distancing
extending	18	3	585	3	_extending
fastening	13	26	860	3	fasten_ing
glistening	12	9	428	3	glisten_ing
hastening	13	25	948	3	hasten_ing
impending	15	3	593	3	_impending
islanding	11	3	562	3	_islanding
kittening	14	3	459	3	kitten_ing
mastering	12	23	1531	3	maste_ring
mastheading	18	4	358	3	mastheading
mending	11	40	1868	3	m___ending
mildening	13	4	567	3	milden_ing
minding	11	33	1789	3	mi___nding
misadding	14	11	583	3	mis_adding
misatoning	13	4	644	3	misaton_ing
misbranding	17	4	429	3	misbranding
miscoding	15	3	818	3	mis_coding
misdealing	14	5	736	3	misdealing
misdeeming	16	4	499	3	misdeeming
miseating	12	12	1543	3	mis_eating
misfielding	18	4	272	3	misfielding
misgrading	15	4	682	3	misgrading
misguiding	15	4	434	3	misguiding
mishandling	18	4	333	3	mishandling
mishearing	16	4	788	3	mishearing
miskeeping	19	4	435	3	miskeeping
mismeeting	15	4	624	3	mismeeting
mispleading	17	4	435	3	mispleading
misrelying	16	4	550	3	misrelying
misrendering	16	8	331	3	misrendering
misseating	13	13	1094	3	misseating
missetting	13	10	790	3	missetting
missounding	15	4	344	3	missounding
missteering	14	4	445	3	missteering
misstepping	18	6	275	3	misstepping
mistaking	16	9	969	3	mist_aking
misteaching	19	4	453	3	misteaching
mistend	10	38	1252	3	mistend___
mistended	13	13	733	3	mistend_ed
mistends	11	41	959	3	mistend__s
misthinking	21	4	342	3	misthinking
mistiming	14	3	891	3	mist_iming
misting	10	36	2338	3	mist___ing
mistitling	13	4	622	3	mistitling
mistracing	15	6	960	3	mistracing
mistreating	14	4	928	3	mistreating
mistyping	17	4	472	3	mist_yping
miswording	17	4	486	3	miswording
mitering	11	30	1540	3	mi_te_ring
mustering	12	22	1233	3	muste_ring
portending	14	4	619	3	portending
pretending	14	3	861	3	pretending
protending	14	4	681	3	protending
resending	11	23	1336	3	res_ending
scending	12	26	1058	3	__scending
sending	9	42	2137	3	__s_ending
shending	13	25	1125	3	__shending
sistering	10	12	1375	3	siste_ring
spending	12	27	1243	3	__spending
standing	10	34	1363	3	__standing
steading	10	36	1359	3	__steading
subtending	14	4	510	3	subtending
suspending	14	4	503	3	suspending
tending	9	44	1916	3	___tending
upsending	13	3	490	3	ups_ending
upstanding	14	4	371	3	upstanding

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	140603	0.423	422437.4
2	DLD Change Limit	140603	90	6.970	20172.6
3	Display Results	90	90	0.046	1956.5
	(SQL Overall)	178691	90	7.439	24020.8