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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

101 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
chook	14	60	1504	(None)
chock	16	43	1661	1	chock
chooks	15	53	1279	1	chooks
cook	10	72	3693	1	c_ook
crook	11	52	1757	1	crook
hook	11	61	3328	1	_hook
shook	12	49	2016	1	shook
achoo	10	3	1508	2	achoo_
bhoot	10	43	2210	2	bhoot
book	10	68	3633	2	_book
brook	11	47	1776	2	brook
cahoot	11	4	1647	2	cahoot
chalk	14	48	1460	2	chalk
chao	9	57	2731	2	chao_
chaos	10	56	2286	2	chaos
chark	14	42	2271	2	chark
check	16	47	1471	2	check
cheek	14	51	1571	2	cheek
chick	16	54	1913	2	chick
chink	14	53	2159	2	chink
chinook	16	7	510	2	chinook
chirk	14	45	1618	2	chirk
chocks	17	48	1531	2	chocks
choir	10	53	1360	2	choir
choke	14	51	1802	2	choke
choky	17	57	1122	2	choky
chola	10	47	1803	2	chola
cholo	10	52	1797	2	cholo
cholos	11	47	1685	2	cholos
chomp	14	48	1566	2	chomp
chon	9	66	2779	2	ch_on
choose	11	51	1614	2	choose
choosy	14	45	910	2	choosy
chop	11	60	2492	2	ch_op
chops	12	50	1987	2	chops
chord	11	59	1726	2	chord
chore	10	51	2676	2	chore
chose	10	59	2540	2	chose
chott	10	39	2393	2	chott
chow	12	58	2099	2	ch_ow
chows	13	56	1820	2	chows
chuck	16	48	1487	2	chuck
chunk	14	48	1238	2	chunk
cloak	11	52	1401	2	cloak
clock	13	49	1798	2	clock
clonk	11	44	1744	2	clonk
cloot	7	61	2705	2	cloot
cock	12	63	3290	2	c_ock
coho	9	75	2449	2	coho_
cohog	11	78	1304	2	cohog
cohos	10	59	2185	2	cohos
conk	10	65	3144	2	c_onk
coo	5	95	6636	2	c_oo_
coof	9	66	4327	2	c_oof
cooks	11	54	2914	2	c_ooks
cooky	14	53	2136	2	c_ooky
cool	6	69	4049	2	c_ool
coon	6	72	4894	2	c_oon
coop	8	72	3865	2	c_oop
coos	6	74	5649	2	c_oos
coot	6	78	6038	2	c_oot
cork	10	66	3569	2	c_ork
croak	11	52	1663	2	croak
crock	13	59	2199	2	crock
crooks	12	49	1441	2	crooks
croon	7	55	2278	2	croon
ebook	11	45	1080	2	ebook
gook	9	64	2960	2	_gook
hock	13	60	3130	2	_hock
holk	11	60	2794	2	_holk
honk	11	69	3119	2	_honk
hood	8	51	3233	2	_hood
hoof	10	60	3658	2	_hoof
hooka	12	55	1390	2	_hooka
hooks	12	50	2712	2	_hooks
hooky	15	52	2026	2	_hooky
hoop	9	61	2998	2	_hoop
hoot	7	57	5210	2	_hoot
howk	14	52	2196	2	_howk
kook	7	58	2260	2	_kook
look	8	73	3347	2	_look
nook	8	57	2849	2	_nook
rook	8	55	3203	2	_rook
schnook	16	5	448	2	schnook
school	11	4	1072	2	school
shnook	13	6	634	2	shnook
shock	14	49	1703	2	shock
shoo	7	59	2989	2	shoo_
shooks	13	45	1563	2	shooks
shool	8	45	2315	2	shool
shoon	8	40	2201	2	shoon
shoos	8	42	2636	2	shoos
shoot	8	42	3591	2	shoot
snook	9	51	1557	2	snook
sook	8	49	3339	2	_sook
spook	11	54	1604	2	spook
stook	9	52	1821	2	stook
took	8	65	3107	2	_took
unhook	13	4	752	2	unhook
whoof	14	46	1269	2	whoof
whoop	13	42	1144	2	whoop

Search took 2 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	53800	0.096	1861364.6
2	DLD Change Limit	53800	101	1.543	34867.1
3	Display Results	101	101	0.033	3060.6
	(SQL Overall)	178691	101	1.672	106872.6