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

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

274 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
belts	7	59	3116	(None)
beats	7	60	4224	1	beats
beets	7	61	3144	1	beets
bells	7	64	3216	1	bells
bels	6	61	4249	1	bel_s
belt	6	57	5403	1	belt_
bents	7	60	3369	1	bents
bests	7	59	3261	1	bests
bets	6	70	5144	1	be_ts
blets	7	53	2494	1	blets
bolts	7	62	3211	1	bolts
celts	7	53	2578	1	celts
delts	6	57	3179	1	delts
felts	8	53	2454	1	felts
gelts	6	59	2461	1	gelts
kelts	9	52	2263	1	kelts
melts	7	49	3010	1	melts
pelts	7	61	2881	1	pelts
welts	8	52	2519	1	welts
abeles	8	47	1939	2	abeles
abets	7	56	2167	2	abe_ts
alts	4	66	3990	2	_alts
bahts	10	56	1780	2	bahts
baits	7	66	3058	2	baits
balas	7	69	3721	2	balas
balds	8	55	2464	2	balds
bales	7	62	5008	2	bales
balks	11	49	2629	2	balks
balls	7	62	3641	2	balls
balms	9	57	2392	2	balms
bals	6	63	5404	2	bal_s
basts	7	59	3693	2	basts
bats	6	69	6233	2	b_ats
batts	7	67	2756	2	batts
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
beans	7	57	3469	2	beans
bears	7	57	3904	2	bears
beast	7	63	3864	2	beast
beasts	8	45	1972	2	beasts
beat	6	61	6830	2	beat_
beaus	7	51	2711	2	beaus
beauts	8	60	1528	2	beauts
becks	13	55	2201	2	becks
beds	7	59	3778	2	be_ds
beefs	10	56	1856	2	beefs
beeps	9	53	2097	2	beeps
beers	7	56	2839	2	beers
bees	6	54	5338	2	be_es
beet	6	64	5754	2	beet_
befits	11	47	1150	2	befits
begets	9	62	1552	2	begets
begs	7	57	3383	2	be_gs
bel	5	71	4846	2	bel__
belay	10	50	2152	2	belay
belays	11	43	1385	2	belays
belch	12	44	1550	2	belch
belga	8	3	1323	2	belga
belgas	9	3	1171	2	belgas
belie	7	56	3038	2	belie
belies	8	46	3105	2	belies
bell	6	62	3718	2	bel_l
belle	7	58	2783	2	belle
belles	8	53	2599	2	belles
belly	10	46	2549	2	belly
belon	7	39	2411	2	belon
belons	8	41	1941	2	belons
below	10	46	1719	2	below
belows	11	46	1418	2	belows
belted	9	40	2063	2	belted
belter	8	47	2096	2	belter
belters	9	38	1941	2	belters
bemas	9	64	2428	2	bemas
bends	8	56	2897	2	bends
benes	7	55	3623	2	benes
bens	6	59	4570	2	be_ns
bent	6	77	5991	2	bent_
bento	7	59	2295	2	bento
bentos	8	62	1830	2	bentos
berets	8	58	2252	2	berets
bergs	8	47	1804	2	bergs
berks	11	54	2312	2	berks
berms	9	53	2366	2	berms
berth	10	49	1788	2	berth
berths	11	47	1242	2	berths
bes	5	65	5743	2	be__s
beses	7	58	3072	2	beses
besets	8	57	1880	2	besets
besots	8	64	1545	2	besots
best	6	63	5532	2	best_
bet	5	83	7667	2	be_t_
beta	6	62	3413	2	be_ta
betas	7	55	2876	2	betas
beth	9	66	2923	2	be_th
beths	10	55	1922	2	beths
betta	7	49	1684	2	betta
bettas	8	49	1392	2	bettas
beys	9	138	2955	2	be_ys
bhuts	10	58	1295	2	bhuts
bields	9	41	1000	2	bields
biles	7	55	4214	2	biles
bilks	11	51	1789	2	bilks
bills	7	56	3286	2	bills
bints	7	61	3018	2	bints
bits	6	61	4816	2	b_its
bitts	7	50	2259	2	bitts
blats	7	51	3250	2	blats
bleats	8	55	1861	2	bleats
blebs	9	64	1615	2	blebs
bless	7	59	1781	2	bless
blest	7	64	3172	2	blest
blet	6	62	4767	2	blet_
blots	7	56	2617	2	blots
boats	7	56	3515	2	boats
bolas	7	47	3376	2	bolas
bolds	8	58	2528	2	bolds
boles	7	54	4860	2	boles
bolls	7	55	3131	2	bolls
bolos	7	55	3137	2	bolos
bolt	6	62	5417	2	bolt_
bolus	7	91	2554	2	bolus
boots	7	58	3797	2	boots
borts	7	67	3545	2	borts
bots	6	64	5395	2	b_ots
botts	7	52	2486	2	botts
bouts	7	51	3131	2	bouts
brats	7	53	3601	2	brats
brents	8	47	1727	2	brents
brits	7	64	3308	2	brits
bruts	7	59	2295	2	bruts
bulbs	9	60	1693	2	bulbs
bulks	11	59	2061	2	bulks
bulls	7	56	2957	2	bulls
bunts	7	57	2980	2	bunts
busts	7	52	2769	2	busts
buts	6	72	4769	2	b_uts
butts	7	58	2425	2	butts
cells	7	54	2806	2	cells
cels	6	55	3497	2	cel_s
celt	6	56	4671	2	celt_
cents	7	47	3033	2	cents
colts	7	66	3329	2	colts
cults	7	50	2255	2	cults
debts	8	64	1837	2	debts
deets	6	53	3024	2	deets
deles	6	51	3925	2	deles
delfs	9	49	1867	2	delfs
delfts	10	43	967	2	delfts
delis	6	49	2854	2	delis
dells	6	66	3094	2	dells
dels	5	67	4547	2	del_s
delt	5	78	5527	2	delt_
delta	6	61	1777	2	delta
deltas	7	44	1482	2	deltas
dents	6	50	3180	2	dents
dolts	6	56	2631	2	dolts
eats	4	70	5487	2	_eats
eels	4	65	3674	2	eel_s
efts	7	65	1948	2	_efts
elds	5	63	2485	2	_elds
elks	8	58	2003	2	_elks
ells	4	64	3135	2	_ells
elms	6	73	2270	2	_elms
els	3	76	4572	2	_el_s
feats	8	64	3275	2	feats
fells	8	53	2738	2	fells
felt	7	51	4693	2	felt_
fests	8	58	2804	2	fests
fets	7	53	4594	2	fe_ts
gelds	7	51	1834	2	gelds
gels	5	68	3610	2	gel_s
gelt	5	64	4801	2	gelt_
gents	6	57	2961	2	gents
gests	6	60	2881	2	gests
gets	5	54	4248	2	ge_ts
gilts	6	49	2426	2	gilts
halts	8	52	3010	2	halts
heats	8	58	3840	2	heats
hefts	11	62	1815	2	hefts
hells	8	50	3204	2	hells
helms	10	56	1946	2	helms
helos	8	49	2806	2	helos
helots	9	52	1770	2	helots
helps	10	52	1934	2	helps
hents	8	73	3074	2	hents
hests	8	58	2993	2	hests
hets	7	55	4720	2	he_ts
hilts	8	69	2441	2	hilts
holts	8	56	2791	2	holts
jells	12	55	2216	2	jells
jests	12	59	2245	2	jests
jets	11	58	3410	2	je_ts
jilts	12	47	1741	2	jilts
jolts	12	50	1888	2	jolts
keets	9	51	2348	2	keets
kelps	11	51	1642	2	kelps
kelt	8	53	4319	2	kelt_
kilts	9	51	2218	2	kilts
leets	5	49	2712	2	leets
lefts	8	65	1781	2	lefts
lets	4	71	4794	2	le_ts
lilts	5	58	2280	2	lilts
malts	7	63	3175	2	malts
meats	7	50	3405	2	meats
meets	7	42	2461	2	meets
melds	8	48	2238	2	melds
mells	7	50	3133	2	mells
mels	6	59	4153	2	mel_s
melt	6	57	5289	2	melt_
melty	10	49	1836	2	melty
milts	7	54	3071	2	milts
molts	7	60	3209	2	molts
neats	5	59	3190	2	neats
nerts	5	59	2498	2	nerts
nests	5	57	2800	2	nests
nets	4	59	4153	2	ne_ts
netts	5	53	2072	2	netts
newts	8	60	1528	2	newts
obelus	8	34	840	2	obelus
peats	7	61	4019	2	peats
peles	7	57	3808	2	peles
pelfs	10	50	1629	2	pelfs
pelt	6	76	5108	2	pelt_
pests	7	59	3327	2	pests
pets	6	62	4833	2	pe_ts
relets	6	40	2567	2	relets
rents	5	59	3518	2	rents
rests	5	49	3587	2	rests
rets	4	53	5256	2	re_ts
salts	5	54	3188	2	salts
seats	5	48	4434	2	seats
sects	7	56	2289	2	sects
selfs	8	52	2024	2	selfs
sells	5	51	3443	2	sells
sels	4	63	4598	2	sel_s
septs	7	54	2060	2	septs
sets	4	55	4950	2	se_ts
setts	5	51	2432	2	setts
sexts	12	51	1838	2	sexts
silts	5	53	3082	2	silts
smelts	8	54	1277	2	smelts
spelts	8	46	1464	2	spelts
teats	5	56	3681	2	teats
teles	5	45	3600	2	teles
tells	5	58	2894	2	tells
telos	5	54	2452	2	telos
tels	4	68	4169	2	tel_s
tents	5	64	3421	2	tents
tests	5	65	3019	2	tests
tets	4	58	4746	2	te_ts
texts	12	55	1504	2	texts
tilts	5	53	2561	2	tilts
unbelts	9	23	766	2	unbelts
velds	9	56	1558	2	velds
veldts	10	41	775	2	veldts
vents	8	61	2593	2	vents
verts	8	57	2473	2	verts
vests	8	53	2598	2	vests
vets	7	68	3509	2	ve_ts
volts	8	54	2129	2	volts
weets	8	54	2772	2	weets
wefts	11	67	1549	2	wefts
welds	9	47	1916	2	welds
wells	8	54	2619	2	wells
welt	7	55	4786	2	welt_
wests	8	57	2700	2	wests
wets	7	59	4029	2	we_ts
wilts	8	50	2350	2	wilts
yelks	12	64	1362	2	yelks
yells	8	58	2194	2	yells
yelps	10	57	1299	2	yelps
yetts	8	67	1513	2	yetts
zests	14	54	1974	2	zests

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	53800	0.313	570897.8
2	DLD Change Limit	53800	274	1.406	38264.6
3	Display Results	274	274	0.076	3605.3
	(SQL Overall)	178691	274	1.795	99549.3