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

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

299 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
wind	8	55	3386	(None)
bind	7	62	3452	1	bind
find	8	75	3261	1	find
hind	8	55	2976	1	hind
kind	9	61	2857	1	kind
mind	7	54	3439	1	mind
rind	5	65	3561	1	rind
wand	8	58	3388	1	wand
wend	8	53	3045	1	wend
wild	8	51	2652	1	wild
win	6	64	5630	1	win_
winds	9	54	2561	1	winds
windy	12	61	1811	1	windy
wine	7	49	5343	1	wine
wined	9	44	3418	1	wined
wing	8	63	3923	1	wing
wink	11	64	3503	1	wink
wino	7	59	3362	1	wino
wins	7	59	4918	1	wins
winy	10	70	3433	1	winy
wynd	11	61	1446	1	wynd
aid	4	92	6909	2	ai_d
ain	3	75	7910	2	ain_
ains	4	61	5889	2	ains
and	4	72	4418	2	_and
awing	9	68	2732	2	awing
band	7	67	4092	2	band
bend	7	64	3526	2	bend
bid	6	77	5182	2	bi_d
bin	5	66	5865	2	bin_
bindi	8	56	1702	2	bindi
binds	8	66	2748	2	binds
bine	6	66	5087	2	bine
bins	6	65	4826	2	bins
bint	6	73	5505	2	bint
bird	7	61	2833	2	bird
blind	8	63	1932	2	blind
bond	7	53	3436	2	bond
bund	7	55	3066	2	bund
cine	6	62	4295	2	cine
did	5	68	5053	2	di_d
died	6	61	3786	2	died
din	4	64	5947	2	din_
dine	5	55	5534	2	dine
dined	7	64	3199	2	dined
ding	6	69	4096	2	ding
dink	9	71	3781	2	dink
dino	5	60	3676	2	dino
dins	5	66	5205	2	dins
dint	5	67	5906	2	dint
dwine	9	56	1614	2	dwine
dwined	11	46	1021	2	dwined
end	4	68	3436	2	_end
enwind	10	29	808	2	enwind
fend	8	48	3297	2	fend
fid	7	68	4770	2	fi_d
fiend	9	53	1298	2	fiend
fin	6	64	5804	2	fin_
finds	9	54	2483	2	finds
fine	7	51	4796	2	fine
fined	9	49	3050	2	fined
fink	11	75	3213	2	fink
fino	7	60	3470	2	fino
fins	7	58	4910	2	fins
fond	8	63	3095	2	fond
fund	8	56	2498	2	fund
gid	5	70	4728	2	gi_d
gied	6	46	3199	2	gied
gild	6	55	2652	2	gild
gin	4	60	5576	2	gin_
gink	9	71	2953	2	gink
gins	5	55	4396	2	gins
gird	6	54	2500	2	gird
grind	7	59	1756	2	grind
gwine	9	55	1366	2	gwine
hand	8	68	3371	2	hand
hid	7	62	4839	2	hi_d
hied	8	54	3405	2	hied
hin	6	75	5957	2	hin_
hinds	9	67	2148	2	hinds
hins	7	64	4800	2	hins
hint	7	74	5575	2	hint
id	3	89	4185	2	_i_d
in	2	81	5087	2	_in_
ink	7	64	3364	2	_ink
inn	3	67	2744	2	_inn
ins	3	59	4561	2	_ins
inwind	10	26	841	2	inwind
jin	10	64	4394	2	jin_
jink	15	62	2721	2	jink
jinn	11	54	2025	2	jinn
jins	11	56	3502	2	jins
jinx	18	55	1658	2	jinx
kid	8	65	4063	2	ki_d
kin	7	63	5398	2	kin_
kina	8	56	3201	2	kina
kinds	10	62	2183	2	kinds
kine	8	56	4344	2	kine
king	9	59	3367	2	king
kink	7	60	3441	2	kink
kino	8	62	3363	2	kino
kins	8	57	4792	2	kins
land	5	63	3731	2	land
lend	5	62	3367	2	lend
lid	4	74	5353	2	li_d
lied	5	58	3810	2	lied
lin	3	79	6738	2	lin_
lindy	9	69	1832	2	lindy
line	4	69	6558	2	line
lined	6	49	3464	2	lined
ling	5	74	4797	2	ling
link	8	69	4345	2	link
linn	4	60	3460	2	linn
lino	4	63	4338	2	lino
lins	4	70	5906	2	lins
lint	4	162	6624	2	lint
liny	7	81	4133	2	liny
mend	7	53	3403	2	mend
mid	6	73	5448	2	mi_d
mild	7	53	3086	2	mild
mina	6	51	3693	2	mina
minds	8	54	2713	2	minds
mine	6	72	5618	2	mine
mined	8	53	3335	2	mined
mini	6	56	3457	2	mini
mink	10	66	3654	2	mink
mint	6	67	5807	2	mint
minx	13	77	2336	2	minx
nine	4	58	4218	2	nine
oink	8	54	2935	2	oink
owing	9	62	2272	2	owing
pend	7	59	3453	2	pend
pied	7	50	3537	2	pied
pin	5	70	6673	2	pin_
pina	6	58	4264	2	pina
pine	6	77	5572	2	pine
pined	8	59	3532	2	pined
ping	7	59	4360	2	ping
pink	10	70	3939	2	pink
pins	6	55	5846	2	pins
pint	6	69	6318	2	pint
piny	9	118	3836	2	piny
poind	8	42	1791	2	poind
pond	7	55	3049	2	pond
rand	5	58	3957	2	rand
rend	5	61	3657	2	rend
rewind	10	47	1588	2	rewind
rid	4	67	5464	2	ri_d
rin	3	66	6319	2	rin_
rinds	6	48	2615	2	rinds
rindy	9	57	1740	2	rindy
ring	5	65	4116	2	ring
rink	8	77	3700	2	rink
rins	4	61	5320	2	rins
rynd	8	64	1410	2	rynd
sand	5	53	3847	2	sand
send	5	52	3729	2	send
sild	5	50	3059	2	sild
sin	3	62	6590	2	sin_
sine	4	65	6063	2	sine
sing	5	75	4418	2	sing
sinh	7	62	3805	2	sinh
sink	8	66	4015	2	sink
sins	4	67	5528	2	sins
swine	8	56	2530	2	swine
swing	9	61	2484	2	swing
swink	12	51	1635	2	swink
teind	6	2	1361	2	teind
tend	5	64	3377	2	tend
tied	5	55	3522	2	tied
tin	3	63	6218	2	tin_
tine	4	58	5514	2	tine
tined	6	54	3453	2	tined
ting	5	61	3992	2	ting
tins	4	52	5131	2	tins
tint	4	67	5887	2	tint
tiny	7	61	3464	2	tiny
twin	7	60	2308	2	twin_
twine	8	58	2236	2	twine
twined	10	44	1312	2	twined
twins	8	51	1898	2	twins
twiny	11	60	1281	2	twiny
unwind	10	26	1054	2	unwind
upwind	12	25	582	2	upwind
vend	8	66	2642	2	vend
viand	9	5	1107	2	viand
vid	7	72	4182	2	vi_d
vied	8	63	2864	2	vied
vina	7	63	3181	2	vina
vine	7	56	4369	2	vine
vined	9	56	2615	2	vined
vino	7	61	2844	2	vino
viny	10	60	2596	2	viny
wad	7	70	5390	2	w_ad
wain	7	58	4020	2	wain_
wains	8	69	3087	2	wains
wan	6	67	6194	2	wan_
wands	9	64	2548	2	wands
wane	7	63	4472	2	wane
waned	9	58	3178	2	waned
wank	11	56	3251	2	wank
wans	7	64	5227	2	wans
want	7	61	5617	2	want
wany	10	64	3236	2	wany
ward	8	65	4225	2	ward
wed	7	58	4363	2	w_ed
weed	8	56	3751	2	weed
weird	9	51	1128	2	weird
weld	8	47	2773	2	weld
wen	6	62	4960	2	wen_
wends	9	58	2281	2	wends
wens	7	63	3793	2	wens
went	7	60	5187	2	went
whid	11	54	1888	2	whid
whin	10	52	2569	2	whin_
whine	11	60	2281	2	whine
whined	13	47	1520	2	whined
whins	11	49	2233	2	whins
whiny	14	49	1557	2	whiny
wich	12	57	2475	2	wich
wick	13	57	2631	2	wick
widdy	13	61	1219	2	widdy
wide	8	52	3542	2	wide
wield	9	52	1391	2	wield
wife	10	52	2803	2	wife
wifed	12	51	1774	2	wifed
wig	7	67	4039	2	wi_g
wigs	8	49	3126	2	wigs
wilds	9	48	1821	2	wilds
wile	7	59	4438	2	wile
wiled	9	52	3155	2	wiled
will	7	57	3752	2	will
wilt	7	62	4630	2	wilt
wily	10	64	2882	2	wily
wimp	11	55	2153	2	wimp
wince	10	52	2088	2	wince
winced	12	44	1534	2	winced
winch	13	50	1666	2	winch
winded	11	49	1821	2	winded
winder	10	40	2526	2	winder
windle	10	46	1795	2	windle
window	13	4	736	2	window
windup	12	3	538	2	windup
wines	8	55	4686	2	wines
winey	11	53	2543	2	winey
winged	11	46	2083	2	winged
wings	9	57	2724	2	wings
wingy	12	65	2103	2	wingy
winked	14	40	1860	2	winked
winks	12	53	2543	2	winks
winned	10	40	1701	2	winned
winos	8	46	2504	2	winos
winze	17	50	1485	2	winze
wipe	9	48	3029	2	wipe
wiped	11	47	2208	2	wiped
wire	7	58	3982	2	wire
wired	9	53	2764	2	wired
wiry	10	64	2284	2	wiry
wis	6	65	5234	2	wi_s
wise	7	57	3735	2	wise
wised	9	51	2334	2	wised
wish	10	72	2874	2	wish
wisp	9	71	2408	2	wisp
wiss	7	56	3055	2	wiss
wist	7	80	4930	2	wist
wit	6	65	6378	2	wi_t
wite	7	54	4328	2	wite
wited	9	47	2714	2	wited
with	10	57	3048	2	with
wits	7	60	4488	2	wits
wive	10	59	3176	2	wive
wived	12	51	2150	2	wived
wiz	15	64	3416	2	wi_z
woad	8	55	2394	2	woad
wold	8	54	2907	2	wold
won	6	62	5206	2	won_
wonk	11	61	2530	2	wonk
wons	7	49	4204	2	wons
wont	7	58	4250	2	wont
wood	8	53	2938	2	wood
word	8	98	3200	2	word
wound	9	44	1421	2	wound
wried	9	55	1856	2	wried
wring	9	59	2071	2	wring
wud	7	62	2716	2	w_ud
wyn	9	59	2144	2	wyn_
wynds	12	63	1037	2	wynds
wynn	10	58	1129	2	wynn
wyns	10	57	1703	2	wyns
yid	7	66	4084	2	yi_d
yin	6	76	4874	2	yin_
yins	7	53	3513	2	yins
yird	8	70	1899	2	yird
yond	8	61	2231	2	yond
zin	12	56	4378	2	zin_
zinc	15	68	1910	2	zinc
zine	13	70	3616	2	zine
zing	14	57	2862	2	zing
zins	13	57	3501	2	zins

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	299	0.893	33451.3
3	Display Results	299	299	0.060	4983.3
	(SQL Overall)	178691	299	1.249	143067.3