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

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

396 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
ling	5	74	4797	(None)
cling	8	64	2467	1	cling
ding	6	69	4096	1	ding
fling	9	70	2351	1	fling
king	9	59	3367	1	king
lang	5	66	3739	1	lang
liang	6	49	1441	1	liang
lin	3	79	6738	1	lin_
line	4	69	6558	1	line
linga	6	68	2082	1	linga
lingo	6	60	2211	1	lingo
lings	6	71	3577	1	lings
lingy	9	69	2514	1	lingy
link	8	69	4345	1	link
linn	4	60	3460	1	linn
lino	4	63	4338	1	lino
lins	4	70	5906	1	lins
lint	4	162	6624	1	lint
liny	7	81	4133	1	liny
long	5	69	3334	1	long
lung	5	57	3249	1	lung
lying	9	57	1745	1	lying
ping	7	59	4360	1	ping
ring	5	65	4116	1	ring
sing	5	75	4418	1	sing
sling	6	60	2880	1	sling
ting	5	61	3992	1	ting
wing	8	63	3923	1	wing
zing	14	57	2862	1	zing
acing	8	74	2915	2	acing
aging	7	70	2635	2	aging
ahing	9	89	2835	2	ahing
ailing	7	43	3101	2	ailing
ain	3	75	7910	2	ain_
ains	4	61	5889	2	ains
alang	6	60	2351	2	alang
align	6	50	1650	2	align
aline	5	72	4315	2	aline
along	6	54	1949	2	along
aping	8	73	2723	2	aping
awing	9	68	2732	2	awing
axing	13	85	2137	2	axing
baling	9	48	2969	2	baling
bang	7	48	3701	2	bang
being	8	49	2050	2	being
big	6	73	4573	2	bi_g
bin	5	66	5865	2	bin_
bind	7	62	3452	2	bind
bine	6	66	5087	2	bine
binge	8	51	2551	2	binge
bingo	8	60	2009	2	bingo
bins	6	65	4826	2	bins
bint	6	73	5505	2	bint
biog	7	61	2233	2	biog
blin	6	72	2817	2	blin_
blind	8	63	1932	2	blind
blini	7	55	1927	2	blini
blink	11	57	2014	2	blink
bluing	9	49	1448	2	bluing
boing	8	47	2555	2	boing
bong	7	56	3341	2	bong
bring	8	55	2850	2	bring
bung	7	57	3063	2	bung
cig	6	70	3619	2	ci_g
cine	6	62	4295	2	cine
clang	8	60	1931	2	clang
cline	7	64	2853	2	cline
clings	9	57	1621	2	clings
clingy	12	65	906	2	clingy
clink	11	53	2004	2	clink
cluing	9	39	1350	2	cluing
clung	8	60	1360	2	clung
cuing	8	54	2019	2	cuing
dang	6	51	3155	2	dang
dig	5	75	4448	2	di_g
din	4	64	5947	2	din_
dine	5	55	5534	2	dine
dinge	7	56	2730	2	dinge
dingo	7	47	2079	2	dingo
dings	7	63	3140	2	dings
dingy	10	57	2126	2	dingy
dink	9	71	3781	2	dink
dino	5	60	3676	2	dino
dins	5	66	5205	2	dins
dint	5	67	5906	2	dint
doing	7	49	2358	2	doing
doling	8	49	2313	2	doling
dong	6	60	3165	2	dong
dung	6	63	2843	2	dung
dying	10	53	1603	2	dying
eking	10	66	1499	2	eking
elint	5	54	3647	2	elint
eng	4	67	2678	2	_eng
exing	13	60	1681	2	exing
eying	9	61	1792	2	eying
fang	8	54	3256	2	fang
fig	7	62	4284	2	fi_g
filing	10	38	2376	2	filing
fin	6	64	5804	2	fin_
find	8	75	3261	2	find
fine	7	51	4796	2	fine
fink	11	75	3213	2	fink
fino	7	60	3470	2	fino
fins	7	58	4910	2	fins
flings	10	67	1528	2	flings
flint	8	73	3350	2	flint
flong	9	58	1568	2	flong
flung	9	51	1458	2	flung
flying	13	46	1215	2	flying
gang	6	60	3198	2	gang
gig	5	60	4076	2	gi_g
gin	4	60	5576	2	gin_
gink	9	71	2953	2	gink
gins	5	55	4396	2	gins
glint	6	68	3018	2	glint
gluing	8	38	1205	2	gluing
going	7	52	1849	2	going
gong	6	68	2719	2	gong
haling	10	42	2978	2	haling
hang	8	55	3556	2	hang
hin	6	75	5957	2	hin_
hind	8	55	2976	2	hind
hinge	9	53	2345	2	hinge
hins	7	64	4800	2	hins
hint	7	74	5575	2	hint
holing	10	40	2507	2	holing
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	1680	2	_igg
in	2	81	5087	2	_in_
ink	7	64	3364	2	_ink
inn	3	67	2744	2	_inn
ins	3	59	4561	2	_ins
iring	6	60	2542	2	iring
isling	7	12	1388	2	isling
jig	11	56	3352	2	ji_g
jin	10	64	4394	2	jin_
jingo	13	46	1521	2	jingo
jink	15	62	2721	2	jink
jinn	11	54	2025	2	jinn
jins	11	56	3502	2	jins
jinx	18	55	1658	2	jinx
kiang	10	48	1136	2	kiang
kin	7	63	5398	2	kin_
kina	8	56	3201	2	kina
kind	9	61	2857	2	kind
kine	8	56	4344	2	kine
kings	10	58	2557	2	kings
kink	7	60	3441	2	kink
kino	8	62	3363	2	kino
kins	8	57	4792	2	kins
klong	10	53	1040	2	klong
lacing	9	46	2623	2	lacing
lading	8	42	2712	2	lading
lag	4	78	6212	2	l_ag
lain	4	61	4628	2	lain_
laking	11	50	2704	2	laking
laming	9	45	2836	2	laming
land	5	63	3731	2	land
lane	4	51	5333	2	lane
lank	8	47	3445	2	lank
lasing	7	47	2798	2	lasing
laving	10	46	2357	2	laving
lawing	10	46	2528	2	lawing
laying	10	45	2570	2	laying
lazing	16	48	2147	2	lazing
leg	4	64	4611	2	l_eg
lend	5	62	3367	2	lend
leno	4	73	3139	2	leno
lens	4	61	4649	2	lens
lent	4	63	6053	2	lent
li	2	99	4876	2	li__
liana	5	39	1589	2	liana
liane	5	47	2066	2	liane
liangs	7	44	1059	2	liangs
liar	4	72	2969	2	liar
lib	5	77	5028	2	li_b
libs	6	67	3277	2	libs
lice	6	60	4507	2	lice
lich	9	62	3085	2	lich
lick	10	69	3508	2	lick
lid	4	74	5353	2	li_d
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
lief	7	60	3700	2	lief
liege	6	53	1443	2	liege
lien	4	53	3981	2	lien
liens	5	65	2550	2	liens
lier	4	59	4247	2	lier
lies	4	64	5420	2	lies
lieu	4	65	3437	2	lieu
life	7	54	3374	2	life
lift	7	69	4273	2	lift
like	8	60	4085	2	like
liking	11	43	1958	2	liking
lilo	4	67	3157	2	lilo
lilt	4	63	4995	2	lilt
lily	7	67	3019	2	lily
lima	6	57	3414	2	lima
limb	8	54	2939	2	limb
lime	6	62	4494	2	lime
liming	9	40	2124	2	liming
limn	6	65	2770	2	limn
limns	7	57	1839	2	limns
limo	6	55	2974	2	limo
limp	8	84	3250	2	limp
limy	9	57	2772	2	limy
linac	7	3	1541	2	linac
linage	7	7	1340	2	linage
lindy	9	69	1832	2	lindy
lined	6	49	3464	2	lined
linen	5	57	2872	2	linen
liner	5	59	3892	2	liner
lines	5	70	5457	2	lines
liney	8	70	2963	2	liney
lingam	9	51	1235	2	lingam
lingas	7	51	1657	2	lingas
linger	7	52	2600	2	linger
lingua	7	50	991	2	lingua
linin	5	80	2552	2	linin
lining	7	45	2680	2	lining
links	9	64	3019	2	links
linky	12	76	2238	2	linky
linns	5	61	2333	2	linns
linos	5	56	3150	2	linos
lints	5	71	3719	2	lints
linty	8	71	2656	2	linty
linum	7	3	1382	2	linum
lion	4	63	3445	2	lion
lions	5	59	2321	2	lions
lip	5	147	5581	2	li_p
lipa	6	84	2593	2	lipa
lipe	6	68	3974	2	lipe
lips	6	71	4145	2	lips
lira	4	69	2869	2	lira
lire	4	78	4530	2	lire
liri	4	51	2826	2	liri
lis	3	71	6228	2	li_s
lisp	6	89	2689	2	lisp
list	4	70	5535	2	list
lit	3	93	7732	2	li_t
lite	4	70	5455	2	lite
lits	4	62	5250	2	lits
litu	4	76	3157	2	litu
live	7	65	4100	2	live
living	10	43	1832	2	living
log	4	62	5268	2	l_og
loin	4	68	3872	2	loin_
loins	5	67	2842	2	loins
lone	4	58	4913	2	lone
longe	6	66	2646	2	longe
longs	6	55	2706	2	longs
looing	7	36	2104	2	looing
loping	9	39	2141	2	loping
losing	7	40	2287	2	losing
loving	10	44	1672	2	loving
lowing	10	46	2327	2	lowing
loxing	14	36	1527	2	loxing
lubing	9	41	1404	2	lubing
lug	4	61	3806	2	l_ug
luging	8	39	1529	2	luging
luna	4	62	2985	2	luna
lune	4	71	4049	2	lune
lunge	6	53	2380	2	lunge
lungi	6	55	1605	2	lungi
lungs	6	52	2388	2	lungs
lunk	8	60	3072	2	lunk
lunt	4	61	4884	2	lunt
luny	7	73	2413	2	luny
luring	7	38	2075	2	luring
luting	7	52	2175	2	luting
lyings	10	48	850	2	lyings
lynx	14	3	742	2	lynx
lysing	10	47	1044	2	lysing
mig	6	56	4609	2	mi_g
migg	8	57	1681	2	migg
mina	6	51	3693	2	mina
mind	7	54	3439	2	mind
mine	6	72	5618	2	mine
mingy	11	55	2018	2	mingy
mini	6	56	3457	2	mini
mink	10	66	3654	2	mink
mint	6	67	5807	2	mint
minx	13	77	2336	2	minx
muling	9	35	1988	2	muling
nine	4	58	4218	2	nine
ogling	8	32	1188	2	ogling
ohing	9	60	1881	2	ohing
oiling	7	49	2531	2	oiling
oink	8	54	2935	2	oink
olingo	7	3	693	2	olingo
oping	8	63	2241	2	oping
owing	9	62	2272	2	owing
paling	9	35	3013	2	paling
pang	7	53	3630	2	pang
pig	6	57	4498	2	pi_g
piing	8	52	1883	2	piing
piling	9	50	2559	2	piling
pin	5	70	6673	2	pin_
pina	6	58	4264	2	pina
pine	6	77	5572	2	pine
pingo	8	71	2271	2	pingo
pings	8	58	3088	2	pings
pink	10	70	3939	2	pink
pins	6	55	5846	2	pins
pint	6	69	6318	2	pint
piny	9	118	3836	2	piny
plink	11	52	1912	2	plink
plying	12	43	1208	2	plying
poling	9	35	2650	2	poling
pong	7	62	3114	2	pong
puling	9	36	2140	2	puling
pung	7	54	2963	2	pung
rang	5	69	3917	2	rang
rig	4	67	4813	2	ri_g
riling	7	42	2797	2	riling
rin	3	66	6319	2	rin_
rind	5	65	3561	2	rind
rings	6	50	2917	2	rings
rink	8	77	3700	2	rink
rins	4	61	5320	2	rins
ruing	6	72	2105	2	ruing
ruling	7	32	1955	2	ruling
rung	5	64	2998	2	rung
sang	5	54	4124	2	sang
sign	5	55	2306	2	sign
sin	3	62	6590	2	sin_
sine	4	65	6063	2	sine
singe	6	57	3113	2	singe
sings	6	55	3270	2	sings
sinh	7	62	3805	2	sinh
sink	8	66	4015	2	sink
sins	4	67	5528	2	sins
slang	6	63	2402	2	slang
slings	7	46	1801	2	slings
slink	9	54	2291	2	slink
sluing	7	43	1588	2	sluing
slung	6	51	1783	2	slung
soling	7	42	2682	2	soling
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
tiling	7	34	2655	2	tiling
tin	3	63	6218	2	tin_
tine	4	58	5514	2	tine
tinge	6	46	2663	2	tinge
tings	6	53	2921	2	tings
tins	4	52	5131	2	tins
tint	4	67	5887	2	tint
tiny	7	61	3464	2	tiny
toling	7	39	2612	2	toling
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	3753	2	vi_g
vina	7	63	3181	2	vina
vine	7	56	4369	2	vine
vino	7	61	2844	2	vino
viny	10	60	2596	2	viny
voling	10	39	1802	2	voling
vying	12	51	1181	2	vying
waling	10	45	2530	2	waling
wig	7	67	4039	2	wi_g
wiling	10	30	2429	2	wiling
win	6	64	5630	2	win_
wind	8	55	3386	2	wind
wine	7	49	5343	2	wine
wings	9	57	2724	2	wings
wingy	12	65	2103	2	wingy
wink	11	64	3503	2	wink
wino	7	59	3362	2	wino
wins	7	59	4918	2	wins
winy	10	70	3433	2	winy
wring	9	59	2071	2	wring
wyling	13	36	855	2	wyling
yang	8	56	2608	2	yang
yin	6	76	4874	2	yin_
yins	7	53	3513	2	yins
zig	13	69	3191	2	zi_g
zin	12	56	4378	2	zin_
zinc	15	68	1910	2	zinc
zine	13	70	3616	2	zine
zings	15	46	2089	2	zings
zingy	18	65	1613	2	zingy
zins	13	57	3501	2	zins

Search took 3 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.530	337152.8
2	DLD Change Limit	29872	396	2.000	14936.0
3	Display Results	396	396	0.093	4258.1
	(SQL Overall)	178691	396	2.623	68124.7