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

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

359 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
ding	6	69	4095	(None)
dang	6	51	3155	1	dang
dig	5	75	4447	1	di_g
din	4	64	5946	1	din_
dine	5	55	5533	1	dine
dinge	7	56	2730	1	dinge
dingo	7	47	2079	1	dingo
dings	7	63	3140	1	dings
dingy	10	57	2126	1	dingy
dink	9	71	3780	1	dink
dino	5	60	3675	1	dino
dins	5	66	5204	1	dins
dint	5	67	5905	1	dint
doing	7	49	2358	1	doing
dong	6	60	3165	1	dong
dung	6	63	2843	1	dung
dying	10	53	1603	1	dying
king	9	59	3366	1	king
ling	5	74	4796	1	ling
ping	7	59	4359	1	ping
ring	5	65	4115	1	ring
sing	5	75	4417	1	sing
ting	5	61	3991	1	ting
wing	8	63	3922	1	wing
zing	14	57	2861	1	zing
acing	8	74	2915	2	acing
adding	9	39	1496	2	adding
adzing	17	41	1001	2	adzing
aging	7	70	2635	2	aging
ahing	9	89	2835	2	ahing
aiding	8	44	2361	2	aiding
ain	3	75	7909	2	ain_
ains	4	61	5888	2	ains
aping	8	73	2723	2	aping
auding	8	36	1693	2	auding
awing	9	68	2732	2	awing
axing	13	85	2137	2	axing
bang	7	48	3701	2	bang
being	8	49	2050	2	being
biding	10	47	2079	2	biding
big	6	73	4572	2	bi_g
bin	5	66	5864	2	bin_
bind	7	62	3451	2	bind
bine	6	66	5086	2	bine
binge	8	51	2551	2	binge
bingo	8	60	2009	2	bingo
bins	6	65	4825	2	bins
bint	6	73	5504	2	bint
biog	7	61	2232	2	biog
boding	10	43	2006	2	boding
boing	8	47	2555	2	boing
bong	7	56	3341	2	bong
bring	8	55	2850	2	bring
bung	7	57	3063	2	bung
ceding	10	40	1480	2	ceding
cig	6	70	3618	2	ci_g
cine	6	62	4294	2	cine
cling	8	64	2467	2	cling
coding	10	40	2479	2	coding
cuing	8	54	2019	2	cuing
dag	5	77	5301	2	d_ag
dan	4	68	5967	2	dan_
dangs	7	56	2321	2	dangs
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
daring	8	49	2868	2	daring
dating	8	53	2648	2	dating
dawing	11	48	1982	2	dawing
dazing	17	55	1651	2	dazing
deign	7	43	1280	2	deign
deking	12	56	1455	2	deking
den	4	75	5434	2	den_
dene	5	66	4341	2	dene
deni	5	69	2939	2	deni
dens	5	59	4507	2	dens
dent	5	71	5841	2	dent
deny	8	60	2712	2	deny
dewing	11	41	1570	2	dewing
dial	5	59	3506	2	dial
dib	6	57	4694	2	di_b
dibs	7	62	3368	2	dibs
dice	7	58	4189	2	dice
dicing	10	57	1876	2	dicing
dick	11	64	3238	2	dick
did	5	68	5052	2	di_d
dido	6	65	2820	2	dido
didy	9	91	2151	2	didy
die	4	67	5965	2	di_e
died	6	61	3785	2	died
dieing	8	40	1865	2	dieing
diel	5	90	3460	2	diel
diene	6	57	2013	2	diene
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
dif	7	68	4690	2	di_f
diff	11	62	2884	2	diff
difs	8	60	2732	2	difs
digs	6	60	3605	2	digs
dike	9	59	3576	2	dike
diking	12	43	2024	2	diking
dill	5	52	3997	2	dill
dim	6	81	4649	2	di_m
dime	7	62	3764	2	dime
dims	7	54	3502	2	dims
dinar	6	63	1989	2	dinar
dined	7	64	3199	2	dined
diner	6	56	3290	2	diner
dines	6	64	4915	2	dines
dinged	9	52	2178	2	dinged
dinger	8	53	2367	2	dinger
dinges	8	38	2542	2	dinges
dingey	11	49	1405	2	dingey
dinghy	14	47	696	2	dinghy
dingle	8	43	1707	2	dingle
dingus	8	36	1184	2	dingus
dining	8	45	2513	2	dining
dinks	10	59	2795	2	dinks
dinky	13	58	1937	2	dinky
dinos	6	54	2806	2	dinos
dints	6	74	3131	2	dints
diol	5	73	2913	2	diol
dip	6	78	4898	2	di_p
dips	7	55	3691	2	dips
dipt	7	73	3932	2	dipt
dire	5	66	4414	2	dire
dirge	7	51	1707	2	dirge
dirk	9	63	2683	2	dirk
dirl	5	74	3002	2	dirl
dirt	5	55	5038	2	dirt
dis	4	64	5989	2	di_s
disc	7	61	2323	2	disc
dish	8	63	2833	2	dish
disk	9	66	2583	2	disk
diss	5	64	3448	2	diss
dit	4	70	7133	2	di_t
dita	5	60	3252	2	dita
dite	5	55	4755	2	dite
dits	5	64	5052	2	dits
ditz	14	69	2951	2	ditz
diva	8	59	2088	2	diva
dive	8	56	3477	2	dive
diving	11	37	1795	2	diving
djin	12	9	1163	2	djin_
djinn	13	5	563	2	djinn
djins	13	6	845	2	djins
dog	5	74	4975	2	d_og
doings	8	49	1318	2	doings
doling	8	49	2313	2	doling
doming	10	42	1839	2	doming
don	4	67	5765	2	don_
dona	5	55	2963	2	dona
done	5	57	4791	2	done
donga	7	67	1842	2	donga
dongs	7	65	2581	2	dongs
dons	5	60	4870	2	dons
doping	10	39	1946	2	doping
dosing	8	39	2027	2	dosing
doting	8	48	2191	2	doting
dowing	11	42	2151	2	dowing
dozing	17	42	1419	2	dozing
drag	6	48	2505	2	drag
dreg	6	68	2165	2	dreg
drink	10	68	1638	2	drink
drug	6	57	1813	2	drug
drying	11	34	1160	2	drying
duding	9	39	1332	2	duding
dug	5	81	3869	2	d_ug
duking	12	47	1513	2	duking
dun	4	65	4558	2	dun_
dune	5	61	3758	2	dune
dungs	7	58	2197	2	dungs
dungy	10	47	1364	2	dungy
dunk	9	62	2857	2	dunk
duns	5	51	4043	2	duns
dunt	5	57	4687	2	dunt
duping	10	41	1363	2	duping
during	8	44	1940	2	during
dwine	9	56	1614	2	dwine
dyeing	11	42	821	2	dyeing
dyings	11	47	813	2	dyings
dyking	15	45	801	2	dyking
dyne	8	53	2093	2	dyne
edging	9	35	1071	2	edging
eking	10	66	1498	2	eking
ending	8	32	2025	2	ending
eng	4	67	2678	2	_eng
exing	13	60	1681	2	exing
eying	9	61	1792	2	eying
fading	11	48	2111	2	fading
fang	8	54	3256	2	fang
fig	7	62	4283	2	fi_g
fin	6	64	5803	2	fin_
find	8	75	3260	2	find
fine	7	51	4795	2	fine
fink	11	75	3212	2	fink
fino	7	60	3469	2	fino
fins	7	58	4909	2	fins
fling	9	70	2351	2	fling
gang	6	60	3198	2	gang
gig	5	60	4075	2	gi_g
gin	4	60	5575	2	gin_
gink	9	71	2952	2	gink
gins	5	55	4395	2	gins
going	7	52	1849	2	going
gong	6	68	2719	2	gong
hading	11	39	2294	2	hading
hang	8	55	3556	2	hang
hiding	11	43	1933	2	hiding
hin	6	75	5956	2	hin_
hind	8	55	2975	2	hind
hinge	9	53	2345	2	hinge
hins	7	64	4799	2	hins
hint	7	74	5574	2	hint
hong	8	58	3395	2	hong
hung	8	61	2635	2	hung
hying	12	65	1474	2	hying
icing	8	60	1775	2	icing
idling	8	9	1288	2	idling
igg	5	71	1679	2	_igg
in	2	81	5086	2	_in_
ink	7	64	3363	2	_ink
inn	3	67	2743	2	_inn
ins	3	59	4560	2	_ins
iring	6	60	2542	2	iring
jading	15	42	1402	2	jading
jig	11	56	3351	2	ji_g
jin	10	64	4393	2	jin_
jingo	13	46	1521	2	jingo
jink	15	62	2720	2	jink
jinn	11	54	2024	2	jinn
jins	11	56	3501	2	jins
jinx	18	55	1657	2	jinx
kiang	10	48	1135	2	kiang
kin	7	63	5397	2	kin_
kina	8	56	3200	2	kina
kind	9	61	2856	2	kind
kine	8	56	4343	2	kine
kings	10	58	2556	2	kings
kink	7	60	3440	2	kink
kino	8	62	3362	2	kino
kins	8	57	4791	2	kins
lading	8	42	2712	2	lading
lang	5	66	3739	2	lang
liang	6	49	1441	2	liang
lin	3	79	6737	2	lin_
line	4	69	6557	2	line
linga	6	68	2082	2	linga
lingo	6	60	2211	2	lingo
lings	6	71	3577	2	lings
lingy	9	69	2514	2	lingy
link	8	69	4344	2	link
linn	4	60	3459	2	linn
lino	4	63	4337	2	lino
lins	4	70	5905	2	lins
lint	4	162	6623	2	lint
liny	7	81	4132	2	liny
long	5	69	3334	2	long
lung	5	57	3249	2	lung
lying	9	57	1745	2	lying
mig	6	56	4608	2	mi_g
migg	8	57	1680	2	migg
mina	6	51	3692	2	mina
mind	7	54	3438	2	mind
mine	6	72	5617	2	mine
mingy	11	55	2018	2	mingy
mini	6	56	3456	2	mini
mink	10	66	3653	2	mink
mint	6	67	5806	2	mint
minx	13	77	2335	2	minx
niding	8	32	1798	2	niding
nine	4	58	4217	2	nine
ohing	9	60	1881	2	ohing
oink	8	54	2934	2	oink
oping	8	63	2241	2	oping
owing	9	62	2272	2	owing
pang	7	53	3630	2	pang
pig	6	57	4497	2	pi_g
piing	8	52	1883	2	piing
pin	5	70	6672	2	pin_
pina	6	58	4263	2	pina
pine	6	77	5571	2	pine
pingo	8	71	2271	2	pingo
pings	8	58	3088	2	pings
pink	10	70	3938	2	pink
pins	6	55	5845	2	pins
pint	6	69	6317	2	pint
piny	9	118	3835	2	piny
pong	7	62	3114	2	pong
pung	7	54	2963	2	pung
rang	5	69	3917	2	rang
reding	8	38	2556	2	reding
riding	8	43	2596	2	riding
rig	4	67	4812	2	ri_g
rin	3	66	6318	2	rin_
rind	5	65	3560	2	rind
rings	6	50	2917	2	rings
rink	8	77	3699	2	rink
rins	4	61	5319	2	rins
ruing	6	72	2105	2	ruing
rung	5	64	2998	2	rung
sang	5	54	4124	2	sang
siding	8	38	2213	2	siding
sign	5	55	2305	2	sign
sin	3	62	6589	2	sin_
sine	4	65	6062	2	sine
singe	6	57	3113	2	singe
sings	6	55	3270	2	sings
sinh	7	62	3804	2	sinh
sink	8	66	4014	2	sink
sins	4	67	5527	2	sins
sling	6	60	2880	2	sling
song	5	51	3367	2	song
sting	6	53	3024	2	sting
suing	6	50	2636	2	suing
sung	5	58	3217	2	sung
swing	9	61	2484	2	swing
tang	5	61	3869	2	tang
thing	9	66	2298	2	thing
tiding	8	35	2009	2	tiding
tin	3	63	6217	2	tin_
tine	4	58	5513	2	tine
tinge	6	46	2663	2	tinge
tings	6	53	2921	2	tings
tins	4	52	5130	2	tins
tint	4	67	5886	2	tint
tiny	7	61	3463	2	tiny
tong	5	64	3436	2	tong
tung	5	53	2817	2	tung
tying	9	60	1984	2	tying
using	6	63	1796	2	using
vang	8	49	2605	2	vang
vig	7	56	3752	2	vi_g
vina	7	63	3180	2	vina
vine	7	56	4368	2	vine
vino	7	61	2843	2	vino
viny	10	60	2595	2	viny
vying	12	51	1181	2	vying
wading	11	46	1953	2	wading
wig	7	67	4038	2	wi_g
win	6	64	5629	2	win_
wind	8	55	3385	2	wind
wine	7	49	5342	2	wine
wings	9	57	2724	2	wings
wingy	12	65	2103	2	wingy
wink	11	64	3502	2	wink
wino	7	59	3361	2	wino
wins	7	59	4917	2	wins
winy	10	70	3432	2	winy
wring	9	59	2071	2	wring
yang	8	56	2608	2	yang
yin	6	76	4873	2	yin_
yins	7	53	3512	2	yins
zig	13	69	3190	2	zi_g
zin	12	56	4377	2	zin_
zinc	15	68	1909	2	zinc
zine	13	70	3615	2	zine
zings	15	46	2089	2	zings
zingy	18	65	1613	2	zingy
zins	13	57	3500	2	zins

Search took 4 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.780	229091.0
2	DLD Change Limit	29872	359	2.936	10174.4
3	Display Results	359	359	0.173	2075.1
	(SQL Overall)	178691	359	3.889	45947.8