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

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

257 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
porks	11	51	2414	(None)
borks	11	57	2770	1	borks
corks	11	60	2827	1	corks
dorks	10	57	2444	1	dorks
forks	12	53	2468	1	forks
parks	11	61	3446	1	parks
perks	11	53	2580	1	perks
pocks	13	50	2296	1	pocks
pores	7	58	4903	1	pores
pork	10	69	2968	1	pork_
porky	14	50	1933	1	porky
porns	7	55	2734	1	porns
ports	7	59	3459	1	ports
works	12	56	2190	1	works
arks	8	59	3687	2	_arks
barks	11	57	3581	2	barks
berks	11	54	2312	2	berks
birks	11	49	2030	2	birks
bocks	13	45	2657	2	bocks
bonks	11	63	2646	2	bonks
books	11	57	2971	2	books
boras	7	59	3830	2	boras
bores	7	64	4825	2	bores
bork	10	69	3382	2	bork_
borts	7	67	3545	2	borts
bosks	11	52	1885	2	bosks
carks	11	55	3421	2	carks
cocks	13	52	2716	2	cocks
conks	11	55	2570	2	conks
cooks	11	54	2914	2	cooks
cords	8	60	3062	2	cords
cores	7	63	6185	2	cores
cork	10	66	3569	2	cork_
corky	14	52	2115	2	corky
corms	9	56	2622	2	corms
corns	7	60	3476	2	corns
corps	9	59	2704	2	corps
cors	6	66	5644	2	cor_s
darks	10	67	2787	2	darks
dirks	10	56	1952	2	dirks
docks	12	60	2231	2	docks
dork	9	65	3146	2	dork_
dorky	13	55	1874	2	dorky
dorms	8	57	2384	2	dorms
dorps	8	54	1922	2	dorps
dorrs	6	55	2059	2	dorrs
dors	5	67	4760	2	dor_s
folks	12	60	1712	2	folks
forbs	10	57	2080	2	forbs
fords	9	53	2818	2	fords
fores	8	58	4710	2	fores
fork	11	59	3094	2	fork_
forky	15	61	1964	2	forky
forms	10	53	2705	2	forms
forts	8	60	3445	2	forts
gooks	10	54	2288	2	gooks
gores	6	57	4037	2	gores
gorms	8	56	1959	2	gorms
gorps	8	53	1699	2	gorps
gowks	13	60	1195	2	gowks
groks	10	57	1612	2	groks
harks	12	63	3343	2	harks
hocks	14	49	2549	2	hocks
holks	12	47	2056	2	holks
honks	12	51	2452	2	honks
hooks	12	50	2712	2	hooks
horas	8	63	3310	2	horas
horns	8	61	2533	2	horns
howks	15	50	1685	2	howks
irks	8	62	2013	2	_irks
jerks	16	65	1489	2	jerks
jocks	18	51	1808	2	jocks
jouks	16	56	1234	2	jouks
kirks	8	49	1526	2	kirks
konks	8	49	1711	2	konks
kooks	8	52	1726	2	kooks
koras	9	59	2711	2	koras
kors	8	59	3301	2	kor_s
larks	9	52	2781	2	larks
locks	11	51	2692	2	locks
looks	9	51	2486	2	looks
lords	6	49	2350	2	lords
lores	5	50	4540	2	lores
loris	5	53	2915	2	loris
lurks	9	52	1874	2	lurks
marks	11	59	3348	2	marks
merks	11	47	2240	2	merks
mirks	11	51	2214	2	mirks
mocks	13	50	2382	2	mocks
monks	11	61	2339	2	monks
moras	7	64	3877	2	moras
mores	7	62	4964	2	mores
morns	7	55	2744	2	morns
mors	6	59	5006	2	mor_s
morts	7	55	3356	2	morts
mosks	11	61	1700	2	mosks
murks	11	48	2172	2	murks
narks	9	60	2603	2	narks
nocks	11	51	2101	2	nocks
nooks	9	54	2039	2	nooks
noris	5	49	2827	2	noris
norms	7	60	1931	2	norms
oaks	8	65	2790	2	_oaks
orbs	6	66	2625	2	_orbs
orcs	6	70	2543	2	_orcs
ores	4	60	5668	2	_ores
ors	3	57	5011	2	_or_s
orts	4	65	3833	2	_orts
packs	13	55	2893	2	packs
paiks	11	47	1985	2	paiks
paras	7	61	4304	2	paras
pards	8	56	3433	2	pards
pares	7	71	6448	2	pares
paris	7	51	4594	2	paris
park	10	52	3749	2	park_
parka	11	51	2088	2	parka
parkas	12	50	1802	2	parkas
parrs	7	59	2867	2	parrs
pars	6	75	6079	2	par_s
parts	7	77	4337	2	parts
peaks	11	48	2562	2	peaks
pecks	13	57	2443	2	pecks
peeks	11	50	2111	2	peeks
peres	7	62	4664	2	peres
peris	7	55	3707	2	peris
perk	10	62	3284	2	perk_
perky	14	53	1948	2	perky
perms	9	55	2451	2	perms
perps	9	55	2148	2	perps
pervs	10	51	1737	2	pervs
picks	13	52	2614	2	picks
pinks	11	57	2938	2	pinks
pirns	7	60	2009	2	pirns
plonks	12	42	1042	2	plonks
pock	12	61	2929	2	pock_
pocky	16	53	1460	2	pocky
pods	7	65	4015	2	po_ds
poems	9	57	1555	2	poems
poets	7	60	2444	2	poets
pois	6	65	3904	2	po_is
poke	10	53	3536	2	po_ke
pokes	11	61	3301	2	pokes
poky	13	59	2215	2	po_ky
poles	7	53	5100	2	poles
polis	7	47	3116	2	polis
polka	11	3	1041	2	polka
polkas	12	3	910	2	polkas
polls	7	46	2772	2	polls
polos	7	61	2991	2	polos
pols	6	60	4456	2	po_ls
polys	10	57	1876	2	polys
pomes	9	48	3393	2	pomes
pomos	9	53	2158	2	pomos
pomps	11	53	1619	2	pomps
poms	8	70	3774	2	po_ms
ponds	8	53	2340	2	ponds
pones	7	45	4704	2	pones
pongs	8	55	2634	2	pongs
pons	6	58	5060	2	po_ns
poods	8	51	2475	2	poods
poofs	10	52	2279	2	poofs
poohs	10	39	1571	2	poohs
pools	7	44	2770	2	pools
poons	7	54	3097	2	poons
poops	9	44	2241	2	poops
pooris	8	39	1684	2	pooris
poos	6	59	4911	2	po_os
popes	9	59	3381	2	popes
pops	8	63	4095	2	po_ps
porch	12	59	1862	2	porch
pore	6	64	5126	2	por_e
pored	8	52	3451	2	pored
porgy	11	69	1612	2	porgy
porism	10	45	1806	2	porism
porked	13	47	1762	2	porked
porker	12	49	1754	2	porker
porkers	13	43	1493	2	porkers
porkies	13	34	1649	2	porkies
porn	6	56	3602	2	por_n
porno	7	51	2065	2	porno
pornos	8	50	1525	2	pornos
porny	10	60	2019	2	porny
porose	8	48	1874	2	porose
porous	8	44	1948	2	porous
port	6	60	5963	2	por_t
poses	7	46	4276	2	poses
posts	7	52	2878	2	posts
pots	6	64	5236	2	po_ts
poufs	10	56	1606	2	poufs
pours	7	46	2318	2	pours
pouts	7	55	3032	2	pouts
pows	9	55	3766	2	po_ws
poxes	14	53	2572	2	poxes
proas	7	50	2880	2	proas
prods	8	55	2355	2	prods
profs	10	51	2089	2	profs
progs	8	66	2415	2	progs
proms	9	54	2641	2	proms
props	9	57	2688	2	props
pros	6	57	4278	2	p_ros
pross	7	65	2940	2	pross
prows	10	63	2701	2	prows
pucks	13	43	2210	2	pucks
punks	11	48	2268	2	punks
puris	7	53	3202	2	puris
purls	7	47	2335	2	purls
purrs	7	53	2043	2	purrs
purs	6	56	4104	2	pur_s
pyres	10	55	2388	2	pyres
pyros	10	57	1829	2	pyros
rocks	11	46	2641	2	rocks
rooks	9	53	2504	2	rooks
sarks	9	66	3246	2	sarks
soaks	9	52	2029	2	soaks
socks	11	49	2608	2	socks
sooks	9	44	2545	2	sooks
soras	5	50	4101	2	soras
sorbs	7	50	2210	2	sorbs
sords	6	45	2780	2	sords
sores	5	54	5428	2	sores
sorns	5	50	2842	2	sorns
sorts	5	45	3666	2	sorts
sorus	5	45	2758	2	sorus
souks	9	48	2052	2	souks
sparks	12	46	1636	2	sparks
spooks	12	43	1293	2	spooks
spores	8	47	2661	2	spores
sports	8	46	1918	2	sports
storks	10	61	1595	2	storks
toras	5	55	4037	2	toras
torcs	7	51	2376	2	torcs
tores	5	53	5267	2	tores
toros	5	43	3619	2	toros
torrs	5	39	2356	2	torrs
tors	4	61	5738	2	tor_s
torsk	9	49	1577	2	torsk
torsks	10	54	912	2	torsks
torts	5	61	3812	2	torts
torus	5	43	2976	2	torus
turks	9	53	2082	2	turks
warks	12	79	3240	2	warks
woks	11	62	2490	2	wo_ks
wonks	12	48	1834	2	wonks
words	9	54	2507	2	words
work	11	55	2884	2	work_
worms	10	53	2076	2	worms
worts	8	86	3118	2	worts
yerks	12	54	1656	2	yerks
yocks	14	44	1837	2	yocks
yoks	11	62	2374	2	yo_ks
yolks	12	54	1277	2	yolks
yores	8	50	3132	2	yores
zerks	18	51	1382	2	zerks
zonks	18	48	1517	2	zonks
zooks	18	47	1694	2	zooks
zoris	14	53	2001	2	zoris
zouks	18	44	1050	2	zouks

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	53800	0.360	496363.9
2	DLD Change Limit	53800	257	1.640	32804.9
3	Display Results	257	257	0.076	3381.6
	(SQL Overall)	178691	257	2.076	86074.7