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

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

91 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
creased	10	43	1558	(None)
ceased	9	49	2078	1	c_eased
creaked	14	34	1323	1	creaked
creamed	12	39	1371	1	creamed
crease	8	55	1957	1	crease_
creaser	9	44	1572	1	creaser
creases	9	40	2096	1	creases
created	10	43	2344	1	created
greased	9	38	1239	1	greased
arrased	8	14	986	2	arrased
breaded	11	50	1406	2	breaded
breamed	12	40	1159	2	breamed
breasted	11	3	882	2	breasted
caressed	11	3	916	2	caressed
cased	8	60	3241	2	c__ased
cease	7	52	2765	2	c_ease_
ceases	8	44	2707	2	c_eases
censed	9	40	1632	2	c_ensed
cerated	10	39	2247	2	cerated
cessed	9	46	1561	2	c_essed
chased	12	50	1929	2	c_hased
cheated	13	44	1634	2	cheated
cheesed	13	39	1068	2	cheesed
cleaned	10	35	1200	2	cleaned
cleansed	11	39	593	2	cleansed
cleared	10	36	1246	2	cleared
cleated	10	34	1784	2	cleated
cleaved	13	40	1048	2	cleaved
craaled	10	33	942	2	craaled
craned	9	61	2165	2	cr_aned
craped	11	61	2052	2	cr_aped
crases	8	55	3231	2	cr_ases
crashed	13	42	1420	2	cr_ashed
crated	9	48	2777	2	cr_ated
craved	12	54	1777	2	cr_aved
crazed	18	47	1445	2	cr_azed
creamer	11	37	1408	2	creamer
creasers	10	36	1281	2	creasers
creasier	10	32	1019	2	creasier
creasy	11	46	1230	2	creas_y
create	8	51	2637	2	create_
creates	9	52	2517	2	creates
creed	8	57	2739	2	cre__ed
creeled	10	40	1201	2	creeled
creeped	12	32	971	2	creeped
creese	8	40	1433	2	creese_
creeses	9	39	1462	2	creeses
creeshed	14	3	569	2	creeshed
cremated	13	34	1296	2	cremated
crenated	11	30	1391	2	crenated
creped	11	41	1570	2	cre_ped
cresses	9	42	1981	2	cresses
cresset	9	33	1994	2	cresset
crested	10	34	1653	2	crested
crevassed	15	4	319	2	crevassed
crewed	12	53	1655	2	cre_wed
croaked	14	37	1053	2	croaked
crossed	10	53	1389	2	crossed
cruised	10	37	1021	2	cruised
decreased	13	4	545	2	decreased
dreaded	10	36	1202	2	dreaded
dreamed	11	43	1063	2	dreamed
dressed	9	35	1187	2	dressed
eased	6	54	3040	2	__eased
erased	7	48	1675	2	er_ased
feased	10	57	1871	2	_feased
freaked	15	39	970	2	freaked
grease	7	54	1623	2	grease_
greaser	8	39	1308	2	greaser
greases	8	48	1671	2	greases
greaved	12	40	891	2	greaved
increased	12	4	553	2	increased
leased	7	47	2288	2	_leased
pleased	10	37	1207	2	pleased
preaged	11	6	1233	2	preaged
pressed	10	33	1730	2	pressed
rased	6	50	3393	2	_r_ased
reamed	9	43	2612	2	_reamed
reaped	9	41	2245	2	_reaped
reared	7	59	3001	2	_reared
reaved	10	45	2392	2	_reaved
reused	7	54	1956	2	_reused
screaked	15	24	697	2	screaked
screamed	13	27	759	2	screamed
teased	7	47	2115	2	_teased
treaded	9	50	1428	2	treaded
treated	8	36	1870	2	treated
tressed	8	37	1425	2	tressed
urease	6	45	1699	2	urease_
ureases	7	44	1672	2	ureases
wreaked	15	36	902	2	wreaked

Search took 6 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.126	1418182.5
2	DLD Change Limit	107671	91	5.330	20200.9
3	Display Results	91	91	0.060	1516.7
	(SQL Overall)	178691	91	5.516	32395.0