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

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

337 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
rants	5	59	3534	(None)
ants	4	72	4347	1	_ants
brants	8	57	2305	1	brants
cants	7	70	3694	1	cants
grants	7	37	2247	1	grants
hants	8	63	3540	1	hants
pants	7	65	3692	1	pants
rafts	8	78	2063	1	rafts
rands	6	59	3045	1	rands
ranis	5	52	3583	1	ranis
ranks	9	52	2573	1	ranks
rant	4	58	6468	1	rant_
rats	4	62	6037	1	ra_ts
rents	5	59	3518	1	rents
runts	5	59	2763	1	runts
wants	8	79	3221	1	wants
acts	6	69	2986	2	_acts
aits	4	63	5553	2	_aits
alants	6	77	2202	2	alants
alts	4	66	3990	2	_alts
anas	4	66	4986	2	_anas
ands	5	78	3361	2	_ands
anes	4	52	5593	2	_anes
anis	4	57	4646	2	_anis
ant	3	72	7079	2	_ant_
anta	4	68	3958	2	_anta
antas	5	54	3203	2	_antas
ante	4	65	3890	2	_ante
antes	5	63	3432	2	_antes
anti	4	55	3636	2	_anti
antis	5	50	3331	2	_antis
antsy	8	57	1279	2	_antsy
anus	4	71	3111	2	_anus
arts	4	96	5026	2	_arts
aunts	5	52	2763	2	aunts
bahts	10	56	1780	2	bahts
baits	7	66	3058	2	baits
bands	8	52	3343	2	bands
banes	7	49	4558	2	banes
bangs	8	56	2778	2	bangs
banks	11	55	2790	2	banks
banns	7	53	2123	2	banns
bans	6	65	5514	2	ban_s
banty	10	66	2400	2	banty
basts	7	59	3693	2	basts
bats	6	69	6233	2	ba_ts
batts	7	67	2756	2	batts
bents	7	60	3369	2	bents
bints	7	61	3018	2	bints
bracts	10	56	1777	2	bracts
brands	9	51	1894	2	brands
branks	12	48	1738	2	branks
brans	7	54	3743	2	bran_s
brant	7	47	4217	2	brant_
brats	7	53	3601	2	bra_ts
brents	8	47	1727	2	brents
brunts	8	52	1545	2	brunts
bunts	7	57	2980	2	bunts
canes	7	53	5037	2	canes
cans	6	50	5085	2	can_s
canst	7	49	3221	2	canst
cant	6	63	6203	2	cant_
canto	7	49	3101	2	canto
cantos	8	48	2697	2	cantos
cantus	8	51	1776	2	cantus
canty	10	52	2680	2	canty
carts	7	89	4629	2	carts
casts	7	72	3779	2	casts
cats	6	63	5634	2	ca_ts
cents	7	47	3033	2	cents
chants	11	50	2039	2	chants
crafts	11	53	1274	2	crafts
cranes	8	43	3075	2	cranes
cranks	12	50	1531	2	cranks
cunts	7	61	2512	2	cunts
dangs	7	56	2321	2	dangs
dans	5	67	4815	2	dan_s
darts	6	76	3573	2	darts
daunts	7	50	1408	2	daunts
dauts	6	78	2224	2	dauts
dawts	9	72	1612	2	dawts
dents	6	50	3180	2	dents
dints	6	74	3131	2	dints
drafts	10	50	1253	2	drafts
drats	6	66	2837	2	dra_ts
dunts	6	58	2841	2	dunts
easts	5	75	3032	2	easts
eats	4	70	5487	2	ea_ts
errants	7	4	1064	2	errants
facts	10	70	2189	2	facts
faints	9	48	1878	2	faints
fanes	8	46	3989	2	fanes
fangs	9	62	2408	2	fangs
fanos	8	59	2650	2	fanos
fans	7	62	4737	2	fan_s
farts	8	83	3684	2	farts
fasts	8	64	2968	2	fasts
fats	7	62	5250	2	fa_ts
fonts	8	61	2475	2	fonts
francs	11	41	1219	2	francs
franks	13	49	1273	2	franks
frats	8	68	2967	2	fra_ts
fronts	9	44	1579	2	fronts
gaits	6	57	2601	2	gaits
gangs	7	62	2258	2	gangs
gasts	6	66	2863	2	gasts
gats	5	67	5344	2	ga_ts
gents	6	57	2961	2	gents
giants	7	47	1350	2	giants
gnats	6	52	1771	2	gnats
grafts	10	50	1325	2	grafts
grands	8	42	1824	2	grands
grans	6	48	3254	2	gran_s
grant	6	48	4002	2	grant_
grunts	7	55	1185	2	grunts
haets	8	65	2512	2	haets
hafts	11	62	1946	2	hafts
haints	9	44	1758	2	haints
halts	8	52	3010	2	halts
hands	9	53	2738	2	hands
hangs	9	57	2673	2	hangs
hanks	12	62	2686	2	hanks
hant	7	54	6159	2	hant_
harts	8	84	4159	2	harts
hats	7	68	5825	2	ha_ts
haunts	9	56	1439	2	haunts
hents	8	73	3074	2	hents
hints	8	73	3062	2	hints
hunts	8	68	2617	2	hunts
janes	12	49	2812	2	janes
janty	15	68	1696	2	janty
jaunts	13	75	1188	2	jaunts
jurants	14	37	921	2	jurants
kanas	9	53	2691	2	kanas
kanes	9	55	2937	2	kanes
karts	9	76	3011	2	karts
kats	8	59	4433	2	ka_ts
krafts	13	43	885	2	krafts
kraits	10	49	1220	2	kraits
krauts	10	41	851	2	krauts
lands	6	54	2690	2	lands
lanes	5	49	4679	2	lanes
lasts	5	77	3126	2	lasts
lats	4	59	6270	2	la_ts
lints	5	71	3719	2	lints
lunts	5	58	2690	2	lunts
malts	7	63	3175	2	malts
manas	7	62	4043	2	manas
manats	8	46	2346	2	manats
manes	7	66	4896	2	manes
manos	7	49	3362	2	manos
mans	6	63	5455	2	man_s
manta	7	56	2991	2	manta
mantas	8	57	2536	2	mantas
mantes	8	44	3078	2	mantes
mantis	8	39	2603	2	mantis
manus	7	59	2493	2	manus
marts	7	74	4223	2	marts
masts	7	70	3576	2	masts
mats	6	54	6029	2	ma_ts
matts	7	68	2918	2	matts
mauts	7	59	2719	2	mauts
mints	7	68	3404	2	mints
nanas	5	59	2863	2	nanas
nans	4	61	3940	2	nan_s
oasts	5	65	2918	2	oasts
oats	4	65	5421	2	oa_ts
orangs	7	41	1603	2	orangs
pacts	9	51	2580	2	pacts
paints	8	59	2183	2	paints
panes	7	61	4869	2	panes
pangs	8	46	2867	2	pangs
pans	6	58	5573	2	pan_s
pant	6	60	6126	2	pant_
panto	7	61	2941	2	panto
pantos	8	52	2274	2	pantos
panty	10	59	2930	2	panty
parts	7	77	4337	2	parts
pasts	7	59	3650	2	pasts
pats	6	64	6085	2	pa_ts
pints	7	59	3622	2	pints
plants	8	49	2180	2	plants
prangs	9	48	1623	2	prangs
pranks	12	48	1472	2	pranks
prats	7	63	3339	2	pra_ts
prints	8	43	2010	2	prints
punts	7	58	2800	2	punts
qanats	15	41	1281	2	qanats
qats	13	53	3134	2	qa_ts
quants	15	36	1414	2	quants
rabats	8	31	1622	2	rabats
races	7	49	4324	2	races
racks	11	50	2885	2	racks
rads	5	60	4660	2	ra_ds
raffs	11	50	1752	2	raffs
raft	7	62	4591	2	raft_
ragas	6	53	2606	2	ragas
rages	6	45	3944	2	rages
raggs	7	52	1647	2	raggs
ragis	6	63	2560	2	ragis
rags	5	54	4837	2	ra_gs
raias	5	46	3112	2	raias
raids	6	58	2751	2	raids
rails	5	59	3740	2	rails
rains	5	51	4023	2	rains
rais	4	52	5262	2	ra_is
raita	5	46	2307	2	raita
raitas	6	44	1767	2	raitas
rajas	12	73	1772	2	rajas
rajes	12	50	2278	2	rajes
rakes	9	44	4035	2	rakes
rakis	9	53	2344	2	rakis
rakus	9	44	1367	2	rakus
rales	5	49	4749	2	rales
ramets	8	35	1739	2	ramets
ramps	9	62	2463	2	ramps
rams	6	59	5077	2	ra_ms
ramus	7	64	1828	2	ramus
ran	3	82	6662	2	ran__
rance	7	50	2851	2	rance
rances	8	46	2544	2	rances
ranch	10	50	1979	2	ranch
rand	5	58	3957	2	ran_d
randy	9	50	2208	2	randy
ranee	5	54	3810	2	ranee
ranees	6	46	2396	2	ranees
rang	5	69	3917	2	ran_g
range	6	47	2842	2	range
ranges	7	38	2693	2	ranges
rangy	9	53	2039	2	rangy
rani	4	66	4011	2	ran_i
ranid	6	64	2933	2	ranid
ranids	7	51	1870	2	ranids
rank	8	51	3553	2	ran_k
ranted	7	43	2470	2	ranted
ranter	6	38	2682	2	ranter
ranters	7	33	2364	2	ranters
rapes	7	57	4072	2	rapes
raps	6	62	4773	2	ra_ps
rapt	6	72	4531	2	rapt_
rares	5	52	4744	2	rares
ras	3	75	7539	2	ra__s
rases	5	54	4721	2	rases
rasps	7	43	1666	2	rasps
rat	3	78	9274	2	ra_t_
rate	4	54	5876	2	ra_te
rates	5	53	5201	2	rates
rath	7	60	3766	2	ra_th
rato	4	54	3697	2	ra_to
ratos	5	55	2876	2	ratos
ratty	8	48	1959	2	ratty
raves	8	54	4197	2	raves
raws	7	52	3821	2	ra_ws
raxes	12	47	2939	2	raxes
rayas	8	59	2205	2	rayas
rays	7	76	4235	2	ra_ys
razes	14	50	3270	2	razes
reacts	8	36	1660	2	reacts
recants	9	32	1709	2	recants
rends	6	51	2995	2	rends
rent	4	66	6124	2	rent_
rente	5	47	3378	2	rente
rentes	6	54	3119	2	rentes
rests	5	49	3587	2	rests
rets	4	53	5256	2	r_ets
riant	5	58	3315	2	riant_
rifts	8	57	1864	2	rifts
rinds	6	48	2614	2	rinds
rings	6	50	2917	2	rings
rinks	9	48	2710	2	rinks
rins	4	61	5319	2	rin_s
riots	5	49	2201	2	riots
roans	5	49	2644	2	roan_s
roasts	6	49	1541	2	roasts
roots	5	59	3367	2	roots
rots	4	64	5409	2	r_ots
routs	5	71	3341	2	routs
ruanas	6	3	1126	2	ruanas
runes	5	55	3022	2	runes
rungs	6	118	1940	2	rungs
runs	4	64	3808	2	run_s
runt	4	66	4799	2	runt_
runty	8	61	1904	2	runty
rusts	5	50	2699	2	rusts
ruts	4	45	4149	2	r_uts
rynds	9	56	997	2	rynds
ryots	8	53	1378	2	ryots
saints	6	51	2242	2	saints
salts	5	54	3188	2	salts
sands	6	52	2858	2	sands
sanes	5	56	4907	2	sanes
sans	4	51	5336	2	san_s
santo	5	62	2728	2	santo
santos	6	44	2183	2	santos
scants	8	52	1972	2	scants
slants	6	48	1908	2	slants
tacts	7	65	2412	2	tacts
taints	6	45	2053	2	taints
tangs	6	50	2836	2	tangs
tanks	9	46	2474	2	tanks
tans	4	61	5483	2	tan_s
tanto	5	57	2495	2	tanto
tarts	5	72	4202	2	tarts
tats	4	68	5813	2	ta_ts
taunts	6	57	1566	2	taunts
tauts	5	61	2551	2	tauts
tents	5	64	3421	2	tents
tints	5	60	3092	2	tints
tracts	8	50	1907	2	tracts
traits	6	51	2198	2	traits
tranks	10	40	1776	2	tranks
tranqs	15	52	1031	2	tranqs
trans	5	49	3304	2	tran_s
truants	7	3	816	2	truants
tyrants	10	3	745	2	tyrants
vanes	8	51	3097	2	vanes
vangs	9	63	1959	2	vangs
vans	7	62	3673	2	van_s
vasts	8	64	2377	2	vasts
vats	7	68	4174	2	va_ts
vaunts	9	52	1262	2	vaunts
vents	8	61	2593	2	vents
wafts	11	69	2055	2	wafts
waits	8	83	3352	2	waits
wands	9	64	2548	2	wands
wanes	8	50	4088	2	wanes
wanks	12	61	2448	2	wanks
wans	7	64	5227	2	wan_s
want	7	61	5617	2	want_
warts	8	148	4040	2	warts
wasts	8	74	3367	2	wasts
wats	7	75	5588	2	wa_ts
watts	8	69	2309	2	watts
wonts	8	76	2154	2	wonts
wrangs	10	46	1191	2	wrangs
yangs	9	56	1870	2	yangs
yanks	12	53	1657	2	yanks

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.296	603685.8
2	DLD Change Limit	53800	337	1.890	28465.6
3	Display Results	337	337	0.093	3623.7
	(SQL Overall)	178691	337	2.279	78407.6