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

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

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.

45 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
chickory	22	4	336	(None)
chiccory	17	4	248	1	chiccory
chicory	17	3	599	1	chic_ory
hickory	19	4	390	1	_hickory
checker	18	32	953	3	checker_
checkers	19	31	784	3	checkers
checkoff	25	4	242	3	checkoff
checkout	19	4	559	3	checkout
checkrow	22	4	274	3	checkrow
chicanery	19	10	305	3	chicanery
chicer	13	45	1360	3	chic_er_
chick	16	54	1913	3	chick___
chickaree	20	7	470	3	chickaree
chickee	18	31	1155	3	chick_ee
chickees	19	25	851	3	chickees
chicken	18	27	898	3	chick_en
chickens	19	26	743	3	chickens
chickories	21	4	436	3	chickories
chickpea	21	4	319	3	chickpea
chicks	17	53	1759	3	chick__s
chicly	16	42	920	3	chic__ly
chico	12	42	1825	3	chic_o__
chicos	13	46	1483	3	chic_o_s
chinky	18	56	1054	3	chink__y
chirker	16	42	932	3	chirker_
chivalry	19	4	308	3	chivalry
chucky	20	41	800	3	chuck__y
clicker	15	41	1188	3	clicker_
clickers	16	39	1020	3	clickers
crickey	18	41	814	3	crick_ey
crockery	19	35	660	3	crockery
flickery	20	36	510	3	flickery
hickey	18	50	1199	3	_hick_ey
history	13	3	942	3	_history
shicker	16	39	1482	3	shicker_
shickers	17	30	1282	3	shickers
snickery	17	29	554	3	snickery
thicker	16	36	1102	3	thicker_
thickety	20	27	410	3	thickety
thickly	19	41	557	3	thick_ly
trickery	17	29	734	3	trickery
victory	15	32	698	3	_victory
whicker	19	35	977	3	whicker_
whickers	20	29	798	3	whickers
whiskery	21	31	455	3	whiskery

Search took 7 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	146162	0.156	1145455.1
2	DLD Change Limit	146162	45	6.123	23871.0
3	Display Results	45	45	0.016	2812.5
	(SQL Overall)	178691	45	6.295	28386.2