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

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

306 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
vims	9	54	2332	(None)
aims	6	77	3819	1	aims
dims	7	54	3503	1	dims
hims	9	52	3098	1	hims
nims	6	62	2689	1	nims
rims	6	59	3631	1	rims
sims	6	57	3718	1	sims
vids	8	56	2755	1	vids
vies	7	52	3863	1	vies
vigs	8	54	2728	1	vigs
vim	8	74	3703	1	vim_
vis	6	67	4762	1	vi_s
aids	5	78	4637	2	aids
ails	4	56	5472	2	ails
aim	5	78	5822	2	aim_
ains	4	61	5889	2	ains
airs	4	64	4743	2	airs
ais	3	90	8358	2	ai_s
aits	4	63	5554	2	aits
alms	6	58	3492	2	alms
amis	6	64	4532	2	amis
arms	6	61	3750	2	arms
bams	8	70	4445	2	bams
bias	6	47	3817	2	bias
bibs	8	48	3100	2	bibs
bids	7	58	3846	2	bids
bigs	7	62	3503	2	bigs
bima	8	67	2384	2	bima
bimas	9	55	2174	2	bimas
bins	6	65	4826	2	bins
bios	6	63	3533	2	bios
bis	5	68	6067	2	bi_s
bits	6	61	4817	2	bits
brims	9	47	2162	2	brims
bums	8	59	3459	2	bums
cams	8	70	4728	2	cams
cigs	7	56	2511	2	cigs
cis	5	77	4804	2	ci_s
cwms	11	43	957	2	cwms
dams	7	74	4437	2	dams
dibs	7	62	3369	2	dibs
dies	5	56	5353	2	dies
difs	8	60	2733	2	difs
digs	6	60	3606	2	digs
dim	6	81	4650	2	dim_
dime	7	62	3765	2	dime
dimes	8	58	3304	2	dimes
dins	5	66	5205	2	dins
dips	7	55	3692	2	dips
dis	4	64	5990	2	di_s
diss	5	64	3449	2	diss
dits	5	64	5053	2	dits
doms	7	62	3957	2	doms
elms	6	73	2270	2	elms
ems	5	64	3549	2	_ems
evils	8	41	1426	2	evils
fems	9	64	2870	2	fems
fibs	9	63	2951	2	fibs
fids	8	70	3475	2	fids
figs	8	53	3265	2	figs
films	10	56	1796	2	films
fils	7	58	3870	2	fils
fins	7	58	4910	2	fins
firms	10	52	1742	2	firms
firs	7	66	3772	2	firs
fits	7	60	4347	2	fits
gams	7	66	4888	2	gams
gems	7	53	2911	2	gems
gibs	7	55	2928	2	gibs
gids	6	59	3375	2	gids
gies	5	56	4143	2	gies
gigs	6	66	3119	2	gigs
gimp	9	61	2405	2	gimp
gimps	10	59	1520	2	gimps
gins	5	55	4396	2	gins
gips	7	56	3293	2	gips
gits	5	57	4460	2	gits
glims	8	74	1767	2	glims
gums	7	50	3094	2	gums
gyms	10	75	1459	2	gyms
hams	9	64	4613	2	hams
hems	9	55	3494	2	hems
hies	7	48	4284	2	hies
him	8	62	4767	2	him_
hins	7	64	4800	2	hins
hips	9	64	3371	2	hips
his	6	63	5951	2	hi_s
hiss	7	56	2922	2	hiss
hits	7	55	4514	2	hits
hums	9	68	3142	2	hums
ids	4	75	3548	2	_ids
ifs	6	71	2425	2	_ifs
imp	7	66	2698	2	_imp
imps	8	62	2112	2	_imps
ins	3	59	4561	2	_ins
is	2	70	4822	2	_i_s
ism	5	63	2239	2	_ism
isms	6	62	1347	2	isms
its	3	55	3884	2	_its
ivies	8	42	1576	2	ivies
jams	13	52	3107	2	jams
jibs	13	67	2409	2	jibs
jigs	12	65	2477	2	jigs
jimp	15	56	1847	2	jimp
jins	11	56	3502	2	jins
jism	13	55	1478	2	jism
jisms	14	45	800	2	jisms
kids	9	60	2965	2	kids
kifs	11	60	2352	2	kifs
kins	8	57	4792	2	kins
kips	10	64	3053	2	kips
kirs	8	58	3175	2	kirs
kis	7	80	5149	2	ki_s
kiss	8	52	2741	2	kiss
kits	8	64	4178	2	kits
lams	6	65	5226	2	lams
libs	6	67	3277	2	libs
lids	5	63	3647	2	lids
lies	4	64	5420	2	lies
lima	6	57	3414	2	lima
limas	7	56	2763	2	limas
limb	8	54	2939	2	limb
limbs	9	61	1894	2	limbs
lime	6	62	4494	2	lime
limes	7	56	3650	2	limes
limn	6	65	2770	2	limn
limns	7	57	1839	2	limns
limo	6	55	2974	2	limo
limos	7	53	2081	2	limos
limp	8	84	3250	2	limp
limps	9	55	2267	2	limps
limy	9	57	2772	2	limy
lins	4	70	5906	2	lins
lips	6	71	4145	2	lips
lis	3	71	6228	2	li_s
lits	4	62	5250	2	lits
lums	6	57	3424	2	lums
maims	9	63	2179	2	maims
mems	8	59	3150	2	mems
mibs	8	53	3049	2	mibs
mics	8	74	3516	2	mics
mids	7	65	4180	2	mids
migs	7	69	3533	2	migs
mils	6	60	4534	2	mils
mim	7	60	4843	2	mim_
mime	8	57	3641	2	mime
mimes	9	57	3202	2	mimes
mips	8	55	3409	2	mips
mirs	6	69	4058	2	mirs
mis	5	81	6263	2	mi_s
miss	6	53	3943	2	miss
moms	8	65	3948	2	moms
mums	8	57	3277	2	mums
nibs	6	50	2832	2	nibs
nils	4	61	3246	2	nils
nim	5	71	4296	2	nim_
nips	6	58	3093	2	nips
nits	4	57	4165	2	nits
noms	6	56	3640	2	noms
ohms	9	55	1403	2	ohms
oils	4	63	3798	2	oils
oms	5	63	3751	2	_oms
oxims	14	10	764	2	oxims
pams	8	56	4176	2	pams
pias	6	65	4256	2	pias
pics	8	56	3392	2	pics
pies	6	69	4961	2	pies
pigs	7	66	3423	2	pigs
pima	8	54	2866	2	pima
pimas	9	47	2510	2	pimas
pimp	10	60	2491	2	pimp
pimps	11	46	1698	2	pimps
pins	6	55	5846	2	pins
pips	8	58	3714	2	pips
pis	5	63	6204	2	pi_s
piss	6	50	3334	2	piss
pits	6	63	4875	2	pits
poms	8	70	3774	2	poms
prims	9	54	2593	2	prims
qis	12	69	3439	2	qi_s
rams	6	59	5077	2	rams
rems	6	62	3772	2	rems
rias	4	55	4060	2	rias
ribs	6	58	3303	2	ribs
rids	5	65	3956	2	rids
rifs	7	49	2901	2	rifs
rigs	5	51	3760	2	rigs
rim	5	60	5228	2	rim_
rime	6	51	3889	2	rime
rimes	7	56	3454	2	rimes
rimy	9	66	2129	2	rimy
rins	4	61	5320	2	rins
rips	6	62	3744	2	rips
roms	6	70	3896	2	roms
rums	6	48	3347	2	rums
shims	10	44	2255	2	shims
sibs	6	59	3355	2	sibs
sics	6	52	3410	2	sics
sim	5	65	5315	2	sim_
sima	6	47	3079	2	sima
simas	7	57	2755	2	simas
simp	8	52	2878	2	simp
simps	9	47	1976	2	simps
sins	4	67	5528	2	sins
sips	6	57	4011	2	sips
sirs	4	43	3834	2	sirs
sis	3	73	6055	2	si_s
sits	4	50	5021	2	sits
skims	11	45	1720	2	skims
slims	7	54	2365	2	slims
soms	6	62	3937	2	soms
sums	6	58	3758	2	sums
swims	10	55	1414	2	swims
tams	6	72	4793	2	tams
tics	6	57	2964	2	tics
ties	4	52	4832	2	ties
tils	4	57	3962	2	tils
time	6	62	3502	2	time
times	7	56	3082	2	times
tins	4	52	5131	2	tins
tips	6	64	3677	2	tips
tis	3	70	5665	2	ti_s
tits	4	61	4505	2	tits
toms	6	83	4349	2	toms
trims	7	50	2147	2	trims
vacs	9	62	2620	2	vacs
vails	8	58	2593	2	vails
vairs	8	50	1913	2	vairs
vamp	11	55	2154	2	vamp
vamps	12	54	1548	2	vamps
vans	7	62	3674	2	vans
vars	7	57	4207	2	vars
vas	6	77	5577	2	v_as
vats	7	68	4174	2	vats
vaus	7	59	2892	2	vaus
vavs	10	57	2043	2	vavs
vaws	10	55	2732	2	vaws
vees	7	54	3943	2	vees
veils	8	49	1880	2	veils
veins	8	46	2049	2	veins
vets	7	68	3509	2	vets
via	6	56	3625	2	vi_a
vial	7	67	3110	2	vial
vials	8	58	2238	2	vials
vibe	9	51	2451	2	vibe
vibes	10	47	1995	2	vibes
vice	9	57	3286	2	vice
vices	10	57	2553	2	vices
vid	7	72	4182	2	vi_d
vide	8	54	3277	2	vide
vie	6	54	4764	2	vi_e
vied	8	63	2864	2	vied
vier	7	54	2816	2	vier
viers	8	56	2195	2	viers
view	10	59	1768	2	view
views	11	48	964	2	views
vig	7	56	3753	2	vi_g
viga	8	56	2297	2	viga
vigas	9	48	1788	2	vigas
vile	7	61	3981	2	vile
vill	7	52	3508	2	vill
vills	8	64	2932	2	vills
vimen	10	41	1475	2	vimen
vina	7	63	3181	2	vina
vinas	8	51	2634	2	vinas
vine	7	56	4369	2	vine
vines	8	51	3764	2	vines
vino	7	61	2844	2	vino
vinos	8	47	2307	2	vinos
viny	10	60	2596	2	viny
viol	7	65	2360	2	viol
viols	8	61	1810	2	viols
vires	8	45	2968	2	vires
virl	7	62	2448	2	virl
virls	8	56	1860	2	virls
virus	8	53	1684	2	virus
visa	7	63	2388	2	visa
visas	8	43	1765	2	visas
vise	7	56	3268	2	vise
vises	8	44	2777	2	vises
vita	7	58	2853	2	vita
viva	10	61	1910	2	viva
vivas	11	48	1502	2	vivas
vive	10	54	2663	2	vive
voes	7	54	3282	2	voes
voids	9	54	1468	2	voids
vows	10	66	2694	2	vows
vugs	8	70	2287	2	vugs
vum	8	54	2865	2	vum_
whims	13	45	1533	2	whims
wigs	8	49	3126	2	wigs
wimp	11	55	2153	2	wimp
wimps	12	52	1380	2	wimps
wins	7	59	4918	2	wins
wis	6	65	5234	2	wi_s
wiss	7	56	3055	2	wiss
wits	7	60	4488	2	wits
xis	10	69	3534	2	xi_s
yams	9	53	3073	2	yams
yids	8	52	2497	2	yids
yins	7	53	3513	2	yins
yips	9	52	2671	2	yips
zigs	14	54	2280	2	zigs
zins	13	57	3501	2	zins
zips	15	57	2380	2	zips
zits	13	60	3030	2	zits

Search took 5 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	1.126	158695.4
2	DLD Change Limit	29872	306	2.576	11596.3
3	Display Results	306	306	0.266	1150.4
	(SQL Overall)	178691	306	3.968	45033.0