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

Here are the results of your fuzzy-string dictionary search for “crewed” 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
crewed	12	53	1656	(None)
brewed	12	54	1187	1	brewed
chewed	15	44	1501	1	chewed
clewed	12	251	1320	1	clewed
creed	8	57	2739	1	cre_ed
creped	11	41	1570	1	creped
crewel	11	43	1048	1	crewel
crowed	12	47	1730	1	crowed
rewed	9	54	2545	1	_rewed
screwed	13	57	1066	1	screwed
breed	8	55	2669	2	bre_ed
brewer	11	48	1255	2	brewer
browed	12	52	1639	2	browed
cawed	11	66	2706	2	c_awed
ceded	9	61	1856	2	c_eded
cered	8	52	2744	2	c_ered
chawed	15	52	1460	2	chawed
chefed	15	50	1056	2	chefed
chewer	14	55	1262	2	chewer
chowed	15	49	1465	2	chowed
clawed	12	51	1507	2	clawed
cleped	11	51	1411	2	cleped
cowed	11	56	3785	2	c_owed
craned	9	61	2165	2	craned
craped	11	61	2052	2	craped
crated	9	48	2777	2	crated
craved	12	54	1777	2	craved
crawled	13	37	1040	2	crawled
crazed	18	47	1445	2	crazed
creaked	14	34	1323	2	creaked
creamed	12	39	1371	2	creamed
creased	10	43	1558	2	creased
created	10	43	2345	2	created
cred	7	65	3088	2	cr__ed
creeds	9	47	1477	2	cre_eds
creek	11	49	1739	2	cre_ek
creel	7	51	2148	2	cre_el
creeled	10	40	1201	2	creeled
creep	9	52	1810	2	cre_ep
creeped	12	32	971	2	creeped
creme	9	43	1932	2	creme_
cremes	10	45	1799	2	cremes
crenel	8	42	1306	2	crenel
crepe	9	55	2072	2	crepe_
crepes	10	54	1934	2	crepes
crepey	13	51	1093	2	crepey
crested	10	34	1653	2	crested
crew	9	61	2268	2	crew__
crewels	12	43	849	2	crewels
crewmen	14	3	638	2	crewmen
crews	10	59	1750	2	crew_s
cried	8	46	2428	2	cr_ied
crowd	11	58	1562	2	crow_d
crowded	14	41	879	2	crowded
crower	11	41	1756	2	crower
crowned	13	39	1243	2	crowned
dewed	10	50	2030	2	_dewed
dreed	7	52	2284	2	dre_ed
freed	9	52	2354	2	fre_ed
greed	7	51	2569	2	gre_ed
greyed	11	46	1060	2	greyed
hewed	12	56	1943	2	_hewed
jewed	16	51	1483	2	_jewed
krewe	12	3	819	2	krewe_
krewes	13	3	792	2	krewes
mewed	11	52	1801	2	_mewed
preed	8	51	2812	2	pre_ed
premed	11	46	1776	2	premed
preyed	12	53	1320	2	preyed
reded	7	48	2912	2	_reded
reed	5	55	4962	2	_re_ed
refed	9	39	2192	2	_refed
reweds	10	44	1230	2	_reweds
reweld	10	37	1111	2	_reweld
rewet	8	51	3515	2	_rewet
rowed	9	40	3432	2	_rowed
screed	9	57	1893	2	scre_ed
screwer	12	44	1007	2	screwer
sewed	9	53	2516	2	_sewed
shewed	13	47	1618	2	shewed
shrewed	14	58	985	2	shrewed
skewed	14	56	1023	2	skewed
slewed	10	48	1552	2	slewed
spewed	12	55	1233	2	spewed
stewed	10	48	1424	2	stewed
strewed	11	58	1134	2	strewed
tewed	9	47	1853	2	_tewed
treed	6	56	2673	2	tre_ed
trowed	10	47	1465	2	trowed
uncrewed	14	5	676	2	uncrewed
viewed	13	4	599	2	viewed

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	91	2.250	36689.3
3	Display Results	91	91	0.033	2757.6
	(SQL Overall)	178691	91	2.626	68046.8