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

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

297 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
wank	11	56	3251	(None)
bank	10	58	3575	1	bank
dank	9	58	2824	1	dank
hank	11	51	3414	1	hank
lank	8	47	3445	1	lank
rank	8	51	3553	1	rank
sank	8	52	3683	1	sank
swank	12	53	1823	1	swank
tank	8	51	3403	1	tank
wack	13	53	3091	1	wack
walk	11	56	2561	1	walk
wan	6	67	6194	1	wan_
wand	8	58	3388	1	wand
wane	7	63	4472	1	wane
wanks	12	61	2448	1	wanks
wans	7	64	5227	1	wans
want	7	61	5617	1	want
wany	10	64	3236	1	wany
wark	11	57	3777	1	wark
wauk	11	52	2059	1	wauk
wink	11	64	3502	1	wink
wonk	11	61	2530	1	wonk
yank	11	54	2367	1	yank
an	2	118	7908	2	_an_
ana	3	95	5983	2	_ana
and	4	72	4417	2	_and
ane	3	78	6695	2	_ane
ani	3	77	5118	2	_ani
ankh	11	11	1441	2	_ankh
ant	3	72	7079	2	_ant
any	6	84	4049	2	_any
ark	7	70	4496	2	_ark
ask	7	71	3070	2	_ask
auk	7	62	3414	2	_auk
awn	6	80	3591	2	awn_
awns	7	53	2443	2	awns
awny	10	59	1930	2	awny
back	12	55	3576	2	back
balk	10	51	3222	2	balk
ban	5	83	6684	2	ban_
band	7	67	4092	2	band
bane	6	52	5043	2	bane
bang	7	48	3701	2	bang
bani	6	53	3496	2	bani
banks	11	55	2790	2	banks
bans	6	65	5514	2	bans
bark	10	62	4215	2	bark
bask	10	51	3142	2	bask
blank	11	54	1855	2	blank
bonk	10	55	3171	2	bonk
brank	11	52	2228	2	brank
bunk	10	57	3135	2	bunk
bwana	10	3	1024	2	bwana
calk	10	55	2766	2	calk
can	5	77	6014	2	can_
cane	6	66	5312	2	cane
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
cark	10	55	3927	2	cark
cask	10	56	2643	2	cask
clank	11	47	1952	2	clank
conk	10	65	3144	2	conk
crank	11	48	1961	2	crank
dak	8	63	4069	2	da_k
dan	4	68	5967	2	dan_
dang	6	51	3155	2	dang
dans	5	67	4815	2	dans
dark	9	51	3321	2	dark
dawk	12	61	1728	2	dawk
dink	9	71	3780	2	dink
drank	10	48	1620	2	drank
dunk	9	62	2857	2	dunk
fan	6	71	5886	2	fan_
fane	7	53	4357	2	fane
fang	8	54	3256	2	fang
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
fink	11	75	3212	2	fink
flank	12	46	1809	2	flank
frank	12	44	1751	2	frank
funk	11	58	2562	2	funk
gan	4	80	6013	2	gan_
gane	5	51	4530	2	gane
gang	6	60	3198	2	gang
gawk	12	67	1669	2	gawk
gink	9	71	2952	2	gink
gunk	9	54	2357	2	gunk
hack	13	51	3454	2	hack
haik	11	55	2698	2	haik
hand	8	68	3371	2	hand
hang	8	55	3556	2	hang
hanks	12	62	2686	2	hanks
hanky	15	54	1829	2	hanky
hant	7	54	6159	2	hant
hark	11	52	3739	2	hark
hawk	14	55	2115	2	hawk
honk	11	69	3119	2	honk
hunk	11	60	2954	2	hunk
hwan	10	57	1689	2	hwan_
ink	7	64	3363	2	_ink
jack	17	52	2486	2	jack
jane	11	50	3148	2	jane
jauk	15	58	1609	2	jauk
jink	15	62	2720	2	jink
junk	15	51	2103	2	junk
kana	8	59	2853	2	kana
kane	8	51	3397	2	kane
kink	7	60	3440	2	kink
konk	7	93	2061	2	konk
lack	10	58	3768	2	lack
land	5	63	3731	2	land
lane	4	51	5333	2	lane
lang	5	66	3739	2	lang
lanky	12	55	1748	2	lanky
lark	8	57	3386	2	lark
link	8	69	4344	2	link
lunk	8	60	3072	2	lunk
mack	12	57	3365	2	mack
man	5	74	6587	2	man_
mana	6	53	4196	2	mana
mane	6	50	5203	2	mane
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
many	9	57	3186	2	many
mark	10	51	3806	2	mark
mask	10	52	2736	2	mask
mink	10	66	3653	2	mink
monk	10	59	2852	2	monk
nan	3	78	5488	2	nan_
nana	4	66	3290	2	nana
nans	4	61	3940	2	nans
nark	8	52	3006	2	nark
oak	7	62	3865	2	oa_k
oink	8	54	2934	2	oink
pack	12	55	3544	2	pack
paik	10	57	2680	2	paik
pan	5	84	6645	2	pan_
pane	6	49	5029	2	pane
pang	7	53	3630	2	pang
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
park	10	52	3749	2	park
pink	10	70	3938	2	pink
plank	11	52	2114	2	plank
prank	11	50	1945	2	prank
punk	10	57	2997	2	punk
rack	10	62	3488	2	rack
ran	3	82	6662	2	ran_
rand	5	58	3957	2	rand
rang	5	69	3917	2	rang
rani	4	66	4011	2	rani
ranks	9	52	2573	2	ranks
rant	4	58	6468	2	rant
rink	8	77	3699	2	rink
sack	10	53	3731	2	sack
sand	5	53	3847	2	sand
sane	4	59	5434	2	sane
sang	5	54	4124	2	sang
sans	4	51	5336	2	sans
sark	8	49	3897	2	sark
shank	12	54	2219	2	shank
sink	8	66	4014	2	sink
skank	8	44	1558	2	skank
slank	9	58	2277	2	slank
spank	11	59	1957	2	spank
stank	9	58	2330	2	stank
sunk	8	50	3181	2	sunk
swan	7	66	3131	2	swan_
swang	9	55	1972	2	swang
swanks	13	48	1156	2	swanks
swanky	16	44	797	2	swanky
swans	8	46	2501	2	swans
swink	12	51	1635	2	swink
tack	10	65	3629	2	tack
talk	8	62	3009	2	talk
tan	3	71	6758	2	tan_
tang	5	61	3869	2	tang
tanka	9	38	1749	2	tanka
tanks	9	46	2474	2	tanks
tans	4	61	5483	2	tans
task	8	53	2665	2	task
thank	12	58	1780	2	thank
trank	9	62	2242	2	trank
twang	9	45	1186	2	twang
twanky	16	44	577	2	twanky
van	6	62	4633	2	van_
vane	7	55	3469	2	vane
vang	8	49	2605	2	vang
vans	7	62	3673	2	vans
wab	8	70	5183	2	wa_b
wabs	9	73	3723	2	wabs
wacke	14	59	1862	2	wacke
wacko	14	55	1438	2	wacko
wacks	14	66	2628	2	wacks
wacky	17	47	1493	2	wacky
wad	7	70	5389	2	wa_d
wade	8	52	3706	2	wade
wadi	8	62	2817	2	wadi
wads	8	73	4314	2	wads
wady	11	53	2499	2	wady
wae	6	75	5695	2	wa_e
waes	7	60	4860	2	waes
waff	13	42	2804	2	waff
waft	10	61	3900	2	waft
wag	7	64	5175	2	wa_g
wage	8	48	3408	2	wage
wags	8	61	4055	2	wags
waif	10	58	3675	2	waif
wail	7	52	3882	2	wail
wain	7	58	4020	2	wain
wains	8	69	3087	2	wains
wair	7	58	3005	2	wair
wait	7	55	5369	2	wait
wake	11	49	3570	2	wake
wale	7	45	4643	2	wale
walks	12	62	1850	2	walks
wall	7	62	3610	2	wall
waly	10	58	3090	2	waly
wame	9	50	3548	2	wame
wands	9	64	2548	2	wands
waned	9	58	3178	2	waned
wanes	8	50	4088	2	wanes
waney	11	51	2032	2	waney
wanked	14	45	1715	2	wanked
wanker	13	42	1997	2	wanker
wanly	11	51	1802	2	wanly
wants	8	79	3221	2	wants
wap	8	65	5337	2	wa_p
waps	9	66	4208	2	waps
war	6	72	6242	2	wa_r
ward	8	65	4225	2	ward
ware	7	62	5472	2	ware
warks	12	79	3240	2	warks
warm	9	59	3567	2	warm
warn	7	52	3932	2	warn
warns	8	72	3100	2	warns
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
wart	7	78	6608	2	wart
wary	10	67	4001	2	wary
was	6	87	6756	2	wa_s
wash	10	60	3381	2	wash
wasp	9	56	2685	2	wasp
wast	7	56	5585	2	wast
wat	6	73	7892	2	wa_t
wats	7	75	5588	2	wats
watt	7	55	4541	2	watt
wauks	12	55	1516	2	wauks
waul	7	69	2731	2	waul
waur	7	68	1990	2	waur
wave	10	52	3473	2	wave
wavy	13	66	2047	2	wavy
waw	9	70	4638	2	wa_w
wawl	10	53	2194	2	wawl
waws	10	68	3490	2	waws
wax	13	70	4118	2	wa_x
waxy	17	59	1820	2	waxy
way	9	67	5766	2	wa_y
ways	10	77	3795	2	ways
weak	11	71	2630	2	weak
wean	7	57	3435	2	wean_
weans	8	53	2674	2	weans
week	11	64	2815	2	week
wen	6	62	4960	2	wen_
wend	8	53	3045	2	wend
wens	7	63	3793	2	wens
went	7	60	5187	2	went
whack	17	48	1302	2	whack
whang	12	48	1338	2	whang
wick	13	57	2630	2	wick
win	6	64	5629	2	win_
wind	8	55	3385	2	wind
wine	7	49	5342	2	wine
wing	8	63	3922	2	wing
winks	12	53	2543	2	winks
wino	7	59	3361	2	wino
wins	7	59	4917	2	wins
winy	10	70	3432	2	winy
wok	10	63	3417	2	w_ok
won	6	62	5206	2	won_
wonks	12	48	1834	2	wonks
wonky	15	40	1177	2	wonky
wons	7	49	4204	2	wons
wont	7	58	4250	2	wont
work	11	55	2884	2	work
wrack	14	54	1388	2	wrack
wrang	9	47	1611	2	wrang
wyn	9	59	2144	2	wyn_
wynd	11	61	1446	2	wynd
wynn	10	58	1129	2	wynn
wyns	10	57	1703	2	wyns
yack	13	54	2597	2	yack
yak	10	70	3856	2	ya_k
yang	8	56	2608	2	yang
yanks	12	53	1657	2	yanks
zany	16	73	1699	2	zany
zonk	17	50	1862	2	zonk

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.263	679433.5
2	DLD Change Limit	29872	297	0.796	37527.6
3	Display Results	297	297	0.063	4714.3
	(SQL Overall)	178691	297	1.122	159261.1