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

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

274 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
pangs	8	46	2866	(None)
bangs	8	56	2777	1	bangs
dangs	7	56	2320	1	dangs
fangs	9	62	2407	1	fangs
gangs	7	62	2257	1	gangs
hangs	9	57	2672	1	hangs
panes	7	61	4869	1	panes
pang	7	53	3629	1	pang_
panga	8	53	2353	1	panga
pangas	9	99	2110	1	pangas
pans	6	58	5573	1	pan_s
pants	7	65	3692	1	pants
pings	8	58	3088	1	pings
pongs	8	55	2634	1	pongs
prangs	9	48	1623	1	prangs
pungs	8	54	2222	1	pungs
tangs	6	50	2834	1	tangs
vangs	9	63	1958	1	vangs
yangs	9	56	1869	1	yangs
ags	4	75	5166	2	_a_gs
anas	4	66	4986	2	_anas
ands	5	78	3361	2	_ands
anes	4	52	5593	2	_anes
anga	5	68	3135	2	_anga
angas	6	58	2798	2	_angas
angst	6	4	1549	2	_angst
anis	4	57	4646	2	_anis
ants	4	72	4347	2	_ants
anus	4	71	3111	2	_anus
bags	7	66	4550	2	ba_gs
bands	8	52	3342	2	bands
banes	7	49	4558	2	banes
bang	7	48	3700	2	bang_
banks	11	55	2790	2	banks
banns	7	53	2123	2	banns
bans	6	65	5514	2	ban_s
bhangs	12	44	966	2	bhangs
bongs	8	78	2842	2	bongs
bungs	8	53	2386	2	bungs
canes	7	53	5037	2	canes
cans	6	50	5085	2	can_s
cants	7	70	3694	2	cants
changs	12	52	1537	2	changs
clangs	9	51	1361	2	clangs
dags	6	66	4260	2	da_gs
dang	6	51	3154	2	dang_
dans	5	67	4815	2	dan_s
dings	7	63	3140	2	dings
dongs	7	65	2581	2	dongs
dungs	7	58	2197	2	dungs
engs	5	61	2139	2	_engs
fags	8	69	3912	2	fa_gs
fanes	8	46	3989	2	fanes
fang	8	54	3255	2	fang_
fanga	9	61	1962	2	fanga
fangas	10	50	1719	2	fangas
fanos	8	59	2650	2	fanos
fans	7	62	4737	2	fan_s
gags	6	64	4106	2	ga_gs
gang	6	60	3197	2	gang_
gongs	7	49	2161	2	gongs
hags	8	67	4084	2	ha_gs
hands	9	53	2738	2	hands
hang	8	55	3555	2	hang_
hanks	12	62	2686	2	hanks
hants	8	63	3540	2	hants
hongs	9	51	2620	2	hongs
jaggs	14	81	1149	2	jaggs
jags	12	61	3279	2	ja_gs
janes	12	49	2812	2	janes
kanas	9	53	2691	2	kanas
kanes	9	55	2937	2	kanes
kiangs	11	37	836	2	kiangs
kings	10	58	2556	2	kings
lags	5	65	4622	2	la_gs
lands	6	54	2690	2	lands
lanes	5	49	4679	2	lanes
lang	5	66	3738	2	lang_
liangs	7	44	1059	2	liangs
lings	6	71	3577	2	lings
longs	6	55	2706	2	longs
lungs	6	52	2388	2	lungs
mags	7	54	4453	2	ma_gs
manas	7	62	4043	2	manas
manes	7	66	4896	2	manes
manga	8	50	2620	2	manga
mangas	9	41	2292	2	mangas
mange	8	49	3019	2	mange
manges	9	46	2894	2	manges
mango	8	57	2432	2	mango
mangos	9	43	1933	2	mangos
mangy	11	50	2124	2	mangy
manos	7	49	3362	2	manos
mans	6	63	5455	2	man_s
manus	7	59	2493	2	manus
nags	5	54	3602	2	na_gs
nanas	5	59	2863	2	nanas
nans	4	61	3940	2	nan_s
orangs	7	41	1603	2	orangs
pacas	9	60	2940	2	pacas
paces	9	67	4111	2	paces
packs	13	55	2893	2	packs
pacs	8	58	4218	2	pa_cs
pacts	9	51	2580	2	pacts
padis	8	62	2714	2	padis
padnags	11	3	508	2	padnags
pads	7	67	4295	2	pa_ds
page	7	60	3610	2	pa_ge
pages	8	52	3507	2	pages
pagings	11	44	1106	2	pagings
paiks	11	47	1985	2	paiks
pails	7	58	3306	2	pails
pains	7	51	3828	2	pains
paints	8	59	2183	2	paints
pairs	7	53	2583	2	pairs
pales	7	57	5380	2	pales
palings	10	39	1582	2	palings
palls	7	43	3256	2	palls
palms	9	49	2175	2	palms
palps	9	47	1956	2	palps
pals	6	69	5135	2	pa_ls
pams	8	56	4176	2	pa_ms
pan	5	84	6645	2	pan__
panda	8	50	2261	2	panda
pandas	9	55	2196	2	pandas
pandy	11	50	2117	2	pandy
pane	6	49	5029	2	pan_e
paned	8	54	3718	2	paned
panel	7	60	2362	2	panel
panels	8	47	1652	2	panels
panged	10	47	2233	2	panged
pangen	9	41	1591	2	pangen
pangens	10	31	1206	2	pangens
panic	9	39	2390	2	panic
panics	10	38	1536	2	panics
panne	7	66	2365	2	panne
pannes	8	55	2285	2	pannes
pansy	10	57	1797	2	pansy
pant	6	60	6126	2	pan_t
panto	7	61	2941	2	panto
pantos	8	52	2274	2	pantos
panty	10	59	2930	2	panty
papas	9	49	2749	2	papas
paps	8	64	4345	2	pa_ps
parangs	10	43	1437	2	parangs
paras	7	61	4304	2	paras
pards	8	56	3433	2	pards
pares	7	71	6448	2	pares
parge	8	58	3185	2	parge
parges	9	45	2954	2	parges
pargo	8	67	2372	2	pargo
pargos	9	57	1904	2	pargos
parings	10	42	1921	2	parings
paris	7	51	4594	2	paris
parks	11	61	3446	2	parks
parrs	7	59	2867	2	parrs
pars	6	75	6079	2	pa_rs
parts	7	77	4337	2	parts
pas	5	87	7574	2	pa__s
pases	7	53	4650	2	pases
pass	6	52	3995	2	pa_ss
pasts	7	59	3650	2	pasts
pates	7	60	4789	2	pates
paths	10	55	2138	2	paths
pats	6	64	6085	2	pa_ts
paves	10	48	3392	2	paves
pavings	13	40	1163	2	pavings
pavis	10	64	2273	2	pavis
pawls	10	56	1766	2	pawls
pawns	10	88	1813	2	pawns
paws	9	60	3818	2	pa_ws
paxes	14	49	2842	2	paxes
pays	9	59	4022	2	pa_ys
peags	8	61	2284	2	peags
peans	7	54	3764	2	pean_s
pegs	7	55	3176	2	p_egs
penangs	10	26	837	2	penangs
pends	8	55	2719	2	pends
penes	7	58	3922	2	penes
pengo	8	43	1759	2	pengo
pengos	9	46	1241	2	pengos
penis	7	51	2932	2	penis
pens	6	56	4964	2	pen_s
pianos	8	43	1593	2	pianos
pians	7	51	2696	2	pian_s
pigs	7	66	3422	2	p_igs
pinangs	10	26	779	2	pinangs
pinas	7	54	3445	2	pinas
pines	7	60	4886	2	pines
ping	7	59	4359	2	ping_
pingo	8	71	2271	2	pingo
pingos	9	53	1767	2	pingos
pinks	11	57	2938	2	pinks
pins	6	55	5845	2	pin_s
pints	7	59	3622	2	pints
planes	8	50	2808	2	planes
planks	12	41	1675	2	planks
plans	7	57	3127	2	plan_s
plants	8	49	2180	2	plants
plugs	8	52	1349	2	plugs
ponds	8	53	2340	2	ponds
pones	7	45	4704	2	pones
pong	7	62	3114	2	pong_
pons	6	58	5060	2	pon_s
prang	8	48	2032	2	prang_
pranks	12	48	1472	2	pranks
prigs	8	52	1970	2	prigs
progs	8	66	2415	2	progs
prongs	9	43	1448	2	prongs
pugs	7	63	3277	2	p_ugs
punas	7	48	2675	2	punas
pung	7	54	2963	2	pung_
punks	11	48	2268	2	punks
puns	6	66	4148	2	pun_s
punts	7	58	2800	2	punts
raggs	7	52	1647	2	raggs
rags	5	54	4837	2	ra_gs
rands	6	59	3045	2	rands
rang	5	69	3916	2	rang_
range	6	47	2841	2	range
ranges	7	38	2692	2	ranges
rangy	9	53	2038	2	rangy
ranis	5	52	3583	2	ranis
ranks	9	52	2573	2	ranks
rants	5	59	3534	2	rants
rings	6	50	2917	2	rings
rungs	6	118	1940	2	rungs
sags	5	59	4840	2	sa_gs
sands	6	52	2858	2	sands
sanes	5	56	4907	2	sanes
sang	5	54	4123	2	sang_
sanga	6	60	2379	2	sanga
sangas	7	52	2265	2	sangas
sangh	9	55	1745	2	sangh
sanghs	10	53	1206	2	sanghs
sans	4	51	5336	2	san_s
sings	6	55	3270	2	sings
slangs	7	56	1534	2	slangs
snags	6	44	2131	2	snags
songs	6	77	2555	2	songs
spang	8	49	1973	2	spang_
spanks	12	45	1412	2	spanks
spans	7	45	2873	2	span_s
sprangs	10	46	1005	2	sprangs
stangs	7	50	1816	2	stangs
tags	5	55	4523	2	ta_gs
tang	5	61	3867	2	tang_
tanga	6	49	2369	2	tanga
tango	6	69	2117	2	tango
tangos	7	42	1630	2	tangos
tangy	9	45	1993	2	tangy
tanks	9	46	2473	2	tanks
tans	4	61	5482	2	tan_s
tings	6	53	2920	2	tings
tongs	6	59	2846	2	tongs
tungs	6	55	2062	2	tungs
twangs	10	35	809	2	twangs
vanes	8	51	3097	2	vanes
vang	8	49	2604	2	vang_
vans	7	62	3673	2	van_s
wags	8	61	4055	2	wa_gs
wands	9	64	2548	2	wands
wanes	8	50	4088	2	wanes
wanks	12	61	2448	2	wanks
wans	7	64	5227	2	wan_s
wants	8	79	3221	2	wants
whangs	13	43	972	2	whangs
wings	9	57	2724	2	wings
wrangs	10	46	1191	2	wrangs
yags	8	66	3229	2	ya_gs
yang	8	56	2607	2	yang_
yanks	12	53	1657	2	yanks
zags	14	68	2668	2	za_gs
zings	15	46	2089	2	zings

Search took 7 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	53800	0.733	243780.4
2	DLD Change Limit	53800	274	5.330	10093.8
3	Display Results	274	274	0.546	501.8
	(SQL Overall)	178691	274	6.609	27037.5