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

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

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.

56 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
limits	8	25	1414	(None)
limit	7	31	2634	1	limit_
limites	9	29	1545	1	limites
admits	9	4	1141	2	admits
binits	8	57	1667	2	binits
delimits	11	3	757	2	delimits
demits	9	49	1807	2	demits
digits	8	41	1453	2	digits
dimity	12	3	1047	2	dimity
dimwits	13	4	451	2	dimwits
dixits	14	42	1031	2	dixits
elicits	9	3	1123	2	elicits
emits	7	54	2147	2	_emits
imids	8	60	1514	2	_imids
lamias	8	50	2061	2	lamias
legits	7	13	1300	2	legits
lichts	11	37	1238	2	lichts
licit	7	43	2768	2	licit_
lifts	8	57	1906	2	li_fts
lights	10	45	1991	2	lights
lilies	6	30	2141	2	lilies
lilts	5	58	2280	2	li_lts
limans	8	48	1630	2	limans
limas	7	56	2763	2	lim_as
limbas	10	53	1320	2	limbas
limbos	10	47	1214	2	limbos
limbs	9	61	1894	2	lim_bs
limbus	10	57	1038	2	limbus
limens	8	46	1803	2	limens
limes	7	56	3650	2	lim_es
limeys	11	42	927	2	limeys
limier	8	35	1872	2	limier
limiest	9	37	1610	2	limiest
limina	8	35	1450	2	limina
liming	9	40	2124	2	liming
limited	10	23	1023	2	limited
limiteds	11	18	454	2	limiteds
limiter	9	27	1085	2	limiter
limiters	10	24	933	2	limiters
limns	7	57	1839	2	lim_ns
limos	7	53	2081	2	lim_os
limpas	10	55	1308	2	limpas
limpets	11	32	978	2	limpets
limps	9	55	2267	2	lim_ps
linins	6	59	2214	2	linins
lints	5	71	3719	2	li_nts
lipids	9	43	1092	2	lipids
lipins	8	50	1688	2	lipins
lists	5	66	2869	2	li_sts
lits	4	62	5249	2	l__its
mimics	12	8	936	2	mimics
omits	7	50	1826	2	_omits
pipits	10	47	1306	2	pipits
remits	8	56	2294	2	remits
visits	9	3	1142	2	visits
vomits	11	26	1092	2	vomits

Search took 3 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	82551	0.346	516448.0
2	DLD Change Limit	82551	56	2.466	33475.7
3	Display Results	56	56	0.016	3500.0
	(SQL Overall)	178691	56	2.828	63186.4