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

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

268 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
erg	4	55	3107	(None)
berg	7	54	2554	1	berg
egg	5	69	1867	1	egg
eng	4	67	2678	1	eng
er	2	83	4514	1	er_
era	3	57	4150	1	era
ere	3	63	5277	1	ere
ergo	5	64	2015	1	ergo
ergs	5	55	2381	1	ergs
ern	3	57	3835	1	ern
err	3	56	2653	1	err
ers	3	60	4628	1	ers
reg	4	61	4649	1	reg
aero	4	54	3534	2	aero
aery	7	72	3168	2	aery
ag	3	110	6746	2	_ag
ar	2	113	7938	2	ar_
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
are	3	78	7457	2	are
arf	6	74	5337	2	arf
ark	7	70	4496	2	ark
arm	5	84	4962	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
bag	6	70	5922	2	bag
beg	6	59	4413	2	beg
bergs	8	47	1804	2	bergs
berk	10	59	2984	2	berk
berm	8	67	3275	2	berm
big	6	73	4571	2	big
bog	6	78	5241	2	bog
bra	5	63	3946	2	bra
brag	7	52	2972	2	brag
brig	7	65	2803	2	brig
bro	5	62	3660	2	bro
brr	5	69	2192	2	brr
bug	6	53	4074	2	bug
burg	7	49	3036	2	burg
cere	6	67	4147	2	cere
cero	6	63	2945	2	cero
cig	6	70	3618	2	cig
cog	6	95	5290	2	cog
crag	7	56	2530	2	crag
cru	5	71	2956	2	cru
cry	8	97	2624	2	cry
dag	5	77	5300	2	dag
dere	5	68	4590	2	dere
derm	7	60	3189	2	derm
dig	5	75	4447	2	dig
dog	5	74	4975	2	dog
drag	6	48	2505	2	drag
dreg	6	68	2165	2	dreg
drug	6	57	1813	2	drug
dry	7	65	2603	2	dry
dug	5	81	3869	2	dug
ear	3	68	6788	2	ear
earl	4	58	3814	2	earl
earn	4	67	3755	2	earn
ears	4	63	5659	2	ears
eat	3	69	8905	2	eat
eau	3	74	5094	2	eau
ebb	7	24	1862	2	ebb
ecru	6	58	1953	2	ecru
ecu	5	68	2823	2	ecu
ed	3	86	4518	2	e_d
edge	6	57	1966	2	edge
edgy	9	47	1352	2	edgy
edh	7	69	2156	2	edh
eds	4	66	3892	2	eds
eek	7	79	3510	2	eek
eel	3	79	4684	2	eel
eery	7	61	2962	2	eery
ef	5	73	4536	2	e_f
eff	9	61	2862	2	eff
efs	6	68	2960	2	efs
eft	6	60	3882	2	eft
eggs	6	65	1615	2	eggs
eggy	9	66	1185	2	eggy
ego	4	67	2605	2	ego
eh	5	83	3996	2	e_h
eke	7	56	3009	2	eke
el	2	67	4529	2	e_l
eld	4	67	3379	2	eld
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
ell	3	67	3568	2	ell
elm	5	75	3174	2	elm
els	3	76	4572	2	els
em	4	94	4515	2	e_m
eme	5	58	3718	2	eme
ems	5	64	3549	2	ems
emu	5	59	2998	2	emu
en	2	80	5239	2	e_n
end	4	68	3435	2	end
engs	5	61	2139	2	engs
ens	3	72	4592	2	ens
eon	3	60	5208	2	eon
eras	4	54	4150	2	eras
ergot	6	54	2289	2	ergot
erne	4	67	2742	2	erne
erns	4	54	2822	2	erns
eros	4	52	3845	2	eros
errs	4	56	2253	2	errs
erst	4	74	3643	2	erst
erugo	6	36	985	2	erugo
es	2	90	4822	2	e_s
ess	3	60	3088	2	ess
et	2	69	6419	2	e_t
eta	3	58	3419	2	eta
eth	6	66	3098	2	eth
euro	4	53	2527	2	euro
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
ex	9	88	3564	2	e_x
eye	6	55	3977	2	eye
eyra	7	62	1755	2	eyra
eyre	7	55	2525	2	eyre
eyry	10	63	1588	2	eyry
fag	7	68	5236	2	fag
fer	6	66	4612	2	fer_
fere	7	63	4223	2	fere
fern	7	61	2932	2	fern
fig	7	62	4283	2	fig
fog	7	69	4556	2	fog
frag	8	51	2627	2	frag
frig	8	54	2450	2	frig
fro	6	55	3064	2	fro
frog	8	56	2436	2	frog
frug	8	65	1710	2	frug
fry	9	62	2650	2	fry
fug	7	62	3451	2	fug
gag	5	77	5363	2	gag
germ	7	54	2896	2	germ
gig	5	60	4075	2	gig
grig	6	54	2477	2	grig
grog	6	59	2334	2	grog
hag	7	72	5574	2	hag
her	6	65	4781	2	her_
herb	9	47	3096	2	herb
herd	8	49	3306	2	herd
here	7	64	4710	2	here
herl	7	58	3455	2	herl
herm	9	56	3615	2	herm
hern	7	61	3489	2	hern
hero	7	46	3578	2	hero
hers	7	58	4487	2	hers
hog	7	80	4906	2	hog
hug	7	60	3736	2	hug
igg	5	71	1679	2	igg
ire	3	69	4317	2	ire
irk	7	64	2636	2	irk
jag	11	65	4271	2	jag
jerk	15	49	2013	2	jerk
jig	11	56	3351	2	jig
jog	11	74	3831	2	jog
jug	11	55	2954	2	jug
keg	8	64	3253	2	keg
kerb	10	43	2271	2	kerb
kerf	11	58	2746	2	kerf
kern	8	53	2621	2	kern
lag	4	78	6212	2	lag
leg	4	64	4611	2	leg
log	4	62	5268	2	log
lug	4	61	3806	2	lug
mag	6	79	5647	2	mag
meg	6	60	4095	2	meg
merc	8	72	2562	2	merc
mere	6	72	4444	2	mere
merge	8	45	2368	2	merge
merk	10	60	2794	2	merk
merl	6	58	3097	2	merl
mig	6	56	4607	2	mig
mog	6	69	4967	2	mog
mug	6	58	3769	2	mug
nag	4	64	5081	2	nag
neg	4	72	3734	2	neg
nerd	5	66	2494	2	nerd
nog	4	68	4731	2	nog
or	2	73	5473	2	or_
ora	3	72	5083	2	ora
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
ore	3	66	6183	2	ore
orgy	8	52	1800	2	orgy
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
peag	7	54	3134	2	peag
peg	6	58	4306	2	peg
per	5	63	5309	2	per_
pere	6	64	5026	2	pere
peri	6	56	3697	2	peri
perk	10	62	3284	2	perk
perm	8	58	3463	2	perm
perp	8	90	2989	2	perp
pert	6	67	5932	2	pert
perv	9	72	2481	2	perv
pig	6	57	4497	2	pig
prig	7	59	2487	2	prig
pro	5	58	3726	2	pro
prog	7	57	2900	2	prog
pry	8	57	2805	2	pry
pug	6	53	3718	2	pug
rag	4	57	6132	2	rag
re	2	61	5374	2	_re
reb	5	58	4496	2	reb
rec	5	56	4546	2	rec
red	4	67	5580	2	red
ree	3	79	7407	2	ree
ref	6	60	5329	2	ref
regs	5	54	3657	2	regs
rei	3	56	4725	2	rei
rem	5	61	5004	2	rem
rep	5	58	4780	2	rep
rerig	6	40	1848	2	rerig
res	3	55	6504	2	res
ret	3	59	8283	2	ret
rev	6	53	3662	2	rev
rex	10	57	4099	2	rex
rig	4	67	4812	2	rig
rug	4	60	3915	2	rug
sag	4	61	6340	2	sag
seg	4	55	4488	2	seg
ser	3	67	5240	2	ser_
sera	4	61	4139	2	sera
sere	4	61	5347	2	sere
serf	7	63	4011	2	serf
serge	6	47	2746	2	serge
sers	4	57	4665	2	sers
sri	3	56	3400	2	sri
tag	4	72	5949	2	tag
teg	4	57	4162	2	teg
tegg	6	53	1592	2	tegg
terga	6	33	1564	2	terga
term	6	62	3315	2	term
tern	4	61	3480	2	tern
tog	4	102	5504	2	tog
trig	5	55	2816	2	trig
trog	5	76	2821	2	trog
trug	5	57	2004	2	trug
try	6	65	2967	2	try
tug	4	59	3740	2	tug
urb	5	57	3110	2	urb
urd	4	64	2704	2	urd
urge	5	47	2241	2	urge
urn	3	57	3146	2	urn
urp	5	64	2639	2	urp
veg	7	69	3106	2	veg
vera	7	68	2884	2	vera
verb	9	62	2487	2	verb
verge	9	34	1983	2	verge
vert	7	72	4937	2	vert
very	10	80	2564	2	very
vig	7	56	3752	2	vig
vug	7	61	2741	2	vug
wag	7	64	5175	2	wag
were	7	62	3833	2	were
wert	7	97	4982	2	wert
wig	7	67	4038	2	wig
wog	7	62	4273	2	wog
wry	9	65	2470	2	wry
yag	7	69	4773	2	yag
yegg	9	65	1179	2	yegg
yerk	11	62	2208	2	yerk
zag	13	75	3947	2	zag
zerk	17	53	1925	2	zerk
zero	13	48	2246	2	zero
zig	13	69	3190	2	zig

Search took 1 second 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	14084	0.046	3884587.0
2	DLD Change Limit	14084	268	0.390	36112.8
3	Display Results	268	268	0.046	5826.1
	(SQL Overall)	178691	268	0.482	370728.2