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

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

69 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
crooked	14	39	1094	(None)
brooked	14	36	1003	1	brooked
cooked	13	59	2136	1	c_ooked
croaked	14	37	1053	1	croaked
crocked	16	40	1443	1	crocked
crooker	13	41	1109	1	crooker
crooned	10	38	1334	1	crooned
rooked	11	49	1814	1	_rooked
booked	13	53	1950	2	_booked
brooded	11	35	1093	2	brooded
broomed	12	41	1105	2	broomed
chocked	19	44	1161	2	chocked
choked	16	49	1479	2	c_hoked
cloaked	14	36	854	2	cloaked
clocked	16	41	1283	2	clocked
clonked	14	42	956	2	clonked
cocked	15	50	2256	2	c_ocked
coked	12	47	3069	2	c__oked
conked	13	50	1911	2	c_onked
cooed	8	45	3434	2	c_oo_ed
cooeed	9	59	1786	2	c_ooeed
cooker	12	47	2245	2	c_ooker
cookey	15	54	1433	2	c_ookey
cooled	9	52	2459	2	c_ooled
cooped	11	48	2160	2	c_ooped
corked	13	50	2078	2	c_orked
cracked	16	35	1474	2	cracked
cranked	14	38	1284	2	cranked
creaked	14	34	1323	2	creaked
cricked	16	48	1428	2	cricked
croaker	13	30	1068	2	croaker
crocket	15	46	1567	2	crocket
crook	11	52	1757	2	crook__
crookeder	16	4	282	2	crookeder
crookedly	19	4	203	2	crookedly
crookery	17	41	599	2	crookery
crookest	14	3	668	2	crookest
crooks	12	49	1441	2	crook_s
crooner	9	37	1404	2	crooner
cropped	14	38	1206	2	cropped
crossed	10	53	1389	2	crossed
crowded	14	41	879	2	crowded
crowed	12	47	1730	2	cr_owed
crowned	13	39	1243	2	crowned
drooled	9	36	920	2	drooled
drooped	11	36	843	2	drooped
drouked	13	3	554	2	drouked
frocked	17	43	933	2	frocked
grokked	12	3	367	2	grokked
groomed	11	37	950	2	groomed
grooved	12	34	725	2	grooved
hooked	14	53	2055	2	_hooked
looked	11	47	1707	2	_looked
proofed	13	13	872	2	proofed
provoked	18	7	505	2	provoked
rocked	13	50	2232	2	_rocked
roofed	10	52	1474	2	_roofed
roomed	9	52	1854	2	_roomed
roosed	7	56	2159	2	_roosed
rooted	7	54	2400	2	_rooted
scrooped	13	5	640	2	scrooped
snooked	12	37	1149	2	snooked
spooked	14	45	1047	2	spooked
stooked	12	43	1230	2	stooked
troaked	12	43	825	2	troaked
trocked	14	43	1224	2	trocked
troked	11	41	1458	2	tr_oked
trooped	10	40	1072	2	trooped
vroomed	13	36	643	2	vroomed

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	69	2.890	37256.4
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	3.296	54214.5