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

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

75 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
chinook	16	7	510	(None)
chinooks	17	7	478	1	chinooks
chibouk	18	4	392	2	chibouk
chink	14	53	2159	2	chin__k
chino	10	58	2331	2	chin_o_
chinone	12	5	1015	2	chinone
chinos	11	50	1869	2	chin_os
chook	14	60	1504	2	ch__ook
schnook	16	5	448	2	sch_nook
shnook	13	6	634	2	sh_nook
chabouk	18	4	454	3	chabouk
chanoyu	15	4	448	3	chanoyu
chanson	12	3	804	3	chanson
chantor	12	37	1031	3	chantor
chapbook	21	9	374	3	chapbook
chenopod	16	4	394	3	chenopod
cheroot	12	4	1369	3	cheroot
chiao	10	56	1836	3	chi_ao_
chibouks	19	4	308	3	chibouks
chick	16	54	1913	3	chi__ck
chico	12	42	1825	3	chi_co_
chicory	17	3	599	3	chicory
chicos	13	46	1483	3	chi_cos
chiffon	18	4	405	3	chiffon
chignon	13	4	462	3	chignon
chignons	14	4	471	3	chignons
chigoe	12	3	753	3	chi_goe
chigoes	13	3	835	3	chigoes
chilopod	16	9	465	3	chilopod
chin	9	69	3474	3	chin___
china	10	50	2248	3	chin__a
chinas	11	51	1940	3	chin_as
chinbone	15	5	516	3	chinbone
chinch	16	39	1123	3	chin_ch
chinchy	20	33	551	3	chinchy
chine	10	52	3172	3	chin__e
chined	12	56	2006	3	chin_ed
chines	11	50	2917	3	chin_es
chining	13	33	1684	3	chining
chinked	17	40	1102	3	chinked
chinks	15	58	1757	3	chin_ks
chinky	18	56	1054	3	chin_ky
chinned	13	48	1049	3	chinned
chinones	13	5	1047	3	chinones
chins	10	56	3146	3	chin__s
chints	11	51	1783	3	chin_ts
chintz	20	42	1203	3	chin_tz
chintzy	24	36	422	3	chintzy
chinwag	16	4	355	3	chinwag
chirk	14	45	1618	3	chi__rk
chiro	10	53	2034	3	chi_ro_
chiros	11	46	1777	3	chi_ros
chiton	11	26	1239	3	chi_ton
chitons	12	26	1191	3	chitons
chock	16	43	1661	3	ch__ock
chooks	15	53	1279	3	ch__ooks
chronon	12	3	735	3	chronon
chunk	14	48	1238	3	chun__k
cineol	8	10	820	3	c_ineol
clink	11	53	2004	3	clin__k
cook	10	72	3693	3	c___ook
crinoid	10	3	994	3	crinoid
crook	11	52	1757	3	c__rook
echinoid	14	4	599	3	echinoid
hook	11	61	3328	3	_h__ook
nainsook	12	4	226	3	nainsook
nook	8	57	2849	3	___nook
olicook	13	5	406	3	olicook
rhino	8	46	1432	3	rhin_o_
rhinos	9	44	1112	3	rhin_os
schnooks	17	5	424	3	sch_nooks
shnooks	14	8	558	3	sh_nooks
shook	12	49	2016	3	sh__ook
snook	9	51	1557	3	__snook
think	12	50	1880	3	thin__k

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	134027	0.406	440125.6
2	DLD Change Limit	134027	75	5.670	23637.9
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	6.109	29250.5