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

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

99 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
chider	12	51	1605	(None)
cheder	12	51	1349	1	cheder
chicer	13	45	1360	1	chicer
chide	11	53	2102	1	chide_
chided	13	51	1396	1	chided
chiders	13	53	1294	1	chiders
chides	12	46	2047	1	chides
chimer	13	55	1720	1	chimer
cider	8	47	2332	1	c_ider
hider	9	50	2409	1	_hider
abider	9	53	1446	2	abider
achier	11	39	1426	2	achi_er
acrider	10	3	862	2	acrider
aider	6	54	3114	2	_aider
arider	7	47	1774	2	arider
bider	8	57	2838	2	_bider
cahier	11	36	1577	2	cahi_er
carder	9	45	2418	2	carder
ceder	8	53	2224	2	c_eder
ceiler	8	40	1396	2	ceiler
chadar	12	3	935	2	chadar
chador	12	3	867	2	chador
chafer	14	47	1457	2	chafer
chaser	11	49	1838	2	chaser
chawer	14	43	1441	2	chawer
cheders	13	45	1239	2	cheders
cheer	10	54	2038	2	ch_eer
chewer	14	55	1262	2	chewer
chid	10	66	2641	2	chid__
chidden	14	25	522	2	chidden
chief	13	44	1948	2	chi_ef
chiefer	15	3	686	2	chiefer
chiel	10	49	1897	2	chi_el
chigger	14	3	600	2	chigger
childe	12	47	1121	2	childe_
childes	13	42	1127	2	childes
chile	10	56	2689	2	chile_
chiles	11	54	2530	2	chiles
chiller	12	41	1218	2	chiller
chimar	13	39	1147	2	chimar
chime	12	53	2259	2	chime_
chimed	14	58	1483	2	chimed
chimera	14	38	927	2	chimera
chimere	14	40	1063	2	chimere
chimers	14	45	1514	2	chimers
chimes	13	49	2257	2	chimes
chine	10	52	3172	2	chine_
chined	12	56	2006	2	chined
chines	11	50	2917	2	chines
chipper	16	39	1258	2	chipper
chirker	16	42	932	2	chirker
chirper	14	35	996	2	chirper
chirr	10	50	1590	2	chi_rr
chirre	11	41	1185	2	chirre
chisel	11	21	1194	2	chisel
chitter	12	41	1296	2	chitter
chive	13	51	1762	2	chive_
chives	14	43	1759	2	chives
choicer	14	19	789	2	choicer
choker	15	43	1437	2	choker
choler	11	37	1715	2	choler
chowder	16	38	781	2	chowder
chudder	14	24	594	2	chudder
ciders	9	46	2009	2	c_iders
cinder	9	41	1912	2	cinder
citer	7	48	2733	2	c_iter
codder	10	44	1634	2	codder
coder	8	61	3422	2	c_oder
coiler	8	44	2159	2	coiler
coiner	8	43	2378	2	coiner
colder	9	51	2185	2	colder
corder	9	43	2288	2	corder
crier	7	47	2446	2	cri_er
cruder	9	56	1238	2	cruder
cyder	11	46	1113	2	c_yder
eider	6	46	2475	2	_eider
glider	8	46	1426	2	glider
guider	8	43	1352	2	guider
heder	9	56	2364	2	_heder
hide	8	51	3465	2	_hide_
hided	10	52	2245	2	_hided
hiders	10	49	1965	2	_hiders
hides	9	51	2943	2	_hides
hiker	12	51	1939	2	_hiker
hinder	10	41	2006	2	_hinder
hirer	8	54	2312	2	_hirer
raider	7	43	1874	2	raider
rider	6	52	3131	2	_rider
shader	10	42	1876	2	shader
shier	8	54	2894	2	shi_er
shiner	9	38	2087	2	shiner
shiver	12	45	1737	2	shiver
slider	7	39	1836	2	slider
snider	7	44	1391	2	snider
spider	9	45	1680	2	spider
voider	10	36	1155	2	voider
whiner	12	45	1663	2	whiner
whiter	12	43	1639	2	whiter
wider	9	48	2636	2	_wider

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.343	520965.0
2	DLD Change Limit	82551	99	2.576	32046.2
3	Display Results	99	99	0.033	3000.0
	(SQL Overall)	178691	99	2.952	60532.2