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

Here are the results of your fuzzy-string dictionary search for “chicer” 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
chicer	13	45	1360	(None)
chider	12	51	1605	1	chider
chimer	13	55	1720	1	chimer
choicer	14	19	789	1	choicer
achier	11	39	1426	2	achi_er
cahier	11	36	1577	2	cahi_er
cancer	10	42	2092	2	cancer
ceiler	8	40	1396	2	ceiler
chafer	14	47	1457	2	chafer
chancer	14	42	1563	2	chancer
chaser	11	49	1838	2	chaser
chawer	14	43	1441	2	chawer
checker	18	32	953	2	checker
cheder	12	51	1349	2	cheder
cheer	10	54	2038	2	ch_eer
chewer	14	55	1262	2	chewer
chic	11	59	2520	2	chic__
chica	12	58	1826	2	chic_a
chicaner	15	8	607	2	chicaner
chicas	13	59	1647	2	chicas
chicest	14	20	994	2	chicest
chichi	16	3	709	2	chichi
chichier	18	3	602	2	chichier
chick	16	54	1913	2	chic_k
chickee	18	31	1155	2	chickee
chicken	18	27	898	2	chicken
chicks	17	53	1759	2	chicks
chicle	13	43	1254	2	chicle
chicles	14	35	1250	2	chicles
chicly	16	42	920	2	chicly
chico	12	42	1825	2	chic_o
chicory	17	3	599	2	chicory
chicos	13	46	1483	2	chicos
chics	12	39	2094	2	chic_s
chide	11	53	2101	2	chide_
chided	13	51	1396	2	chided
chiders	13	53	1294	2	chiders
chides	12	46	2047	2	chides
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
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
choice	13	20	1052	2	choice_
choices	14	20	1061	2	choices
choker	15	43	1437	2	choker
choler	11	37	1715	2	choler
cicero	10	4	850	2	c_icero
cider	8	47	2331	2	c_ider
citer	7	48	2733	2	c_iter
clicker	15	41	1188	2	clicker
coiler	8	44	2159	2	coiler
coiner	8	43	2378	2	coiner
crier	7	47	2446	2	cri_er
deicer	9	41	1441	2	deicer
dicer	8	54	2642	2	_dicer
hider	9	50	2408	2	_hider
hiker	12	51	1939	2	_hiker
hirer	8	54	2312	2	_hirer
juicer	15	3	628	2	juicer
nicer	7	46	1829	2	_nicer
pricer	10	39	1829	2	pricer
ricer	7	47	2661	2	_ricer
shicker	16	39	1482	2	shicker
shier	8	54	2894	2	shi_er
shiner	9	38	2087	2	shiner
shiver	12	45	1737	2	shiver
slicer	8	41	1760	2	slicer
spicer	10	47	1931	2	spicer
thicker	16	36	1102	2	thicker
voicer	11	39	1054	2	voicer
whicker	19	35	977	2	whicker
whiner	12	45	1663	2	whiner
whiter	12	43	1639	2	whiter

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.360	496363.9
2	DLD Change Limit	82551	95	2.470	33421.5
3	Display Results	95	95	0.030	3166.7
	(SQL Overall)	178691	95	2.860	62479.4