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

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

461 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
fine	7	51	4796	(None)
bine	6	66	5087	1	bine
cine	6	62	4295	1	cine
dine	5	55	5534	1	dine
fane	7	53	4357	1	fane
fice	9	57	3712	1	fice
fie	6	71	5245	1	fi_e
fife	10	60	2771	1	fife
file	7	54	4665	1	file
fin	6	64	5804	1	fin_
find	8	75	3261	1	find
fined	9	49	3050	1	fined
finer	8	54	3156	1	finer
fines	8	66	4426	1	fines
fink	11	75	3213	1	fink
fino	7	60	3470	1	fino
fins	7	58	4910	1	fins
fire	7	62	4560	1	fire
five	10	76	2975	1	five
kine	8	56	4344	1	kine
line	4	69	6558	1	line
mine	6	72	5618	1	mine
nine	4	58	4218	1	nine
pine	6	77	5572	1	pine
sine	4	65	6063	1	sine
tine	4	58	5514	1	tine
vine	7	56	4369	1	vine
wine	7	49	5343	1	wine
zine	13	70	3616	1	zine
acne	6	66	2587	2	acne
affine	12	3	1050	2	affine
afire	8	62	1591	2	afire
aide	5	60	4501	2	aide
ain	3	75	7910	2	ain_
ains	4	61	5889	2	ains
aline	5	72	4315	2	aline
amine	7	58	3538	2	amine
ane	3	78	6695	2	_ane
azine	14	67	2141	2	azine
bane	6	52	5043	2	bane
bene	6	64	3949	2	bene
bice	8	62	3557	2	bice
bide	7	60	4151	2	bide
bike	10	65	3261	2	bike
bile	6	61	4719	2	bile
bin	5	66	5865	2	bin_
bind	7	62	3452	2	bind
biner	7	59	3069	2	biner
bines	7	69	4679	2	bines
binge	8	51	2551	2	binge
bins	6	65	4826	2	bins
bint	6	73	5505	2	bint
bise	6	64	3711	2	bise
bite	6	65	4701	2	bite
bize	15	59	2630	2	bize
bone	6	59	4932	2	bone
brine	7	51	3227	2	brine
cane	6	66	5312	2	cane
chine	10	52	3172	2	chine
cines	7	52	3968	2	cines
cire	6	58	3638	2	cire
cite	6	56	4035	2	cite
cline	7	64	2853	2	cline
cone	6	72	5696	2	cone
define	10	47	1814	2	define
dene	5	66	4341	2	dene
dice	7	58	4190	2	dice
die	4	67	5966	2	di_e
diene	6	57	2013	2	diene
dike	9	59	3577	2	dike
dime	7	62	3765	2	dime
din	4	64	5947	2	din_
dined	7	64	3199	2	dined
diner	6	56	3290	2	diner
dines	6	64	4915	2	dines
ding	6	69	4096	2	ding
dinge	7	56	2730	2	dinge
dink	9	71	3781	2	dink
dino	5	60	3676	2	dino
dins	5	66	5205	2	dins
dint	5	67	5906	2	dint
dire	5	66	4415	2	dire
dite	5	55	4756	2	dite
dive	8	56	3478	2	dive
done	5	57	4791	2	done
dune	5	61	3758	2	dune
dwine	9	56	1614	2	dwine
dyne	8	53	2093	2	dyne
eide	5	58	3225	2	eide
erne	4	67	2743	2	erne
esne	4	70	1879	2	esne
exine	12	55	1849	2	exine
eyne	7	63	2246	2	eyne
face	9	61	4012	2	face
fade	8	57	3635	2	fade
fain	7	58	4056	2	fain_
fainer	9	47	1724	2	fainer
faint	8	58	3706	2	faint
fake	11	55	3494	2	fake
fame	9	56	3939	2	fame
famine	11	43	1819	2	famine
fan	6	71	5886	2	fan_
fanes	8	46	3989	2	fanes
fang	8	54	3256	2	fang
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
fare	7	63	5446	2	fare
fate	7	54	4428	2	fate
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
fe	5	79	4474	2	f__e
fee	6	68	6201	2	f_ee
feint	8	47	3225	2	feint
feline	9	48	2014	2	feline
feme	9	61	3054	2	feme
fen	6	68	5135	2	fen_
fence	10	53	1991	2	fence
fend	8	48	3297	2	fend
fens	7	61	3976	2	fens
fere	7	63	4223	2	fere
ferine	9	64	2258	2	ferine
fete	7	57	3492	2	fete
fiance	11	3	1074	2	fiance
fiar	7	64	2734	2	fiar
fiat	7	66	4665	2	fiat
fib	8	63	4428	2	fi_b
fiber	10	49	2113	2	fiber
fibre	10	48	1284	2	fibre
fibs	9	63	2951	2	fibs
fices	10	60	3116	2	fices
fiche	13	46	1674	2	fiche
fico	9	58	2460	2	fico
fid	7	68	4770	2	fi_d
fidge	10	45	1607	2	fidge
fido	8	77	2641	2	fido
fids	8	70	3475	2	fids
fief	10	73	3137	2	fief
fiend	9	53	1298	2	fiend
fifed	12	51	1597	2	fifed
fifer	11	55	1997	2	fifer
fifes	11	48	2239	2	fifes
fig	7	62	4284	2	fi_g
figs	8	53	3265	2	figs
fil	6	54	4715	2	fi_l
fila	7	47	2914	2	fila
filed	9	53	3190	2	filed
filer	8	54	3300	2	filer
files	8	54	4127	2	files
filet	8	55	4016	2	filet
fill	7	55	4020	2	fill
fille	8	43	2740	2	fille
film	9	48	2818	2	film
filo	7	60	3429	2	filo
fils	7	58	3870	2	fils
final	8	39	2203	2	final
finale	9	41	1676	2	finale
finca	10	47	1450	2	finca
finch	13	54	1697	2	finch
finder	10	40	2023	2	finder
finds	9	54	2483	2	finds
finely	12	30	1156	2	finely
finery	12	45	1289	2	finery
finest	9	43	2173	2	finest
finger	10	49	2033	2	finger
finis	8	68	2426	2	finis
finite	9	3	1682	2	finite
finked	14	42	1462	2	finked
finks	12	54	2422	2	finks
finned	10	41	1460	2	finned
finny	11	47	1675	2	finny
finos	8	62	2695	2	finos
fique	17	3	914	2	fique
fir	6	67	4490	2	fi_r
fired	9	48	2974	2	fired
firer	8	112	2925	2	firer
fires	8	57	4075	2	fires
firm	9	60	2646	2	firm
firn	7	69	2751	2	firn
firns	8	60	1854	2	firns
firs	7	66	3772	2	firs
fisc	9	68	1976	2	fisc
fish	10	69	2628	2	fish
fist	7	62	4843	2	fist
fit	6	63	6546	2	fi_t
fits	7	60	4347	2	fits
fiver	11	60	2494	2	fiver
fives	11	60	2736	2	fives
fix	13	62	3611	2	fi_x
fixed	16	54	1695	2	fixed
fixer	15	47	1783	2	fixer
fixes	15	47	2359	2	fixes
fixt	14	107	2972	2	fixt
fiz	15	62	3877	2	fi_z
fizz	15	75	1983	2	fizz
flee	7	62	3879	2	flee
fling	9	70	2351	2	fling
flint	8	73	3350	2	flint
flite	8	54	2496	2	flite
floe	7	61	2977	2	floe
flue	7	53	2985	2	flue
foe	6	63	5081	2	f_oe
foin	7	72	3156	2	foin_
foined	10	59	1501	2	foined
foins	8	55	2338	2	foins
fon	6	63	5227	2	fon_
fond	8	63	3095	2	fond
fons	7	69	4389	2	fons
font	7	71	4375	2	font
fore	7	83	5147	2	fore
frae	7	53	3047	2	frae
free	7	59	4018	2	free
fringe	10	40	1395	2	fringe
frise	8	53	2245	2	frise
froe	7	53	2999	2	froe
fume	9	67	2763	2	fume
fun	6	68	4114	2	fun_
fund	8	56	2498	2	fund
funk	11	58	2562	2	funk
funs	7	52	3573	2	funs
fuse	7	64	2999	2	fuse
fuze	16	64	2237	2	fuze
fyce	12	63	1683	2	fyce
fyke	14	59	1529	2	fyke
gane	5	51	4530	2	gane
gene	5	62	3722	2	gene
gibe	7	59	2779	2	gibe
gie	4	71	4955	2	gi_e
gien	5	63	3003	2	gien
gin	4	60	5576	2	gin_
gink	9	71	2953	2	gink
gins	5	55	4396	2	gins
gite	5	54	3862	2	gite
give	8	58	2936	2	give
gone	5	56	3904	2	gone
gwine	9	55	1366	2	gwine
hide	8	51	3465	2	hide
hie	6	76	5271	2	hi_e
hike	11	68	3040	2	hike
hin	6	75	5957	2	hin_
hind	8	55	2976	2	hind
hinge	9	53	2345	2	hinge
hins	7	64	4800	2	hins
hint	7	74	5575	2	hint
hire	7	55	3897	2	hire
hive	10	60	2968	2	hive
hone	7	75	4932	2	hone
ice	5	67	3725	2	_ice
imine	7	58	2106	2	imine
in	2	81	5087	2	_in_
ink	7	64	3364	2	_ink
inn	3	67	2744	2	_inn
ins	3	59	4561	2	_ins
ire	3	69	4318	2	_ire
jane	11	50	3148	2	jane
jibe	13	63	2340	2	jibe
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
jive	14	61	2360	2	jive
kane	8	51	3398	2	kane
kibe	10	65	2346	2	kibe
kike	7	65	2480	2	kike
kin	7	63	5398	2	kin_
kina	8	56	3201	2	kina
kind	9	61	2857	2	kind
kines	9	50	3914	2	kines
king	9	59	3367	2	king
kink	7	60	3441	2	kink
kino	8	62	3363	2	kino
kins	8	57	4792	2	kins
kite	8	53	3825	2	kite
koine	9	5	1649	2	koine
kune	8	54	2458	2	kune
lane	4	51	5333	2	lane
liane	5	47	2066	2	liane
lice	6	60	4507	2	lice
lie	3	82	6453	2	li_e
lien	4	53	3981	2	lien
life	7	54	3374	2	life
like	8	60	4085	2	like
lime	6	62	4494	2	lime
lin	3	79	6738	2	lin_
lined	6	49	3464	2	lined
linen	5	57	2872	2	linen
liner	5	59	3892	2	liner
lines	5	70	5457	2	lines
liney	8	70	2963	2	liney
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
lipe	6	68	3974	2	lipe
lire	4	78	4530	2	lire
lite	4	70	5455	2	lite
live	7	65	4100	2	live
lone	4	58	4913	2	lone
lune	4	71	4049	2	lune
mane	6	50	5203	2	mane
mice	8	74	4224	2	mice
mien	6	50	2837	2	mien
mike	10	55	3530	2	mike
mile	6	63	5258	2	mile
mime	8	57	3641	2	mime
mina	6	51	3693	2	mina
minae	7	56	2772	2	minae
mince	9	53	2523	2	mince
mind	7	54	3439	2	mind
mined	8	53	3335	2	mined
miner	7	69	3354	2	miner
mines	7	56	5195	2	mines
mini	6	56	3457	2	mini
mink	10	66	3654	2	mink
minke	11	54	2176	2	minke
mint	6	67	5807	2	mint
minx	13	77	2336	2	minx
mire	6	67	4824	2	mire
mise	6	60	4359	2	mise
mite	6	62	4942	2	mite
ne	2	70	4510	2	__ne
nene	4	59	3206	2	nene
nice	6	55	3472	2	nice
nide	5	55	3580	2	nide
nines	5	59	3734	2	nines
nite	4	59	4359	2	nite
nixe	11	57	2203	2	nixe
none	4	57	4317	2	none
oink	8	54	2935	2	oink
one	3	70	5091	2	_one
opine	7	74	2246	2	opine
ovine	8	63	1664	2	ovine
pane	6	49	5029	2	pane
pice	8	46	4110	2	pice
pie	5	54	5741	2	pi_e
pike	10	63	3522	2	pike
pile	6	56	4970	2	pile
pin	5	70	6673	2	pin_
pina	6	58	4264	2	pina
pined	8	59	3532	2	pined
pines	7	60	4886	2	pines
piney	10	57	2750	2	piney
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
pipe	8	64	3444	2	pipe
pone	6	57	4753	2	pone
refine	9	52	2569	2	refine
rice	6	49	4292	2	rice
ride	5	59	4514	2	ride
rife	7	46	3233	2	rife
rile	4	56	5054	2	rile
rime	6	51	3889	2	rime
rin	3	66	6319	2	rin_
rind	5	65	3561	2	rind
ring	5	65	4116	2	ring
rink	8	77	3700	2	rink
rins	4	61	5320	2	rins
rinse	5	48	2097	2	rinse
ripe	6	60	3893	2	ripe
rise	4	59	4524	2	rise
rite	4	58	4946	2	rite
rive	7	55	3773	2	rive
rune	4	52	3630	2	rune
sane	4	59	5434	2	sane
seine	5	57	3287	2	seine
sene	4	68	4805	2	sene
shine	8	55	3309	2	shine
sice	6	55	4560	2	sice
side	5	54	4450	2	side
sike	8	71	3879	2	sike
sin	3	62	6590	2	sin_
since	7	50	2417	2	since
sines	5	59	5482	2	sines
sinew	8	47	1892	2	sinew
sing	5	75	4418	2	sing
singe	6	57	3113	2	singe
sinh	7	62	3805	2	sinh
sink	8	66	4015	2	sink
sins	4	67	5528	2	sins
sipe	6	73	4105	2	sipe
sire	4	61	5042	2	sire
site	4	70	5242	2	site
size	13	56	3097	2	size
sone	4	66	4998	2	sone
spine	7	65	3442	2	spine
swine	8	56	2530	2	swine
syne	7	57	2576	2	syne
thine	8	50	2686	2	thine
tide	5	52	3739	2	tide
tie	3	65	5754	2	ti_e
tike	8	55	3449	2	tike
tile	4	54	5145	2	tile
time	6	62	3502	2	time
tin	3	63	6218	2	tin_
tinea	5	49	2316	2	tinea
tined	6	54	3453	2	tined
tines	5	48	4842	2	tines
ting	5	61	3992	2	ting
tinge	6	46	2663	2	tinge
tins	4	52	5131	2	tins
tint	4	67	5887	2	tint
tiny	7	61	3464	2	tiny
tire	4	61	4336	2	tire
tone	4	69	5374	2	tone
trine	5	47	3460	2	trine
tune	4	56	3586	2	tune
twine	8	58	2236	2	twine
tyne	7	63	2505	2	tyne
urine	5	50	2660	2	urine
vane	7	55	3469	2	vane
vibe	9	51	2451	2	vibe
vice	9	57	3286	2	vice
vide	8	54	3277	2	vide
vie	6	54	4764	2	vi_e
vile	7	61	3981	2	vile
vina	7	63	3181	2	vina
vined	9	56	2615	2	vined
vines	8	51	3764	2	vines
vino	7	61	2844	2	vino
viny	10	60	2596	2	viny
vise	7	56	3268	2	vise
vive	10	54	2663	2	vive
wane	7	63	4472	2	wane
whine	11	60	2281	2	whine
wide	8	52	3542	2	wide
wife	10	52	2803	2	wife
wile	7	59	4438	2	wile
win	6	64	5630	2	win_
wince	10	52	2088	2	wince
wind	8	55	3386	2	wind
wined	9	44	3418	2	wined
wines	8	55	4686	2	wines
winey	11	53	2543	2	winey
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
winze	17	50	1485	2	winze
wipe	9	48	3029	2	wipe
wire	7	58	3982	2	wire
wise	7	57	3735	2	wise
wite	7	54	4328	2	wite
wive	10	59	3176	2	wive
yin	6	76	4874	2	yin_
yince	10	52	1425	2	yince
yins	7	53	3513	2	yins
yipe	9	67	2219	2	yipe
zin	12	56	4378	2	zin_
zinc	15	68	1910	2	zinc
zineb	16	56	1414	2	zineb
zines	14	52	3265	2	zines
zing	14	57	2862	2	zing
zins	13	57	3501	2	zins
zone	13	52	3108	2	zone

Search took 6 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	1.640	108957.9
2	DLD Change Limit	29872	461	2.750	10862.5
3	Display Results	461	461	0.406	1135.5
	(SQL Overall)	178691	461	4.796	37258.3