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

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

95 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
chided	13	51	1396	(None)
chide	11	53	2102	1	chide_
chider	12	51	1605	1	chider
chides	12	46	2047	1	chides
chimed	14	58	1483	1	chimed
chined	12	56	2006	1	chined
hided	10	52	2245	1	_hided
abided	10	53	1331	2	abided
aided	7	58	2894	2	_aided
bided	9	54	2497	2	_bided
carded	10	54	2490	2	carded
ceded	9	61	1856	2	c_eded
ceiled	9	41	1495	2	ceiled
chafed	15	48	1391	2	chafed
chained	13	38	1269	2	chained
chaired	13	42	1124	2	chaired
chared	12	54	2369	2	chared
chased	12	50	1929	2	chased
chawed	15	52	1460	2	chawed
cheder	12	51	1349	2	cheder
chefed	15	50	1056	2	chefed
chewed	15	44	1501	2	chewed
chicer	13	45	1360	2	chicer
chid	10	66	2641	2	chi__d
chidden	14	25	522	2	chidden
chiders	13	53	1294	2	chiders
chief	13	44	1948	2	chi_ef
chiel	10	49	1897	2	chi_el
chield	12	46	1021	2	chield
child	11	45	1622	2	chi_ld
childbed	17	4	288	2	childbed
childe	12	47	1121	2	childe_
childes	13	42	1127	2	childes
chile	10	56	2689	2	chile_
chiles	11	54	2530	2	chiles
chilled	13	33	1093	2	chilled
chime	12	53	2259	2	chime_
chimer	13	55	1720	2	chimer
chimes	13	49	2257	2	chimes
chine	10	52	3172	2	chine_
chines	11	50	2917	2	chines
chinked	17	40	1102	2	chinked
chinned	13	48	1050	2	chinned
chipped	17	41	1081	2	chipped
chirked	17	38	1033	2	chirked
chirmed	15	37	973	2	chirmed
chirped	15	37	978	2	chirped
chirred	13	36	1212	2	chirred
chisel	11	21	1194	2	chisel
chive	13	51	1762	2	chive_
chives	14	43	1759	2	chives
chivied	16	36	838	2	chivied
choired	13	34	934	2	choired
choked	16	49	1479	2	choked
chorded	14	47	1055	2	chorded
chored	12	53	2188	2	chored
chowed	15	49	1465	2	chowed
chuted	12	46	1184	2	chuted
cider	8	47	2332	2	c_ider
cited	8	44	2195	2	c_ited
codded	11	45	1530	2	codded
coded	9	54	3318	2	c_oded
coifed	12	41	1306	2	coifed
coiled	9	51	2394	2	coiled
coined	9	45	2360	2	coined
corded	10	59	2335	2	corded
cowhided	18	4	375	2	cowhided
cried	8	46	2429	2	cri_ed
curded	10	42	1716	2	curded
elided	8	48	1467	2	elided
glided	9	45	1390	2	glided
grided	9	51	1704	2	grided
guided	9	40	1411	2	guided
haded	10	52	2762	2	_haded
hide	8	51	3465	2	_hide_
hider	9	50	2409	2	_hider
hides	9	51	2943	2	_hides
hied	8	54	3405	2	_hi_ed
hiked	13	59	1920	2	_hiked
hired	9	52	2626	2	_hired
hived	12	52	1791	2	_hived
loided	8	34	1402	2	loided
nided	7	59	2088	2	_nided
prided	10	36	1803	2	prided
raided	8	50	1770	2	raided
shaded	11	45	1887	2	shaded
shied	9	61	2549	2	shi_ed
shined	10	46	2078	2	shined
sided	7	48	2596	2	_sided
tided	7	63	2252	2	_tided
voided	11	40	1113	2	voided
whidded	16	3	442	2	whidded
whiled	13	45	1413	2	whiled
whined	13	47	1520	2	whined
whited	13	48	1408	2	whited

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.373	479064.3
2	DLD Change Limit	82551	95	2.296	35954.3
3	Display Results	95	95	0.033	2878.8
	(SQL Overall)	178691	95	2.702	66132.9