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

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

287 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
vide	8	54	3277	(None)
aide	5	60	4501	1	aide
bide	7	60	4151	1	bide
eide	5	58	3225	1	eide
hide	8	51	3465	1	hide
nide	5	55	3580	1	nide
ride	5	59	4514	1	ride
side	5	54	4450	1	side
tide	5	52	3739	1	tide
vibe	9	51	2451	1	vibe
vice	9	57	3286	1	vice
vid	7	72	4182	1	vid_
video	9	60	1496	1	video
vids	8	56	2755	1	vids
vie	6	54	4764	1	vi_e
vied	8	63	2864	1	vied
vile	7	61	3981	1	vile
vine	7	56	4369	1	vine
vise	7	56	3268	1	vise
vive	10	54	2663	1	vive
wide	8	52	3542	1	wide
abide	8	62	2372	2	abide
aid	4	92	6909	2	aid_
aided	7	58	2894	2	aided
aider	6	54	3114	2	aider
aides	6	53	3661	2	aides
aids	5	78	4637	2	aids
amide	8	61	2849	2	amide
aside	6	51	2209	2	aside
avid	8	83	2597	2	avid_
azide	15	56	1717	2	azide
bade	7	51	4089	2	bade
bice	8	62	3557	2	bice
bid	6	77	5182	2	bid_
bided	9	54	2497	2	bided
bider	8	57	2838	2	bider
bides	8	55	3678	2	bides
bidet	8	49	3563	2	bidet
bidi	7	82	2660	2	bidi
bids	7	58	3846	2	bids
bike	10	65	3261	2	bike
bile	6	61	4719	2	bile
bine	6	66	5087	2	bine
bise	6	64	3711	2	bise
bite	6	65	4701	2	bite
bize	15	59	2630	2	bize
bode	7	58	3876	2	bode
bride	8	64	2554	2	bride
cade	7	64	4392	2	cade
cede	7	49	2878	2	cede
chide	11	53	2102	2	chide
cider	8	47	2332	2	cider
cine	6	62	4295	2	cine
cire	6	58	3638	2	cire
cite	6	56	4035	2	cite
code	7	73	4774	2	code
de	3	70	4955	2	__de
dice	7	58	4190	2	dice
did	5	68	5053	2	did_
didie	7	41	2057	2	didie
dido	6	65	2821	2	dido
didy	9	91	2152	2	didy
die	4	67	5966	2	di_e
died	6	61	3786	2	died
dike	9	59	3577	2	dike
dime	7	62	3765	2	dime
dine	5	55	5534	2	dine
diode	7	47	1612	2	diode
dire	5	66	4415	2	dire
dite	5	55	4756	2	dite
dive	8	56	3478	2	dive
divide	11	34	1089	2	divide
dude	6	56	2967	2	dude
eider	6	46	2475	2	eider
elide	6	49	2265	2	elide
evade	9	3	818	2	evade
evite	8	53	1768	2	evite
fade	8	57	3635	2	fade
fice	9	57	3712	2	fice
fid	7	68	4770	2	fid_
fidge	10	45	1607	2	fidge
fido	8	77	2641	2	fido
fids	8	70	3475	2	fids
fie	6	71	5245	2	fi_e
fife	10	60	2771	2	fife
file	7	54	4665	2	file
fine	7	51	4796	2	fine
fire	7	62	4560	2	fire
five	10	76	2975	2	five
gibe	7	59	2779	2	gibe
gid	5	70	4728	2	gid_
gids	6	59	3375	2	gids
gie	4	71	4955	2	gi_e
gied	6	46	3199	2	gied
gite	5	54	3862	2	gite
give	8	58	2936	2	give
glide	7	45	2160	2	glide
gride	7	52	2359	2	gride
gude	6	54	2334	2	gude
guide	7	50	1989	2	guide
hade	8	54	4020	2	hade
hid	7	62	4839	2	hid_
hided	10	52	2245	2	hided
hider	9	50	2409	2	hider
hides	9	51	2943	2	hides
hie	6	76	5271	2	hi_e
hied	8	54	3405	2	hied
hike	11	68	3040	2	hike
hire	7	55	3897	2	hire
hive	10	60	2968	2	hive
ice	5	67	3725	2	_ice
id	3	89	4185	2	_id_
idea	5	91	2278	2	_idea
idem	7	61	2107	2	_idem
ides	5	77	3424	2	_ides
idle	5	54	2377	2	_idle
ids	4	75	3548	2	_ids
imide	8	57	1690	2	imide
ire	3	69	4318	2	_ire
ivied	9	47	1052	2	ivied
jade	12	53	2545	2	jade
jibe	13	63	2340	2	jibe
jive	14	61	2360	2	jive
kibe	10	65	2346	2	kibe
kid	8	65	4063	2	kid_
kids	9	60	2965	2	kids
kike	7	65	2480	2	kike
kine	8	56	4344	2	kine
kite	8	53	3825	2	kite
lade	5	63	4599	2	lade
lice	6	60	4507	2	lice
lid	4	74	5353	2	lid_
lido	5	60	2817	2	lido
lids	5	63	3647	2	lids
lie	3	82	6453	2	li_e
lied	5	58	3810	2	lied
life	7	54	3374	2	life
like	8	60	4085	2	like
lime	6	62	4494	2	lime
line	4	69	6558	2	line
lipe	6	68	3974	2	lipe
lire	4	78	4530	2	lire
lite	4	70	5455	2	lite
live	7	65	4100	2	live
lode	5	62	4012	2	lode
lude	5	53	3165	2	lude
made	7	54	4025	2	made
mice	8	74	4224	2	mice
mid	6	73	5448	2	mid_
midge	9	50	1656	2	midge
midi	7	56	2849	2	midi
mids	7	65	4180	2	mids
mike	10	55	3530	2	mike
mile	6	63	5258	2	mile
mime	8	57	3641	2	mime
mine	6	72	5618	2	mine
mire	6	67	4824	2	mire
mise	6	60	4359	2	mise
mite	6	62	4942	2	mite
mode	7	58	4031	2	mode
nice	6	55	3472	2	nice
nided	7	59	2088	2	nided
nides	6	52	2914	2	nides
nidi	5	65	2441	2	nidi
nine	4	58	4218	2	nine
nite	4	59	4359	2	nite
nixe	11	57	2203	2	nixe
node	5	130	3689	2	node
nude	5	66	2628	2	nude
ode	4	74	4659	2	_ode
ovine	8	63	1664	2	ovine
oxide	13	12	1096	2	oxide
pice	8	46	4110	2	pice
pie	5	54	5741	2	pi_e
pied	7	50	3537	2	pied
pike	10	63	3522	2	pike
pile	6	56	4970	2	pile
pine	6	77	5572	2	pine
pipe	8	64	3444	2	pipe
pride	8	47	2474	2	pride
rede	5	50	3768	2	rede
rice	6	49	4292	2	rice
rid	4	67	5464	2	rid_
rider	6	52	3131	2	rider
rides	6	61	4082	2	rides
ridge	7	50	1868	2	ridge
rids	5	65	3956	2	rids
rife	7	46	3233	2	rife
rile	4	56	5054	2	rile
rime	6	51	3889	2	rime
ripe	6	60	3893	2	ripe
rise	4	59	4524	2	rise
rite	4	58	4946	2	rite
rive	7	55	3773	2	rive
rode	5	58	4431	2	rode
rude	5	56	3279	2	rude
sade	5	55	4448	2	sade
sice	6	55	4560	2	sice
sided	7	48	2596	2	sided
sides	6	58	3837	2	sides
sidh	8	62	2300	2	sidh
sidhe	9	53	1511	2	sidhe
sidle	6	51	2404	2	sidle
sike	8	71	3879	2	sike
sine	4	65	6063	2	sine
sipe	6	73	4105	2	sipe
sire	4	61	5042	2	sire
site	4	70	5242	2	site
size	13	56	3097	2	size
slide	6	47	2542	2	slide
snide	6	43	1873	2	snide
tided	7	63	2252	2	tided
tides	6	48	3016	2	tides
tidy	8	68	2243	2	tidy
tie	3	65	5754	2	ti_e
tied	5	55	3522	2	tied
tike	8	55	3449	2	tike
tilde	6	50	1735	2	tilde
tile	4	54	5145	2	tile
time	6	62	3502	2	time
tine	4	58	5514	2	tine
tire	4	61	4336	2	tire
unde	5	58	2549	2	unde
vale	7	49	3734	2	vale
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
vee	6	57	5018	2	v_ee
via	6	56	3625	2	vi_a
vial	7	67	3110	2	vial
vibes	10	47	1995	2	vibes
viced	11	51	1818	2	viced
vices	10	57	2553	2	vices
videos	10	49	1137	2	videos
vier	7	54	2816	2	vier
vies	7	52	3863	2	vies
view	10	59	1768	2	view
vig	7	56	3753	2	vi_g
viga	8	56	2297	2	viga
vigs	8	54	2728	2	vigs
viler	8	63	2416	2	viler
vill	7	52	3508	2	vill
vim	8	74	3703	2	vi_m
vimen	10	41	1475	2	vimen
vims	9	54	2332	2	vims
vina	7	63	3181	2	vina
vined	9	56	2615	2	vined
vines	8	51	3764	2	vines
vino	7	61	2844	2	vino
viny	10	60	2596	2	viny
viol	7	65	2360	2	viol
viper	10	50	1730	2	viper
vireo	8	48	1645	2	vireo
vires	8	45	2968	2	vires
virl	7	62	2448	2	virl
vis	6	67	4762	2	vi_s
visa	7	63	2388	2	visa
vised	9	55	1876	2	vised
vises	8	44	2777	2	vises
vita	7	58	2853	2	vita
vitae	8	42	1763	2	vitae
viva	10	61	1910	2	viva
vixen	15	30	1002	2	vixen
voe	6	77	3905	2	v_oe
voice	10	49	1532	2	voice
void	8	62	2057	2	void_
voided	11	40	1113	2	voided
voider	10	36	1155	2	voider
voids	9	54	1468	2	voids
voile	8	47	1972	2	voile
vole	7	52	3698	2	vole
vote	7	47	2862	2	vote
wade	8	52	3707	2	wade
widen	9	47	1798	2	widen
wider	9	48	2636	2	wider
wides	9	48	3283	2	wides
wife	10	52	2803	2	wife
wile	7	59	4438	2	wile
wine	7	49	5343	2	wine
wipe	9	48	3029	2	wipe
wire	7	58	3982	2	wire
wise	7	57	3735	2	wise
wite	7	54	4328	2	wite
wive	10	59	3176	2	wive
yid	7	66	4084	2	yid_
yids	8	52	2497	2	yids
yipe	9	67	2219	2	yipe
zine	13	70	3616	2	zine

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.280	638182.1
2	DLD Change Limit	29872	287	0.890	33564.0
3	Display Results	287	287	0.063	4555.6
	(SQL Overall)	178691	287	1.233	144923.8