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

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

51 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
creaky	15	49	1155	(None)
creak	11	54	1843	1	creak_
creaks	12	43	1596	1	creaks
creamy	13	48	1136	1	creamy
creasy	11	46	1230	1	creasy
croaky	15	52	848	1	croaky
freaky	16	43	923	1	freaky
screaky	16	43	621	1	screaky
beaky	14	61	1802	2	_beaky
braky	14	50	1581	2	br_aky
bready	12	45	1118	2	bready
break	11	53	1940	2	break_
breaks	12	48	1642	2	breaks
caky	13	62	2244	2	c__aky
cheeky	18	44	861	2	cheeky
cracky	17	50	1022	2	cracky
crake	11	48	2352	2	cr_ake
cranky	15	39	1063	2	cranky
crazy	19	55	1122	2	cr_azy
creaked	14	34	1323	2	creaked
creakily	17	3	539	2	creakily
cream	9	57	2134	2	crea_m
creams	10	47	1525	2	creams
crease	8	55	1957	2	crease
create	8	51	2637	2	create
creek	11	49	1739	2	creek_
creeks	12	48	1292	2	creeks
creepy	13	41	880	2	creepy
crepey	13	51	1093	2	crepey
crepy	12	48	1270	2	cre_py
cressy	11	43	911	2	cressy
croak	11	52	1663	2	croak_
croaks	12	58	1298	2	croaks
dreamy	12	50	999	2	dreamy
dreary	10	46	1167	2	dreary
drecky	16	48	633	2	drecky
freak	12	51	1524	2	freak_
freaks	13	47	1306	2	freaks
greasy	10	41	946	2	greasy
leaky	12	52	1772	2	_leaky
peaky	14	57	1815	2	_peaky
ready	9	48	2150	2	_ready
reeky	12	54	1626	2	_reeky
screak	12	53	1105	2	screak_
screaks	13	46	935	2	screaks
sneaky	13	42	784	2	sneaky
streaky	14	44	781	2	streaky
treaty	9	44	1435	2	treaty
tweaky	16	3	402	2	tweaky
wreak	12	55	1327	2	wreak_
wreaks	13	47	1111	2	wreaks

Search took 8 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.440	406115.9
2	DLD Change Limit	82551	51	6.593	12521.0
3	Display Results	51	51	0.030	1700.0
	(SQL Overall)	178691	51	7.063	25299.6