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

Here are the results of your fuzzy-string dictionary search for “cwm” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

134 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
cwm	10	68	1508	(None)
cam	7	80	5898	1	cam
cum	7	64	4016	1	cum
cwms	11	43	957	1	cwms
aim	5	78	5822	2	aim
am	4	118	7556	2	_am
arm	5	84	4963	2	arm
aw	5	125	6340	2	aw_
awa	6	119	3967	2	awa
awe	6	77	4662	2	awe
awl	6	76	3530	2	awl
awn	6	80	3591	2	awn
bam	7	85	6014	2	bam
bum	7	53	4269	2	bum
cab	7	83	5540	2	cab
cad	6	74	5637	2	cad
calm	8	50	3236	2	calm
came	8	76	4875	2	came
camo	8	57	3175	2	camo
camp	10	63	3645	2	camp
cams	8	70	4728	2	cams
can	5	77	6014	2	can
cap	7	67	5898	2	cap
car	5	91	6556	2	car
cat	5	82	8234	2	cat
caw	8	66	4793	2	caw
caws	9	60	3611	2	caws
cay	8	71	5598	2	cay
cee	5	59	5270	2	cee
cel	5	60	4055	2	cel
cep	7	57	3633	2	cep
cham	11	55	3231	2	cham
chi	8	62	2865	2	chi
chum	11	63	1800	2	chum
cig	6	70	3619	2	cig
cis	5	77	4804	2	cis
clam	8	63	3229	2	clam
cob	7	102	5875	2	cob
cod	6	96	6013	2	cod
cog	6	95	5290	2	cog
col	5	93	6035	2	col
coma	8	71	3485	2	coma
comb	10	66	3211	2	comb
come	8	75	4770	2	come
comp	10	67	3125	2	comp
con	5	102	6802	2	con
coo	5	95	6636	2	coo
cop	7	111	6237	2	cop
cor	5	99	6094	2	cor
corm	8	57	3538	2	corm
cos	5	102	7039	2	cos
cot	5	104	8322	2	cot
cow	8	98	5671	2	cow
cowl	9	75	3081	2	cowl
cows	9	70	4664	2	cows
cowy	12	64	2736	2	cowy
cox	12	103	4678	2	cox
coy	8	105	5755	2	coy
coz	14	93	4536	2	coz
cram	8	56	3549	2	cram
cru	5	71	2956	2	cru
cry	8	97	2624	2	cry
cub	7	69	4094	2	cub
cud	6	79	3746	2	cud
cue	5	75	4418	2	cue
culm	8	58	2238	2	culm
cup	7	67	3824	2	cup
cur	5	68	4198	2	cur
cut	5	79	5766	2	cut
cyma	11	67	1584	2	cyma
cyme	11	94	2037	2	cyme
dam	6	74	5704	2	dam
dim	6	81	4650	2	dim
dom	6	97	5244	2	dom
elm	5	75	3174	2	elm
em	4	94	4515	2	_em
ewe	6	66	3098	2	ewe
fem	8	60	4073	2	fem
gam	6	70	6006	2	gam
gem	6	68	4022	2	gem
gum	6	74	3953	2	gum
gym	9	57	1906	2	gym
ham	8	63	6328	2	ham
hem	8	61	4873	2	hem
him	8	62	4767	2	him
hm	7	81	2673	2	_hm
hmm	10	62	1899	2	hmm
hum	8	55	4293	2	hum
ism	5	63	2239	2	ism
jam	12	69	4252	2	jam
lam	5	76	6671	2	lam
lum	5	55	4293	2	lum
mem	7	79	4347	2	mem
mim	7	60	4843	2	mim
mm	6	78	2681	2	_mm
mom	7	88	5316	2	mom
mum	7	66	4361	2	mum
nam	5	59	5339	2	nam
nim	5	71	4296	2	nim
nom	5	104	5064	2	nom
ohm	8	65	2301	2	ohm
om	4	85	5300	2	_om
ow	5	89	5017	2	ow_
owe	6	70	4103	2	owe
owl	6	62	2897	2	owl
own	6	64	2970	2	own
pam	7	78	5839	2	pam
pom	7	82	4991	2	pom
ram	5	68	6727	2	ram
rem	5	61	5004	2	rem
rim	5	60	5228	2	rim
rom	5	98	5563	2	rom
rum	5	66	4464	2	rum
scam	8	59	3235	2	scam
scum	8	59	2452	2	scum
sim	5	65	5315	2	sim
som	5	91	5381	2	som
sum	5	63	4601	2	sum
swam	9	63	2998	2	swam
swim	9	62	2140	2	swim
swum	9	64	1682	2	swum
tam	5	86	6342	2	tam
tom	5	143	5805	2	tom
twa	6	77	2164	2	twa
two	6	79	2583	2	two
um	4	73	3883	2	_um
umm	7	119	2126	2	umm
vim	8	74	3703	2	vim
vum	8	54	2865	2	vum
we	5	70	4345	2	_we
wo	5	104	4776	2	_wo
yam	8	74	4899	2	yam
yom	8	80	4344	2	yom
yum	8	61	3282	2	yum

Search took 1 second 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	14084	0.250	714764.0
2	DLD Change Limit	14084	134	0.343	41061.2
3	Display Results	134	134	0.016	8375.0
	(SQL Overall)	178691	134	0.609	293417.1