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

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

80 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
chiders	13	53	1294	(None)
cheders	13	45	1239	1	cheders
chider	12	51	1605	1	chider_
chides	12	46	2047	1	chide_s
chimers	14	45	1514	1	chimers
ciders	9	46	2009	1	c_iders
hiders	10	49	1965	1	_hiders
abiders	10	40	1108	2	abiders
aiders	7	45	2463	2	_aiders
biders	9	48	2280	2	_biders
cahiers	12	35	1067	2	cahi_ers
carders	10	48	2035	2	carders
ceders	9	38	1767	2	c_eders
ceilers	9	39	1253	2	ceilers
chadars	13	3	829	2	chadars
chadors	13	3	875	2	chadors
chafers	15	45	1274	2	chafers
chasers	12	37	1492	2	chasers
chawers	15	44	1205	2	chawers
cheder	12	51	1349	2	cheder_
cheers	11	45	1891	2	ch_eers
chewers	15	41	1114	2	chewers
chicer	13	45	1360	2	chicer_
chide	11	53	2102	2	chide__
chided	13	51	1396	2	chide_d
chiefs	14	50	965	2	chi_efs
chiels	11	51	1593	2	chi_els
chiggers	15	3	556	2	chiggers
childes	13	42	1127	2	childe_s
chiles	11	54	2530	2	chile_s
chillers	13	37	1092	2	chillers
chimars	14	40	1059	2	chimars
chimer	13	55	1720	2	chimer_
chimera	14	38	927	2	chimera
chimeras	15	38	883	2	chimeras
chimere	14	40	1063	2	chimere
chimeres	15	35	1131	2	chimeres
chimes	13	49	2257	2	chime_s
chines	11	50	2917	2	chine_s
chippers	17	35	1088	2	chippers
chirpers	15	35	813	2	chirpers
chirres	12	38	1225	2	chirres
chirrs	11	45	1498	2	chi_rrs
chisels	12	21	910	2	chisels
chitters	13	37	1117	2	chitters
chives	14	43	1759	2	chive_s
chokers	16	43	1152	2	chokers
cholers	12	42	1520	2	cholers
chowders	17	38	754	2	chowders
chudders	15	23	556	2	chudders
cider	8	47	2332	2	c_ider_
cinders	10	46	1776	2	cinders
citers	8	50	2298	2	c_iters
clivers	12	34	1175	2	clivers
codders	11	41	1445	2	codders
coders	9	54	2698	2	c_oders
coilers	9	36	1990	2	coilers
coiners	9	36	2075	2	coiners
corders	10	45	2088	2	corders
criers	8	39	1858	2	cri_ers
cyders	12	39	883	2	c_yders
eiders	7	43	2136	2	_eiders
gliders	9	48	1184	2	gliders
guiders	9	41	1111	2	guiders
heders	10	41	1976	2	_heders
hider	9	50	2409	2	_hider_
hides	9	51	2943	2	_hide_s
hikers	13	50	1435	2	_hikers
hinders	11	37	1850	2	_hinders
hirers	9	45	1806	2	_hirers
raiders	8	46	1514	2	raiders
riders	7	41	2390	2	_riders
shaders	11	59	1555	2	shaders
shiers	9	49	2175	2	shi_ers
shiners	10	40	1594	2	shiners
shivers	13	37	1483	2	shivers
sliders	8	35	1522	2	sliders
spiders	10	39	1441	2	spiders
voiders	11	27	982	2	voiders
whiners	13	40	1157	2	whiners

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	80	3.343	32207.9
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.749	47663.6