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

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

172 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
rooked	11	49	1814	(None)
booked	13	53	1950	1	booked
brooked	14	36	1003	1	brooked
cooked	13	59	2136	1	cooked
crooked	14	39	1095	1	crooked
hooked	14	53	2055	1	hooked
looked	11	47	1707	1	looked
rocked	13	50	2232	1	rocked
roofed	10	52	1474	1	roofed
roomed	9	52	1854	1	roomed
roosed	7	56	2160	1	roosed
rooted	7	54	2400	1	rooted
bonked	13	55	1731	2	bonked
boobed	11	45	1487	2	boobed
booed	8	51	2727	2	boo_ed
bookend	14	39	664	2	bookend
booker	12	47	1919	2	booker
boomed	11	53	1813	2	boomed
booted	9	48	2273	2	booted
boozed	18	48	1383	2	boozed
borked	13	51	1729	2	borked
brooded	11	35	1093	2	brooded
broomed	12	41	1105	2	broomed
choked	16	49	1479	2	choked
cocked	15	50	2256	2	cocked
coked	12	47	3069	2	_coked
conked	13	50	1911	2	conked
cooed	8	45	3434	2	coo_ed
cooeed	9	59	1786	2	cooeed
cooker	12	47	2245	2	cooker
cookey	15	54	1433	2	cookey
cooled	9	52	2459	2	cooled
cooped	11	48	2161	2	cooped
corked	13	50	2078	2	corked
croaked	14	37	1054	2	croaked
crocked	16	40	1444	2	crocked
crooker	13	41	1109	2	crooker
crooned	10	38	1335	2	crooned
docked	14	50	1833	2	docked
doomed	10	41	1329	2	doomed
drooled	9	36	920	2	drooled
drooped	11	36	843	2	drooped
drouked	13	3	554	2	drouked
evoked	14	45	788	2	evoked
fooled	10	43	1782	2	fooled
footed	10	44	1862	2	footed
forked	14	52	1714	2	forked
frocked	17	43	933	2	frocked
goofed	11	49	1138	2	goofed
goosed	8	68	1703	2	goosed
grokked	12	3	367	2	grokked
groomed	11	37	950	2	groomed
grooved	12	34	725	2	grooved
hocked	16	55	2130	2	hocked
hoked	13	53	2699	2	_hoked
holked	14	49	1366	2	holked
honked	14	45	1791	2	honked
hooded	11	46	1674	2	hooded
hoofed	13	46	1489	2	hoofed
hooker	13	48	2017	2	hooker
hookey	16	47	1393	2	hookey
hooped	12	55	1818	2	hooped
hooted	10	44	2266	2	hooted
hooved	13	47	1312	2	hooved
howked	17	73	1234	2	howked
joked	17	52	1791	2	_joked
jouked	18	56	815	2	jouked
konked	10	40	1058	2	konked
locked	13	49	2166	2	locked
looed	6	46	2613	2	loo_ed
looker	10	48	1695	2	looker
loomed	9	46	1676	2	loomed
looped	9	52	1717	2	looped
loosed	7	55	2089	2	loosed
looted	7	44	2111	2	looted
mocked	15	47	1661	2	mocked
mooed	8	51	2398	2	moo_ed
mooned	9	42	1664	2	mooned
moored	9	38	1417	2	moored
mooted	9	41	2037	2	mooted
nocked	13	46	1738	2	nocked
noosed	7	50	1802	2	noosed
oohed	9	42	1421	2	_oohed
oozed	15	42	1426	2	_oozed
pocked	15	48	1898	2	pocked
poked	12	54	2539	2	_poked
pooed	8	52	2624	2	poo_ed
poohed	12	39	1252	2	poohed
pooled	9	46	1981	2	pooled
pooped	11	39	1594	2	pooped
porked	13	47	1762	2	porked
proofed	13	13	872	2	proofed
provoked	18	7	505	2	provoked
racked	13	45	2608	2	racked
raked	10	58	3142	2	r_aked
ranked	11	46	2074	2	ranked
rebooked	15	22	650	2	rebooked
recked	13	48	2180	2	recked
recooked	15	26	825	2	recooked
reeked	11	37	1764	2	reeked
relooked	13	23	665	2	relooked
revoked	15	44	1052	2	revoked
ricked	13	65	2362	2	ricked
rioted	7	34	1637	2	rioted
risked	11	55	1463	2	risked
roamed	9	52	1509	2	roamed
roared	7	50	1539	2	roared
robbed	11	34	1519	2	robbed
robed	8	53	2373	2	r_obed
rocker	12	43	1957	2	rocker
rocket	12	54	2528	2	rocket
rodded	9	37	1370	2	rodded
rogued	8	47	1147	2	rogued
roiled	7	43	2005	2	roiled
rolfed	10	45	1052	2	rolfed
rolled	7	42	2024	2	rolled
romped	11	45	1365	2	romped
rood	5	67	3300	2	roo__d
roofer	9	44	1528	2	roofer
rook	8	55	3203	2	rook__
rookery	14	39	831	2	rookery
rookie	10	36	1326	2	rookie
rookier	11	40	1238	2	rookier
rookies	11	39	1710	2	rookies
rooks	9	53	2504	2	rook_s
rooky	12	61	1762	2	rook_y
roomer	8	47	1863	2	roomer
roose	5	61	2709	2	roose_
rooser	6	39	2188	2	rooser
rooses	6	55	2624	2	rooses
roosted	8	32	1189	2	roosted
rooter	6	49	2603	2	rooter
rootled	8	34	1053	2	rootled
roped	8	46	3081	2	r_oped
rosed	6	59	3035	2	r_osed
rotted	7	45	2443	2	rotted
rouged	8	67	1732	2	rouged
rouped	9	57	1735	2	rouped
roused	7	54	2645	2	roused
routed	7	56	2433	2	routed
roved	9	53	2355	2	r_oved
rowed	9	40	3432	2	r_owed
rucked	13	47	1876	2	rucked
ryked	13	66	951	2	r_yked
smoked	13	43	1172	2	smoked
snooked	12	37	1149	2	snooked
soaked	11	47	1759	2	soaked
socked	13	47	2150	2	socked
sooted	7	39	2259	2	sooted
spoked	13	44	1389	2	spoked
spooked	14	45	1047	2	spooked
stoked	11	47	1829	2	stoked
stooked	12	43	1230	2	stooked
toked	10	56	2649	2	_toked
tooled	7	49	1890	2	tooled
tooted	7	46	2012	2	tooted
troaked	12	43	825	2	troaked
trocked	14	43	1224	2	trocked
troked	11	41	1458	2	troked
trooped	10	40	1072	2	trooped
vroomed	13	36	643	2	vroomed
wooded	11	42	1368	2	wooded
wooed	9	44	1987	2	woo_ed
woofed	13	45	1120	2	woofed
wooled	10	37	1550	2	wooled
worked	14	53	1470	2	worked
yocked	16	41	1442	2	yocked
yoked	13	48	2162	2	_yoked
yolked	14	36	715	2	yolked
zonked	20	42	947	2	zonked
zoomed	18	36	1036	2	zoomed
zooned	16	40	1108	2	zooned

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.343	520965.0
2	DLD Change Limit	82551	172	2.423	34069.7
3	Display Results	172	172	0.046	3739.1
	(SQL Overall)	178691	172	2.812	63545.9