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

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

301 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
tang	5	61	3867	(None)
bang	7	48	3700	1	bang
dang	6	51	3154	1	dang
fang	8	54	3255	1	fang
gang	6	60	3197	1	gang
hang	8	55	3555	1	hang
lang	5	66	3738	1	lang
pang	7	53	3629	1	pang
rang	5	69	3916	1	rang
sang	5	54	4123	1	sang
stang	6	64	2468	1	stang
tag	4	72	5949	1	ta_g
tan	3	71	6757	1	tan_
tanga	6	49	2369	1	tanga
tango	6	69	2117	1	tango
tangs	6	50	2834	1	tangs
tangy	9	45	1993	1	tangy
tank	8	51	3402	1	tank
tans	4	61	5482	1	tans
ting	5	61	3990	1	ting
tong	5	64	3435	1	tong
tung	5	53	2816	1	tung
twang	9	45	1185	1	twang
vang	8	49	2604	1	vang
yang	8	56	2607	1	yang
ag	3	110	6746	2	_a_g
alang	6	60	2351	2	alang
an	2	118	7908	2	_an_
ana	3	95	5983	2	_ana
and	4	72	4417	2	_and
ane	3	78	6695	2	_ane
anga	5	68	3135	2	_anga
ani	3	77	5118	2	_ani
ant	3	72	7079	2	_ant
any	6	84	4049	2	_any
bag	6	70	5922	2	ba_g
ban	5	83	6684	2	ban_
band	7	67	4091	2	band
bane	6	52	5043	2	bane
bangs	8	56	2777	2	bangs
bani	6	53	3496	2	bani
bank	10	58	3575	2	bank
bans	6	65	5514	2	bans
bhang	11	55	1292	2	bhang
bong	7	56	3341	2	bong
bung	7	57	3063	2	bung
can	5	77	6014	2	can_
cane	6	66	5312	2	cane
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
chang	11	54	1856	2	chang
clang	8	60	1931	2	clang
dag	5	77	5301	2	da_g
dan	4	68	5967	2	dan_
dangs	7	56	2320	2	dangs
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
ding	6	69	4095	2	ding
dong	6	60	3165	2	dong
dung	6	63	2843	2	dung
eng	4	67	2678	2	_eng
fag	7	68	5236	2	fa_g
fan	6	71	5886	2	fan_
fane	7	53	4357	2	fane
fanga	9	61	1962	2	fanga
fangs	9	62	2407	2	fangs
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
gag	5	77	5363	2	ga_g
gan	4	80	6013	2	gan_
gane	5	51	4530	2	gane
gangs	7	62	2257	2	gangs
gong	6	68	2719	2	gong
hag	7	72	5574	2	ha_g
hand	8	68	3371	2	hand
hangs	9	57	2672	2	hangs
hank	11	51	3414	2	hank
hant	7	54	6159	2	hant
hong	8	58	3395	2	hong
hung	8	61	2635	2	hung
jag	11	65	4271	2	ja_g
jagg	13	61	1531	2	jagg
jane	11	50	3148	2	jane
kana	8	59	2853	2	kana
kane	8	51	3397	2	kane
kiang	10	48	1135	2	kiang
king	9	59	3366	2	king
lag	4	78	6212	2	la_g
land	5	63	3731	2	land
lane	4	51	5333	2	lane
lank	8	47	3445	2	lank
liang	6	49	1441	2	liang
ling	5	74	4796	2	ling
long	5	69	3334	2	long
lung	5	57	3249	2	lung
mag	6	79	5648	2	ma_g
man	5	74	6587	2	man_
mana	6	53	4196	2	mana
mane	6	50	5203	2	mane
manga	8	50	2620	2	manga
mange	8	49	3019	2	mange
mango	8	57	2432	2	mango
mangy	11	50	2124	2	mangy
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
many	9	57	3186	2	many
nag	4	64	5081	2	na_g
nan	3	78	5488	2	nan_
nana	4	66	3290	2	nana
nans	4	61	3940	2	nans
orang	6	51	1994	2	orang
pan	5	84	6645	2	pan_
pane	6	49	5029	2	pane
panga	8	53	2353	2	panga
pangs	8	46	2866	2	pangs
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
ping	7	59	4359	2	ping
pong	7	62	3114	2	pong
prang	8	48	2032	2	prang
pung	7	54	2963	2	pung
rag	4	57	6132	2	ra_g
ragg	6	56	2269	2	ragg
ran	3	82	6662	2	ran_
rand	5	58	3957	2	rand
range	6	47	2841	2	range
rangy	9	53	2038	2	rangy
rani	4	66	4011	2	rani
rank	8	51	3553	2	rank
rant	4	58	6468	2	rant
ring	5	65	4115	2	ring
rung	5	64	2998	2	rung
sag	4	61	6340	2	sa_g
sand	5	53	3847	2	sand
sane	4	59	5434	2	sane
sanga	6	60	2379	2	sanga
sangh	9	55	1745	2	sangh
sank	8	52	3683	2	sank
sans	4	51	5336	2	sans
satang	7	57	1156	2	satang
sing	5	75	4417	2	sing
slang	6	63	2402	2	slang
snag	5	58	2787	2	snag
song	5	51	3367	2	song
spang	8	49	1973	2	spang
stag	5	73	3200	2	sta_g
staig	6	55	1964	2	staig
stand	6	59	2328	2	stand
stane	5	59	3300	2	stane
stangs	7	50	1816	2	stangs
stank	9	58	2330	2	stank
sting	6	53	3024	2	sting
strang	7	57	1831	2	strang
stung	6	54	1715	2	stung
sung	5	58	3217	2	sung
swang	9	55	1972	2	swang
ta	2	116	6245	2	ta__
tab	5	74	6032	2	ta_b
tabs	6	68	4298	2	tabs
tabu	6	63	2849	2	tabu
tace	6	53	4251	2	tace
tach	9	61	3275	2	tach
tack	10	65	3629	2	tack
taco	6	70	3135	2	taco
tact	6	73	4903	2	tact
tad	4	79	5982	2	ta_d
tads	5	71	4394	2	tads
tae	3	82	6705	2	ta_e
tael	4	60	3071	2	tael
tags	5	55	4523	2	tags
tahr	7	52	1715	2	tahr
taiga	6	41	1566	2	taiga
tail	4	54	4365	2	tail
tain	4	55	4807	2	tain
tains	5	49	3632	2	tains
taint	5	55	4228	2	taint
taj	10	64	4219	2	ta_j
taka	8	76	2359	2	taka
take	8	47	3926	2	take
taking	11	47	2595	2	taking
tala	4	59	3805	2	tala
talc	6	62	2681	2	talc
tale	4	61	5416	2	tale
tali	4	68	3716	2	tali
talk	8	62	3009	2	talk
tall	4	72	4021	2	tall
tam	5	86	6342	2	ta_m
tame	6	63	4366	2	tame
taming	9	40	2343	2	taming
tamp	8	61	3300	2	tamp
tams	6	72	4793	2	tams
tanged	8	46	2249	2	tanged
tangle	7	40	1995	2	tangle
tangly	10	44	1391	2	tangly
tangos	7	42	1630	2	tangos
tanka	9	38	1748	2	tanka
tanks	9	46	2473	2	tanks
tansy	8	45	1493	2	tansy
tanto	5	57	2494	2	tanto
tao	3	83	5895	2	ta_o
taos	4	55	4100	2	taos
tap	5	76	6387	2	ta_p
tapa	6	51	2914	2	tapa
tape	6	45	3814	2	tape
taping	9	42	2239	2	taping
taps	6	60	5067	2	taps
tar	3	75	7069	2	ta_r
tare	4	59	5762	2	tare
targe	6	52	2709	2	targe
taring	7	39	3228	2	taring
tarn	4	68	4272	2	tarn
tarns	5	64	3395	2	tarns
taro	4	68	4691	2	taro
tarp	6	69	3641	2	tarp
tars	4	67	6395	2	tars
tart	4	75	6618	2	tart
tas	3	84	7710	2	ta_s
task	8	53	2665	2	task
tass	4	56	4057	2	tass
tat	3	76	9029	2	ta_t
tate	4	47	4860	2	tate
tats	4	68	5813	2	tats
tau	3	68	5690	2	ta_u
taunt	5	55	3228	2	taunt
taus	4	63	4273	2	taus
taut	4	70	4896	2	taut
tav	6	60	4321	2	ta_v
tavs	7	56	3097	2	tavs
taw	6	101	5545	2	ta_w
tawing	10	45	2155	2	tawing
tawny	11	47	1365	2	tawny
taws	7	56	4159	2	taws
tax	10	94	4915	2	ta_x
taxa	11	68	2009	2	taxa
taxi	11	71	2476	2	taxi
taxing	14	38	1671	2	taxing
teg	4	57	4162	2	t_eg
tegg	6	53	1592	2	tegg
ten	3	58	5611	2	ten_
tend	5	64	3377	2	tend
tenge	6	57	2044	2	tenge
tens	4	56	4741	2	tens
tent	4	61	5986	2	tent
than	7	61	2877	2	than_
thane	8	61	2253	2	thane
thank	12	58	1780	2	thank
thing	9	66	2298	2	thing
thong	9	50	1418	2	thong
thug	8	64	1548	2	thug
tin	3	63	6217	2	tin_
tine	4	58	5513	2	tine
tinge	6	46	2662	2	tinge
tings	6	53	2920	2	tings
tins	4	52	5130	2	tins
tint	4	67	5886	2	tint
tiny	7	61	3463	2	tiny
tog	4	102	5504	2	t_og
ton	3	102	6510	2	ton_
tone	4	69	5374	2	tone
tonga	6	56	1969	2	tonga
tongs	6	59	2846	2	tongs
tons	4	65	5305	2	tons
tony	7	56	3515	2	tony
trank	9	62	2242	2	trank
tranq	14	54	1689	2	tranq
trans	5	49	3304	2	trans
trig	5	55	2816	2	trig
trog	5	76	2821	2	trog
trug	5	57	2004	2	trug
tug	4	59	3740	2	t_ug
tun	3	58	4519	2	tun_
tuna	4	51	2784	2	tuna
tune	4	56	3586	2	tune
tungs	6	55	2062	2	tungs
tuns	4	51	3866	2	tuns
twangs	10	35	809	2	twangs
twangy	13	38	698	2	twangy
twig	8	76	1577	2	twig
tying	9	60	1984	2	tying
tyne	7	63	2505	2	tyne
van	6	62	4633	2	van_
vane	7	55	3469	2	vane
vangs	9	63	1958	2	vangs
vans	7	62	3673	2	vans
wag	7	64	5175	2	wa_g
wan	6	67	6194	2	wan_
wand	8	58	3388	2	wand
wane	7	63	4472	2	wane
wank	11	56	3251	2	wank
wans	7	64	5227	2	wans
want	7	61	5617	2	want
wany	10	64	3236	2	wany
whang	12	48	1338	2	whang
wing	8	63	3922	2	wing
wrang	9	47	1611	2	wrang
yag	7	69	4773	2	ya_g
yangs	9	56	1869	2	yangs
yank	11	54	2367	2	yank
zag	13	75	3947	2	za_g
zany	16	73	1699	2	zany
zing	14	57	2861	2	zing

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.296	603685.8
2	DLD Change Limit	29872	301	0.923	32364.0
3	Display Results	301	301	0.076	3960.5
	(SQL Overall)	178691	301	1.295	137985.3