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

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

299 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
wort	7	66	5475	(None)
bort	6	59	6096	1	bort
fort	7	64	5644	1	fort
mort	6	67	5883	1	mort
ort	3	94	6523	1	_ort
port	6	60	5963	1	port
sort	4	62	6481	1	sort
tort	4	69	6746	1	tort
wart	7	78	6608	1	wart
wert	7	97	4982	1	wert
whort	11	46	2369	1	whort
wont	7	58	4250	1	wont
word	8	98	3200	1	word
wore	7	71	4467	1	wore
work	11	55	2884	1	work
worm	9	61	2949	1	worm
worn	7	56	3175	1	worn
worst	8	63	3013	1	worst
worth	11	71	2052	1	worth
worts	8	86	3118	1	worts
wost	7	65	4436	1	wost
wot	6	104	6748	1	wo_t
abort	7	61	3358	2	abort
airt	4	57	5778	2	airt
amort	7	58	3220	2	amort
aorta	5	59	2257	2	aorta
aport	7	54	3217	2	aport
art	3	86	7914	2	_art
boart	7	88	3593	2	boart
boat	6	63	6031	2	boat
bolt	6	62	5417	2	bolt
boot	6	77	5937	2	boot
bora	6	61	4163	2	bora
bore	6	60	5133	2	bore
bork	10	69	3382	2	bork
born	6	73	3841	2	born
borts	7	67	3545	2	borts
borty	10	55	2283	2	borty
bortz	16	57	2220	2	bortz
bot	5	96	8040	2	bo_t
bott	6	65	4857	2	bott
bout	6	63	5329	2	bout
cart	6	65	7034	2	cart
coat	6	75	5835	2	coat
coft	9	79	3968	2	coft
colt	6	71	5824	2	colt
coot	6	78	6038	2	coot
cor	5	99	6094	2	cor_
cord	7	67	4092	2	cord
core	6	72	6311	2	core
corf	9	59	4148	2	corf
cork	10	66	3569	2	cork
corm	8	57	3538	2	corm
corn	6	99	4581	2	corn
cors	6	66	5644	2	cors
cory	9	69	4151	2	cory
cost	6	80	5794	2	cost
cot	5	104	8322	2	co_t
court	7	55	3277	2	court
curt	6	70	5171	2	curt
dart	5	58	5787	2	dart
dirt	5	55	5038	2	dirt
doat	5	69	4767	2	doat
doit	5	63	4785	2	doit
dolt	5	66	4942	2	dolt
dor	4	72	5392	2	dor_
dore	5	63	5330	2	dore
dork	9	65	3146	2	dork
dorm	7	68	3463	2	dorm
dorp	7	60	2805	2	dorp
dorr	5	66	2772	2	dorr
dors	5	67	4760	2	dors
dorty	9	62	2081	2	dorty
dory	8	58	3623	2	dory
dost	5	72	4835	2	dost
dot	4	75	7318	2	do_t
fart	7	68	6056	2	fart
font	7	71	4375	2	font
foot	7	62	4801	2	foot
for	6	69	5207	2	for_
fora	7	59	3739	2	fora
forb	9	71	3133	2	forb
ford	8	68	3549	2	ford
fore	7	83	5147	2	fore
fork	11	59	3094	2	fork
form	9	58	3687	2	form
forte	8	61	3146	2	forte
forth	11	62	2267	2	forth
forts	8	60	3445	2	forts
forty	11	48	2427	2	forty
girt	5	66	4642	2	girt
goat	5	62	5083	2	goat
gor	4	78	4826	2	gor_
gore	5	57	4496	2	gore
gorm	7	55	2939	2	gorm
gorp	7	56	2590	2	gorp
gory	8	61	2966	2	gory
got	4	98	7044	2	go_t
gout	5	66	4600	2	gout
grot	5	59	4205	2	grot
hart	7	68	6577	2	hart
holt	7	78	5258	2	holt
hoot	7	57	5210	2	hoot
hora	7	61	3656	2	hora
horn	7	67	3561	2	horn
horst	8	58	3351	2	horst
host	7	78	5283	2	host
hot	6	77	7606	2	ho_t
hurt	7	71	4257	2	hurt
jolt	11	66	3912	2	jolt
jot	10	82	5902	2	jo_t
kart	8	67	5080	2	kart
kor	7	65	3889	2	kor_
kora	8	64	3155	2	kora
korat	9	49	3443	2	korat
kore	8	58	3416	2	kore
kors	8	59	3301	2	kors
loft	7	65	3914	2	loft
loot	4	69	5582	2	loot
lord	5	50	3208	2	lord
lore	4	58	5035	2	lore
lorn	4	64	3525	2	lorn
lory	7	59	3171	2	lory
lost	4	79	5149	2	lost
lot	3	81	7926	2	lo_t
lout	4	59	5214	2	lout
mart	6	68	6598	2	mart
moat	6	63	5203	2	moat
molt	6	63	5616	2	molt
moot	6	76	5362	2	moot
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
morts	7	55	3356	2	morts
most	6	65	5420	2	most
mot	5	72	7942	2	mo_t
mott	6	66	4844	2	mott
nor	3	80	4882	2	nor_
nori	4	71	3314	2	nori
norm	6	64	2981	2	norm
north	8	60	1827	2	north
not	3	94	7466	2	no_t
nowt	7	88	3375	2	nowt
oat	3	98	8826	2	_oat
oft	6	77	4406	2	_oft
oot	3	112	7469	2	_oot
opt	5	75	4554	2	_opt
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
orts	4	65	3833	2	_orts
out	3	80	7215	2	_out
part	6	59	6746	2	part
pert	6	67	5932	2	pert
poet	6	55	5290	2	poet
pore	6	64	5126	2	pore
pork	10	69	2968	2	pork
porn	6	56	3602	2	porn
ports	7	59	3459	2	ports
post	6	79	5336	2	post
pot	5	80	7843	2	po_t
pout	6	57	5255	2	pout
root	4	56	5592	2	root
rot	3	72	8295	2	ro_t
rout	4	61	5328	2	rout
short	8	50	4053	2	short
skort	9	49	2564	2	skort
snort	5	48	3375	2	snort
soft	7	69	4282	2	soft
soot	4	57	6106	2	soot
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
sorta	5	71	2541	2	sorta
sorts	5	45	3666	2	sorts
sot	3	103	8430	2	so_t
sport	7	59	3598	2	sport
swart	8	62	3464	2	swart
sword	9	52	1412	2	sword
swore	8	49	2082	2	swore
sworn	8	61	1531	2	sworn
swot	7	51	3466	2	swo_t
tart	4	75	6618	2	tart
toft	7	74	4165	2	toft
toit	4	63	5306	2	toit
toot	4	59	5888	2	toot
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
torot	5	61	3994	2	torot
torr	4	56	3090	2	torr
tors	4	61	5738	2	tors
torta	5	59	2535	2	torta
torte	5	54	3170	2	torte
torts	5	61	3812	2	torts
tory	7	58	4054	2	tory
tost	4	83	5192	2	tost
tot	3	88	8477	2	to_t
tout	4	67	5382	2	tout
trot	4	63	5131	2	trot
vert	7	72	4937	2	vert
volt	7	64	3953	2	volt
waft	10	61	3900	2	waft
wait	7	55	5369	2	wait
want	7	61	5617	2	want
war	6	72	6242	2	war_
ward	8	65	4225	2	ward
ware	7	62	5472	2	ware
wark	11	57	3777	2	wark
warm	9	59	3567	2	warm
warn	7	52	3932	2	warn
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
warts	8	148	4040	2	warts
warty	11	93	2382	2	warty
wary	10	67	4001	2	wary
wast	7	56	5585	2	wast
wat	6	73	7892	2	w_at
watt	7	55	4541	2	watt
weet	7	52	5415	2	weet
weft	10	54	3501	2	weft
welt	7	55	4786	2	welt
went	7	60	5187	2	went
wept	9	56	3505	2	wept
were	7	62	3833	2	were
west	7	57	4808	2	west
wet	6	59	6662	2	w_et
what	10	54	3407	2	what
whet	10	51	3378	2	whet
whit	10	48	3417	2	whit
whore	11	60	1804	2	whore
whorl	11	46	1245	2	whorl
whorts	12	51	1143	2	whorts
wilt	7	62	4629	2	wilt
wire	7	58	3981	2	wire
wiry	10	64	2283	2	wiry
wist	7	80	4929	2	wist
wit	6	65	6377	2	w_it
wo	5	104	4776	2	wo__
woad	8	55	2394	2	woad
woe	6	66	5124	2	wo_e
woes	7	64	4066	2	woes
wog	7	62	4273	2	wo_g
wogs	8	65	3140	2	wogs
wok	10	63	3417	2	wo_k
woke	11	55	2796	2	woke
woks	11	62	2490	2	woks
wold	8	54	2907	2	wold
wolf	10	57	2956	2	wolf
womb	11	70	2223	2	womb
won	6	62	5206	2	wo_n
wonk	11	61	2530	2	wonk
wons	7	49	4204	2	wons
wonts	8	76	2154	2	wonts
woo	6	69	4980	2	wo_o
wood	8	53	2938	2	wood
woof	10	65	3242	2	woof
wool	7	64	2737	2	wool
woos	7	62	3880	2	woos
wop	8	71	4513	2	wo_p
wops	9	66	3415	2	wops
words	9	54	2507	2	words
wordy	12	69	1616	2	wordy
works	12	56	2190	2	works
world	9	69	1536	2	world
worms	10	53	2076	2	worms
wormy	13	75	1425	2	wormy
worrit	9	23	1331	2	worrit
worry	11	61	1433	2	worry
worse	8	65	2526	2	worse
worset	9	67	2658	2	worset
worsts	9	60	1433	2	worsts
worths	12	78	1289	2	worths
worthy	15	59	880	2	worthy
wos	6	69	5353	2	wo_s
wots	7	63	4289	2	wots
wove	10	56	2431	2	wove
wow	9	66	4347	2	wo_w
wows	10	46	3349	2	wows
writ	7	55	3791	2	writ
wrote	8	47	1748	2	wrote
wroth	11	68	1588	2	wroth
wry	9	65	2470	2	w_ry
wurst	8	51	2299	2	wurst
yore	7	63	3594	2	yore
yurt	7	64	3504	2	yurt
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.360	496363.9
2	DLD Change Limit	29872	299	1.063	28101.6
3	Display Results	299	299	0.076	3934.2
	(SQL Overall)	178691	299	1.499	119206.8