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

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

275 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
vier	7	54	2815	(None)
bier	6	55	3183	1	bier
kier	8	65	2680	1	kier
lier	4	59	4246	1	lier
pier	6	60	3529	1	pier
tier	4	49	3614	1	tier
veer	7	62	2957	1	veer
vie	6	54	4763	1	vie_
vied	8	63	2863	1	vied
viers	8	56	2195	1	viers
vies	7	52	3862	1	vies
view	10	59	1767	1	view
viler	8	63	2416	1	viler
viper	10	50	1730	1	viper
ager	5	59	3584	2	ager
aider	6	54	3113	2	aider
aimer	7	59	2682	2	aimer
air	3	80	5839	2	ai_r
airer	5	49	2789	2	airer
aiver	8	57	2516	2	aiver
aper	6	63	3623	2	aper
aver	7	59	3188	2	aver
beer	6	56	3599	2	beer
bider	8	57	2837	2	bider
biers	7	62	2522	2	biers
biker	11	60	2256	2	biker
biner	7	59	3069	2	biner
birr	6	60	2236	2	birr
biter	7	50	3003	2	biter
brier	7	45	2740	2	brier
cider	8	47	2331	2	cider
cire	6	58	3637	2	cire
citer	7	48	2733	2	citer
crier	7	47	2446	2	crier
deer	5	67	3902	2	deer
dicer	8	54	2642	2	dicer
die	4	67	5965	2	die_
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
diker	10	55	2455	2	diker
dimer	8	56	2560	2	dimer
diner	6	56	3290	2	diner
dire	5	66	4414	2	dire
direr	6	49	2707	2	direr
diver	9	48	2780	2	diver
doer	5	77	3470	2	doer
drier	6	44	2396	2	drier
dyer	8	55	2211	2	dyer
eger	5	59	2356	2	eger
eider	6	46	2474	2	eider
envier	9	3	967	2	envier
er	2	83	4514	2	__er
ever	7	70	2769	2	ever
eviler	9	48	1189	2	eviler
ewer	7	75	2398	2	ewer
eyer	7	61	2728	2	eyer
fer	6	66	4612	2	_fer
fiar	7	64	2733	2	fiar
fiber	10	49	2113	2	fiber
fie	6	71	5244	2	fie_
fief	10	73	3136	2	fief
fiery	11	47	1479	2	fiery
fifer	11	55	1997	2	fifer
filer	8	54	3300	2	filer
finer	8	54	3156	2	finer
fir	6	67	4489	2	fi_r
fire	7	62	4559	2	fire
firer	8	112	2925	2	firer
fiver	11	60	2494	2	fiver
fixer	15	47	1783	2	fixer
flier	8	60	2340	2	flier
frier	8	52	2584	2	frier
giber	8	54	1770	2	giber
gie	4	71	4954	2	gie_
gied	6	46	3198	2	gied
gien	5	63	3002	2	gien
gies	5	56	4142	2	gies
giver	9	49	2120	2	giver
goer	5	68	2710	2	goer
heir	7	75	2380	2	heir
her	6	65	4781	2	_her
hider	9	50	2408	2	hider
hie	6	76	5270	2	hie_
hied	8	54	3404	2	hied
hies	7	48	4283	2	hies
hiker	12	51	1939	2	hiker
hire	7	55	3896	2	hire
hirer	8	54	2312	2	hirer
hoer	7	65	3398	2	hoer
icier	7	43	1375	2	icier
ire	3	69	4317	2	_ire
ivied	9	47	1052	2	ivied
ivies	8	42	1576	2	ivies
jeer	11	54	2646	2	jeer
jiber	14	51	1570	2	jiber
jiver	15	51	1905	2	jiver
jivier	16	43	861	2	jivier
keir	8	62	1787	2	keir
kief	11	71	2840	2	kief
kiers	9	53	2009	2	kiers
kir	7	65	3567	2	ki_r
kiter	9	55	2321	2	kiter
leer	4	62	3935	2	leer
levier	9	40	1387	2	levier
liar	4	72	2968	2	liar
liber	7	47	2362	2	liber
lie	3	82	6452	2	lie_
lied	5	58	3809	2	lied
lief	7	60	3699	2	lief
lien	4	53	3980	2	lien
liers	5	51	3040	2	liers
lies	4	64	5419	2	lies
lieu	4	65	3436	2	lieu
lifer	8	58	2215	2	lifer
liger	6	50	2447	2	liger
liker	9	56	2706	2	liker
liner	5	59	3892	2	liner
lire	4	78	4529	2	lire
liter	5	47	3634	2	liter
liver	8	51	3296	2	liver
livier	9	75	1459	2	livier
mien	6	50	2836	2	mien
miler	7	57	3306	2	miler
mimer	9	48	2576	2	mimer
miner	7	69	3354	2	miner
mir	5	70	4677	2	mi_r
mire	6	67	4823	2	mire
miser	7	54	3040	2	miser
miter	7	57	3479	2	miter
mixer	14	50	1764	2	mixer
nicer	7	46	1829	2	nicer
niter	5	50	2897	2	niter
oiler	5	46	2828	2	oiler
omer	6	70	2839	2	omer
osier	5	35	1801	2	osier
over	7	72	2734	2	over
oyer	7	59	2765	2	oyer
peer	6	62	3835	2	peer
per	5	63	5309	2	_per
pie	5	54	5740	2	pie_
pied	7	50	3536	2	pied
piers	7	59	2633	2	piers
pies	6	69	4960	2	pies
piker	11	56	2284	2	piker
piper	9	65	2319	2	piper
plier	7	52	2128	2	plier
prier	7	50	2776	2	prier
ricer	7	47	2661	2	ricer
rider	6	52	3130	2	rider
riel	4	64	3238	2	riel
rifer	8	47	2198	2	rifer
rimer	7	54	2924	2	rimer
riper	7	43	2840	2	riper
riser	5	54	3105	2	riser
river	8	57	3169	2	river
ruer	4	61	2756	2	ruer
seer	4	55	4704	2	seer
ser	3	67	5240	2	_ser
shier	8	54	2894	2	shier
sieur	5	9	1189	2	sieur
siker	9	53	2603	2	siker
sir	3	57	4667	2	si_r
sire	4	61	5041	2	sire
siver	8	57	2861	2	siver
sizer	14	55	2181	2	sizer
skier	9	51	1959	2	skier
slier	5	48	2724	2	slier
spier	7	57	2803	2	spier
suer	4	53	3403	2	suer
tie	3	65	5753	2	tie_
tied	5	55	3521	2	tied
tiers	5	55	2652	2	tiers
ties	4	52	4831	2	ties
tiger	6	57	1863	2	tiger
tiler	5	61	3102	2	tiler
timer	7	56	2604	2	timer
tire	4	61	4335	2	tire
titer	5	54	3061	2	titer
trier	5	43	2853	2	trier
twier	8	47	1329	2	twier
tyer	7	53	2339	2	tyer
user	4	50	2300	2	user
vainer	9	37	1457	2	vainer
vair	7	56	2414	2	vair
var	6	61	4833	2	v_ar
varier	9	46	1935	2	varier
vee	6	57	5018	2	v_ee
veep	9	53	2509	2	veep
veers	8	45	2136	2	veers
veery	11	58	1625	2	veery
vees	7	54	3943	2	vees
veg	7	69	3106	2	v_eg
veil	7	55	2359	2	veil
veiler	9	38	1435	2	veiler
vein	7	56	2575	2	vein
veiner	9	45	1475	2	veiner
vera	7	68	2884	2	v_era
verb	9	62	2487	2	v_erb
verier	9	46	2096	2	verier
vert	7	72	4937	2	v_ert
very	10	80	2564	2	v_ery
vet	6	59	5852	2	v_et
vex	13	64	2917	2	v_ex
vexer	15	55	1352	2	vexer
via	6	56	3624	2	vi_a
vial	7	67	3109	2	vial
vibe	9	51	2450	2	vibe
vibes	10	47	1995	2	vibes
vicar	10	5	1386	2	vicar
vice	9	57	3285	2	vice
viced	11	51	1818	2	viced
vices	10	57	2553	2	vices
vid	7	72	4180	2	vi_d
vide	8	54	3275	2	vide
video	9	60	1495	2	video
vids	8	56	2753	2	vids
viewer	12	3	721	2	viewer
views	11	48	964	2	views
viewy	14	51	810	2	viewy
vig	7	56	3752	2	vi_g
viga	8	56	2296	2	viga
vigor	9	26	1242	2	vigor
vigs	8	54	2727	2	vigs
vile	7	61	3980	2	vile
vill	7	52	3507	2	vill
vim	8	74	3702	2	vi_m
vimen	10	41	1475	2	vimen
vims	9	54	2331	2	vims
vina	7	63	3180	2	vina
vine	7	56	4368	2	vine
vined	9	56	2615	2	vined
vinery	12	49	1260	2	vinery
vines	8	51	3764	2	vines
vinier	9	37	1674	2	vinier
vino	7	61	2843	2	vino
viny	10	60	2595	2	viny
viol	7	65	2359	2	viol
vipers	11	49	1453	2	vipers
vireo	8	48	1645	2	vireo
vires	8	45	2968	2	vires
virl	7	62	2447	2	virl
vis	6	67	4761	2	vi_s
visa	7	63	2387	2	visa
vise	7	56	3267	2	vise
vised	9	55	1876	2	vised
vises	8	44	2777	2	vises
visor	8	25	1283	2	visor
vita	7	58	2852	2	vita
viva	10	61	1909	2	viva
vive	10	54	2662	2	vive
vivers	12	47	1736	2	vivers
vixen	15	30	1002	2	vixen
vizier	18	43	1102	2	vizier
vizir	17	35	939	2	vizir
vizor	17	30	1009	2	vizor
voe	6	77	3905	2	voe_
voes	7	54	3282	2	voes
voicer	11	39	1054	2	voicer
voider	10	36	1155	2	voider
vomer	10	55	1738	2	vomer
voter	8	51	2105	2	voter
vower	11	52	2079	2	vower
wavier	12	46	1308	2	wavier
weer	7	55	3509	2	weer
weir	7	60	1992	2	weir
wider	9	48	2635	2	wider
wiper	10	54	2129	2	wiper
wire	7	58	3981	2	wire
wirer	8	51	2495	2	wirer
wiser	8	55	2280	2	wiser
wiver	11	59	2451	2	wiver
wrier	8	45	2175	2	wrier
yirr	7	65	1357	2	yirr

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.076	2351197.4
2	DLD Change Limit	29872	275	0.843	35435.3
3	Display Results	275	275	0.063	4365.1
	(SQL Overall)	178691	275	0.982	181966.4