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

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

292 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
corm	8	57	3538	(None)
cor	5	99	6094	1	cor_
cord	7	67	4092	1	cord
core	6	72	6311	1	core
corf	9	59	4148	1	corf
cork	10	66	3569	1	cork
corms	9	56	2622	1	corms
corn	6	99	4581	1	corn
cors	6	66	5644	1	cors
cory	9	69	4151	1	cory
dorm	7	68	3463	1	dorm
form	9	58	3687	1	form
gorm	7	55	2939	1	gorm
norm	6	64	2981	1	norm
worm	9	61	2949	1	worm
acorn	7	56	1662	2	acorn
arm	5	84	4962	2	_arm
barm	8	67	3960	2	barm
berm	8	67	3275	2	berm
boom	8	74	3567	2	boom
bora	6	61	4163	2	bora
bore	6	60	5133	2	bore
bork	10	69	3382	2	bork
born	6	73	3841	2	born
bort	6	59	6096	2	bort
calm	8	50	3236	2	calm
cam	7	80	5898	2	c_am
car	5	91	6556	2	car_
carb	8	51	4316	2	carb
card	7	102	4587	2	card
care	6	69	6837	2	care
cark	10	55	3927	2	cark
carl	6	51	4478	2	carl
carn	6	62	4543	2	carn
carom	9	50	2556	2	carom
carp	8	51	3981	2	carp
carr	6	54	3470	2	carr
cars	6	73	6476	2	cars
cart	6	65	7034	2	cart
ceorl	7	4	1092	2	ceorl
cere	6	67	4147	2	cere
cero	6	63	2945	2	cero
cham	11	55	3231	2	cham
charm	12	61	2466	2	charm
chirm	12	53	1706	2	chirm
chord	11	59	1726	2	chord
chore	10	51	2676	2	chore
chum	11	63	1800	2	chum
cire	6	58	3637	2	cire
clam	8	63	3229	2	clam
coal	6	69	3925	2	coal
coat	6	75	5835	2	coat
coax	13	69	2298	2	coax
cob	7	102	5875	2	co_b
cobb	10	64	2200	2	cobb
cobra	9	52	1440	2	cobra
cobs	8	70	4314	2	cobs
coca	8	80	3064	2	coca
cock	12	63	3290	2	cock
coco	8	73	3060	2	coco
cod	6	96	6012	2	co_d
coda	7	70	2934	2	coda
code	7	73	4773	2	code
cods	7	68	4810	2	cods
coed	7	71	4054	2	coed
coff	12	69	3078	2	coff
coft	9	79	3968	2	coft
cog	6	95	5290	2	co_g
cogs	7	73	4003	2	cogs
coho	9	75	2449	2	coho
coif	9	63	3791	2	coif
coil	6	64	3965	2	coil
coin	6	66	4535	2	coin
coir	6	63	2724	2	coir
coirs	7	52	2105	2	coirs
coke	10	70	3838	2	coke
coky	13	75	2682	2	coky
col	5	93	6035	2	co_l
cola	6	65	4139	2	cola
cold	7	73	3877	2	cold
cole	6	69	5611	2	cole
cols	6	65	5308	2	cols
colt	6	71	5824	2	colt
coly	9	69	4053	2	coly
coma	8	71	3485	2	coma
comb	10	66	3211	2	comb
come	8	75	4770	2	come
comma	11	45	1479	2	comma
commy	14	47	1264	2	commy
comp	10	67	3125	2	comp
con	5	102	6802	2	co_n
cone	6	72	5696	2	cone
coni	6	55	3480	2	coni
conk	10	65	3144	2	conk
conn	6	62	2913	2	conn
cons	6	60	5769	2	cons
cony	9	65	3783	2	cony
coo	5	95	6636	2	co_o
coof	9	66	4327	2	coof
cook	10	72	3693	2	cook
cool	6	69	4049	2	cool
coomb	11	56	1570	2	coomb
coon	6	72	4894	2	coon
coop	8	72	3865	2	coop
coos	6	74	5649	2	coos
coot	6	78	6038	2	coot
cop	7	111	6237	2	co_p
cope	8	68	4738	2	cope
copra	9	81	1546	2	copra
cops	8	67	5137	2	cops
copy	11	62	2980	2	copy
coral	7	60	3345	2	coral
corby	12	50	1853	2	corby
cords	8	60	3062	2	cords
cored	8	50	4422	2	cored
corer	7	55	3887	2	corer
cores	7	63	6185	2	cores
corgi	8	3	1608	2	corgi
coria	7	58	2832	2	coria
corium	10	3	1572	2	corium
corks	11	60	2827	2	corks
corky	14	52	2115	2	corky
cormel	10	38	1560	2	cormel
corns	7	60	3476	2	corns
cornu	7	59	2132	2	cornu
corny	10	60	2327	2	corny
corps	9	59	2704	2	corps
corse	7	50	3618	2	corse
corymb	15	3	522	2	corymb
cos	5	102	7039	2	co_s
cosh	9	61	2762	2	cosh
coss	6	61	4349	2	coss
cost	6	80	5794	2	cost
cosy	9	72	3270	2	cosy
cot	5	104	8322	2	co_t
cote	6	66	4873	2	cote
cots	6	80	5484	2	cots
coup	8	67	2979	2	coup
court	7	55	3277	2	court
cove	9	58	3707	2	cove
cow	8	98	5671	2	co_w
cowl	9	75	3081	2	cowl
cowry	13	55	1248	2	cowry
cows	9	70	4664	2	cows
cowy	12	64	2736	2	cowy
cox	12	103	4678	2	co_x
coxa	13	69	2296	2	coxa
coy	8	105	5755	2	co_y
coys	9	75	3724	2	coys
coz	14	93	4536	2	co_z
cozy	18	58	2380	2	cozy
cram	8	56	3549	2	cram
croc	8	57	2373	2	croc
crop	8	76	2863	2	crop
crore	7	49	2287	2	crore
crow	9	64	2813	2	crow
cru	5	71	2956	2	c_ru
cry	8	97	2624	2	c_ry
culm	8	58	2238	2	culm
cum	7	64	4016	2	c_um
cur	5	68	4198	2	cur_
curb	8	67	3222	2	curb
curd	7	76	3498	2	curd
cure	6	61	4912	2	cure
curf	9	75	3878	2	curf
curl	6	60	3505	2	curl
curn	6	67	3189	2	curn
curr	6	54	2965	2	curr
curs	6	56	4554	2	curs
curt	6	70	5171	2	curt
cwm	10	68	1508	2	c_wm
derm	7	60	3189	2	derm
dom	6	97	5244	2	do_m
doom	7	64	3007	2	doom
dor	4	72	5392	2	dor_
dore	5	63	5330	2	dore
dork	9	65	3146	2	dork
dorms	8	57	2384	2	dorms
dormy	11	58	1747	2	dormy
dorp	7	60	2805	2	dorp
dorr	5	66	2772	2	dorr
dors	5	67	4760	2	dors
dory	8	58	3623	2	dory
doum	7	62	2667	2	doum
enorm	7	44	1564	2	enorm
farm	9	59	3453	2	farm
firm	9	60	2645	2	firm
foam	9	71	2717	2	foam
for	6	69	5207	2	for_
fora	7	59	3739	2	fora
foram	10	51	2493	2	foram
forb	9	71	3133	2	forb
ford	8	68	3549	2	ford
fore	7	83	5147	2	fore
fork	11	59	3094	2	fork
forme	10	52	2599	2	forme
forms	10	53	2705	2	forms
fort	7	64	5644	2	fort
forum	10	83	1876	2	forum
from	9	69	2392	2	from
germ	7	54	2896	2	germ
gor	4	78	4826	2	gor_
gore	5	57	4496	2	gore
gorms	8	56	1959	2	gorms
gorp	7	56	2590	2	gorp
gory	8	61	2966	2	gory
harm	9	56	3779	2	harm
herm	9	56	3615	2	herm
holm	9	56	2811	2	holm
hora	7	61	3656	2	hora
horn	7	67	3561	2	horn
joram	14	58	1698	2	joram
jorum	14	55	1374	2	jorum
kor	7	65	3889	2	kor_
kora	8	64	3155	2	kora
kore	8	58	3416	2	kore
korma	11	59	1307	2	korma
kors	8	59	3301	2	kors
loam	6	56	3048	2	loam
loom	6	70	3505	2	loom
lord	5	50	3208	2	lord
lore	4	58	5035	2	lore
lorn	4	64	3525	2	lorn
lory	7	59	3171	2	lory
mom	7	88	5316	2	mo_m
mor	5	68	5500	2	mor_
mora	6	66	4127	2	mora
more	6	71	5452	2	more
morn	6	62	3756	2	morn
mors	6	59	5006	2	mors
mort	6	67	5883	2	mort
nom	5	104	5064	2	no_m
nor	3	80	4882	2	nor_
nori	4	71	3314	2	nori
norms	7	60	1931	2	norms
ohm	8	65	2301	2	_ohm
om	4	85	5300	2	_o_m
or	2	73	5473	2	_or_
ora	3	72	5083	2	_ora
orb	5	57	3686	2	_orb
orc	5	70	3492	2	_orc
ore	3	66	6183	2	_ore
ors	3	57	5011	2	_ors
ort	3	94	6523	2	_ort
perm	8	58	3463	2	perm
poem	8	62	2577	2	poem
pom	7	82	4991	2	po_m
pore	6	64	5126	2	pore
pork	10	69	2968	2	pork
porn	6	56	3602	2	porn
port	6	60	5963	2	port
prom	8	76	3170	2	prom
roam	6	71	3241	2	roam
rom	5	98	5563	2	ro_m
room	6	62	3508	2	room
score	7	55	2674	2	score
scorn	7	58	1745	2	scorn
som	5	91	5381	2	so_m
sora	4	57	4691	2	sora
sorb	6	83	3304	2	sorb
sord	5	62	3720	2	sord
sore	4	70	5953	2	sore
sori	4	60	3984	2	sori
sorn	4	66	4106	2	sorn
sort	4	62	6481	2	sort
storm	7	65	2040	2	storm
term	6	62	3315	2	term
tom	5	143	5805	2	to_m
toom	6	65	3293	2	toom
tor	3	92	6168	2	tor_
tora	4	75	4599	2	tora
torc	6	63	3335	2	torc
tore	4	73	5932	2	tore
tori	4	75	4215	2	tori
torn	4	60	4425	2	torn
toro	4	80	4568	2	toro
torr	4	56	3090	2	torr
tors	4	61	5738	2	tors
tort	4	69	6746	2	tort
tory	7	58	4054	2	tory
warm	9	59	3567	2	warm
word	8	98	3200	2	word
wore	7	71	4467	2	wore
work	11	55	2884	2	work
worms	10	53	2076	2	worms
wormy	13	75	1425	2	wormy
worn	7	56	3175	2	worn
wort	7	66	5475	2	wort
yom	8	80	4344	2	yo_m
yore	7	63	3594	2	yore
zoom	15	67	2210	2	zoom
zori	13	77	2292	2	zori

Search took 2 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	29872	0.280	638182.1
2	DLD Change Limit	29872	292	0.906	32971.3
3	Display Results	292	292	0.076	3842.1
	(SQL Overall)	178691	292	1.262	141593.5