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

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

86 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
creaked	14	34	1323	(None)
creamed	12	39	1371	1	creamed
creased	10	43	1559	1	creased
created	10	43	2345	1	created
croaked	14	37	1054	1	croaked
freaked	15	39	970	1	freaked
screaked	15	24	698	1	screaked
wreaked	15	36	902	1	wreaked
beaked	13	59	1949	2	_beaked
beraked	14	43	1243	2	beraked
braked	13	53	1869	2	br_aked
breaded	11	50	1406	2	breaded
breaker	13	39	1292	2	breaker
breamed	12	40	1159	2	breamed
caked	12	61	2862	2	c__aked
ceased	9	49	2078	2	c_eased
cerated	10	39	2247	2	cerated
cheated	13	44	1634	2	cheated
checked	19	37	1002	2	checked
cheeked	17	39	966	2	cheeked
cleaned	10	35	1200	2	cleaned
cleared	10	36	1246	2	cleared
cleated	10	34	1784	2	cleated
cleaved	13	40	1048	2	cleaved
cleeked	14	35	773	2	cleeked
clerked	14	32	665	2	clerked
cloaked	14	36	854	2	cloaked
craaled	10	33	942	2	craaled
cracked	16	35	1474	2	cracked
crake	11	48	2352	2	cr_ake_
crakes	12	49	2181	2	cr_akes
craned	9	61	2165	2	cr_aned
cranked	14	38	1284	2	cranked
craped	11	61	2053	2	cr_aped
crated	9	48	2777	2	cr_ated
craved	12	54	1777	2	cr_aved
crazed	18	47	1445	2	cr_azed
creak	11	54	1843	2	creak__
creakier	14	32	833	2	creakier
creaks	12	43	1596	2	creak_s
creaky	15	49	1155	2	creak_y
creamer	11	37	1409	2	creamer
crease	8	55	1957	2	crease_
creaser	9	44	1574	2	creaser
creases	9	40	2096	2	creases
create	8	51	2638	2	create_
creates	9	52	2520	2	creates
creed	8	57	2739	2	cre__ed
creeled	10	40	1201	2	creeled
creeped	12	32	971	2	creeped
cremated	13	34	1296	2	cremated
crenated	11	30	1391	2	crenated
creped	11	41	1571	2	cre_ped
crested	10	34	1654	2	crested
crewed	12	53	1656	2	cre_wed
cricked	16	48	1428	2	cricked
croaker	13	30	1068	2	croaker
crocked	16	40	1444	2	crocked
crooked	14	39	1095	2	crooked
dreaded	10	36	1202	2	dreaded
dreamed	11	43	1063	2	dreamed
greased	9	38	1239	2	greased
greaved	12	40	891	2	greaved
leaked	11	42	1770	2	_leaked
peaked	13	61	1740	2	_peaked
phreaked	18	3	449	2	phreaked
preaged	11	6	1233	2	preaged
prebaked	17	3	717	2	prebaked
raked	10	58	3142	2	_r_aked
reamed	9	43	2612	2	_reamed
reaped	9	41	2245	2	_reaped
reared	7	59	3001	2	_reared
reaved	10	45	2392	2	_reaved
recked	13	48	2180	2	_recked
reeked	11	37	1764	2	_reeked
rewaked	15	38	1190	2	_rewaked
screamed	13	27	760	2	screamed
sneaked	12	32	969	2	sneaked
streaked	13	22	845	2	streaked
treaded	9	50	1428	2	treaded
treated	8	36	1870	2	treated
trekked	11	3	434	2	trekked
troaked	12	43	825	2	troaked
tweaked	15	3	440	2	tweaked
wreaker	14	36	1004	2	wreaker
wrecked	17	41	833	2	wrecked

Search took 9 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.783	228213.3
2	DLD Change Limit	107671	86	7.203	14948.1
3	Display Results	86	86	0.060	1433.3
	(SQL Overall)	178691	86	8.046	22208.7