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

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

289 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
hind	8	55	2976	(None)
bind	7	62	3452	1	bind
find	8	75	3261	1	find
hand	8	68	3371	1	hand
hid	7	62	4839	1	hi_d
hied	8	54	3405	1	hied
hin	6	75	5957	1	hin_
hinds	9	67	2148	1	hinds
hins	7	64	4800	1	hins
hint	7	74	5575	1	hint
kind	9	61	2857	1	kind
mind	7	54	3439	1	mind
rind	5	65	3561	1	rind
wind	8	55	3386	1	wind
ahing	9	89	2835	2	ahing
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
band	7	67	4092	2	band
behind	12	3	806	2	behind
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
chid	10	66	2641	2	chi_d
child	11	45	1622	2	child
chin	9	69	3474	2	chin_
china	10	50	2248	2	china
chine	10	52	3172	2	chine
chined	12	56	2006	2	chined
chink	14	53	2159	2	chink
chino	10	58	2331	2	chino
chins	10	56	3146	2	chins
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
end	4	68	3436	2	_end
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
had	7	76	5877	2	h_ad
haed	8	63	3858	2	haed
haint	8	54	3632	2	haint
hands	9	53	2738	2	hands
handy	12	55	2087	2	handy
hang	8	55	3556	2	hang
hank	11	51	3414	2	hank
hant	7	54	6159	2	hant
hard	8	54	4350	2	hard
head	8	71	3717	2	head
heed	8	64	3760	2	heed
held	8	53	3040	2	held
hen	6	75	5527	2	hen_
hens	7	56	4257	2	hens
hent	7	66	5638	2	hent
herd	8	49	3306	2	herd
hi	5	79	4759	2	hi__
hic	8	65	4057	2	hi_c
hick	13	55	3031	2	hick
hide	8	51	3465	2	hide
hided	10	52	2245	2	hided
hie	6	76	5271	2	hi_e
hies	7	48	4284	2	hies
high	11	66	1993	2	high
hike	11	68	3040	2	hike
hiked	13	59	1920	2	hiked
hila	7	62	2836	2	hila
hili	7	56	2664	2	hili
hill	7	64	3950	2	hill
hilt	7	58	5072	2	hilt
him	8	62	4767	2	hi_m
hims	9	52	3098	2	hims
hinder	10	41	2006	2	hinder
hinge	9	53	2345	2	hinge
hinged	11	46	1892	2	hinged
hinky	15	56	1875	2	hinky
hinny	11	56	1667	2	hinny
hinted	10	43	1832	2	hinted
hints	8	73	3062	2	hints
hip	8	67	5044	2	hi_p
hips	9	64	3371	2	hips
hire	7	55	3897	2	hire
hired	9	52	2626	2	hired
his	6	63	5951	2	hi_s
hisn	7	96	2094	2	hisn
hiss	7	56	2922	2	hiss
hist	7	65	5155	2	hist
hit	6	65	6920	2	hi_t
hits	7	55	4514	2	hits
hive	10	60	2968	2	hive
hived	12	52	1791	2	hived
hod	7	68	5247	2	h_od
hoed	8	78	3798	2	hoed
hold	8	62	3506	2	hold
hon	6	77	5938	2	hon_
honda	9	4	1498	2	honda
hone	7	75	4932	2	hone
honed	9	53	3226	2	honed
hong	8	58	3395	2	hong
honk	11	69	3119	2	honk
hons	7	73	5078	2	hons
hood	8	51	3233	2	hood
hound	9	50	1648	2	hound
hued	8	69	2585	2	hued
hun	6	58	4471	2	hun_
hung	8	61	2635	2	hung
hunh	10	63	2373	2	hunh
hunk	11	60	2954	2	hunk
huns	7	61	3693	2	huns
hunt	7	64	4549	2	hunt
hying	12	65	1474	2	hying
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
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
ohing	9	60	1881	2	ohing
oink	8	54	2935	2	oink
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
rhino	8	46	1432	2	rhino
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
shend	9	47	1997	2	shend
shied	9	61	2549	2	shied
shin	7	56	3431	2	shin_
shindy	13	44	932	2	shindy
shine	8	55	3309	2	shine
shined	10	46	2078	2	shined
shins	8	51	3104	2	shins
shiny	11	51	2214	2	shiny
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
teind	6	2	1361	2	teind
tend	5	64	3377	2	tend
thin	7	67	3239	2	thin_
thine	8	50	2686	2	thine
thing	9	66	2298	2	thing
think	12	50	1880	2	think
thins	8	58	2633	2	thins
third	9	59	1249	2	third
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
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
wand	8	58	3388	2	wand
wend	8	53	3045	2	wend
whid	11	54	1888	2	whi_d
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
wild	8	51	2652	2	wild
win	6	64	5630	2	win_
winds	9	54	2561	2	winds
windy	12	61	1811	2	windy
wine	7	49	5343	2	wine
wined	9	44	3418	2	wined
wing	8	63	3923	2	wing
wink	11	64	3503	2	wink
wino	7	59	3362	2	wino
wins	7	59	4918	2	wins
winy	10	70	3433	2	winy
wynd	11	61	1446	2	wynd
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.330	541487.9
2	DLD Change Limit	29872	289	1.060	28181.1
3	Display Results	289	289	0.080	3612.5
	(SQL Overall)	178691	289	1.470	121558.5