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

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

355 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
tain	4	55	4807	(None)
ain	3	75	7909	1	_ain
cain	6	56	4391	1	cain
fain	7	58	4056	1	fain
gain	5	60	4216	1	gain
kain	8	53	3429	1	kain
lain	4	61	4628	1	lain
main	6	53	4552	1	main
pain	6	56	4724	1	pain
rain	4	62	5173	1	rain
sain	4	55	5129	1	sain
stain	5	57	2794	1	stain
tail	4	54	4365	1	tail
tains	5	49	3632	1	tains
taint	5	55	4228	1	taint
takin	9	49	2130	1	takin
tan	3	71	6757	1	ta_n
tarn	4	68	4272	1	tarn
thin	7	67	3239	1	thin
tin	3	63	6217	1	t_in
train	5	65	2911	1	train
twain	8	63	1362	1	twain
twin	7	60	2308	1	twin
tyin	7	64	2400	1	tyin
vain	7	52	3300	1	vain
wain	7	58	4020	1	wain
again	6	52	1812	2	again
agin	5	61	3271	2	agin
ai	2	112	8839	2	_ai_
aid	4	92	6907	2	_aid
ail	3	71	7104	2	_ail
aim	5	78	5821	2	_aim
ains	4	61	5888	2	_ains
air	3	80	5839	2	_air
airn	4	64	3383	2	_airn
ais	3	90	8357	2	_ais
ait	3	80	9390	2	_ait
akin	8	63	2803	2	akin
amain	7	49	2291	2	amain
amin	6	60	4225	2	amin
an	2	118	7908	2	_a_n
ani	3	77	5118	2	_ani
attain	6	3	1175	2	attain
atwain	9	3	781	2	atwain
awn	6	80	3591	2	_awn
ayin	7	63	3174	2	ayin
bail	6	50	4280	2	bail
bairn	7	75	1553	2	bairn
bait	6	65	5600	2	bait
ban	5	83	6684	2	ba_n
bani	6	53	3496	2	bani
barn	6	64	4464	2	barn
basin	7	50	2692	2	basin
bin	5	66	5864	2	_bin
blain	7	54	2179	2	blain
blin	6	72	2817	2	blin
brain	7	62	2938	2	brain
brin	6	70	3819	2	brin
cabin	9	48	2094	2	cabin
caid	7	78	3753	2	caid
cains	7	53	3430	2	cains
cairn	7	57	1751	2	cairn
can	5	77	6014	2	ca_n
carn	6	62	4543	2	carn
chain	10	57	2367	2	chain
chin	9	69	3474	2	chin
coin	6	66	4535	2	coin
dais	5	70	4070	2	dais
damn	7	57	2432	2	damn
dan	4	68	5967	2	da_n
darn	5	64	3462	2	darn
dawn	8	56	2420	2	dawn
detain	7	46	1738	2	detain
din	4	64	5946	2	_din
djin	12	9	1163	2	djin
drain	6	52	2289	2	drain
earn	4	67	3755	2	earn
elain	5	53	2470	2	elain
etamin	8	13	1185	2	etamin
fagin	9	2	1657	2	fagin
fail	7	48	4024	2	fail
faint	8	58	3706	2	faint
fair	7	63	3252	2	fair
fan	6	71	5886	2	fa_n
faun	7	62	2662	2	faun
fawn	10	53	2195	2	fawn
fin	6	64	5803	2	_fin
foin	7	72	3156	2	foin
gaen	5	73	2960	2	gaen
gains	6	57	2951	2	gains
gait	5	61	5019	2	gait
gamin	8	44	2300	2	gamin
gan	4	80	6013	2	ga_n
gaun	5	64	2771	2	gaun
gin	4	60	5575	2	_gin
grain	6	51	2625	2	grain
grin	5	57	3372	2	grin
haen	7	62	2945	2	haen
haik	11	55	2698	2	haik
hail	7	48	3906	2	hail
haint	8	54	3632	2	haint
hair	7	63	3014	2	hair
hin	6	75	5956	2	_hin
in	2	81	5086	2	__in
jail	11	55	2909	2	jail
jin	10	64	4393	2	_jin
join	11	67	2483	2	join
kaif	11	69	3393	2	kaif
kail	8	51	3149	2	kail
kains	9	61	2564	2	kains
kaon	8	75	2102	2	kaon
karn	8	61	2941	2	karn
kin	7	63	5396	2	_kin
laic	6	59	3156	2	laic
laid	5	64	3914	2	laid
lair	4	59	3415	2	lair
lapin	7	52	2292	2	lapin
lawn	7	59	2563	2	lawn
layin	8	47	2033	2	layin
lin	3	79	6737	2	_lin
loin	4	68	3872	2	loin
maid	7	55	3766	2	maid
mail	6	55	4345	2	mail
maim	8	58	3149	2	maim
mains	7	56	3511	2	mains
mair	6	61	3378	2	mair
man	5	74	6587	2	ma_n
matin	7	51	3285	2	matin
maun	6	57	2721	2	maun
mavin	10	57	2295	2	mavin
mawn	9	44	2414	2	mawn
naan	4	76	2193	2	naan
naif	7	68	3902	2	naif
nail	4	58	3865	2	nail
nan	3	78	5488	2	na_n
obtain	8	3	918	2	obtain
paid	7	57	3748	2	paid
paik	10	57	2680	2	paik
pail	6	61	4183	2	pail
pains	7	51	3828	2	pains
paint	7	54	4369	2	paint
pair	6	60	3151	2	pair
pan	5	84	6645	2	pa_n
patin	7	68	3285	2	patin
pavin	10	56	2320	2	pavin
pawn	9	46	2530	2	pawn
pein	6	58	3494	2	pein
pian	6	61	3609	2	pian
pin	5	70	6672	2	_pin
plain	7	48	2330	2	plain
pyin	9	68	2323	2	pyin
qaid	14	60	2384	2	qaid
quin	13	58	2392	2	quin
rai	3	76	5822	2	rai_
raia	4	66	3838	2	raia
raid	5	52	4307	2	raid
rail	4	61	4776	2	rail
rains	5	51	4023	2	rains
rainy	8	59	2108	2	rainy
rais	4	52	5262	2	rais
ran	3	82	6662	2	ra_n
rani	4	66	4011	2	rani
ravin	8	56	2465	2	ravin
rawin	8	55	2147	2	rawin
rein	4	60	4089	2	rein
retain	6	45	2328	2	retain
rin	3	66	6318	2	_rin
ruin	4	74	3051	2	ruin
sabin	7	49	2495	2	sabin
said	5	57	4211	2	said
sail	4	54	4716	2	sail
sains	5	56	3997	2	sains
saint	5	51	4707	2	saint
sarin	5	52	3925	2	sarin
sasin	5	46	2657	2	sasin
satin	5	59	3522	2	satin
savin	8	46	2508	2	savin
sawn	7	54	2816	2	sawn
shin	7	56	3431	2	shin
sin	3	62	6589	2	_sin
skin	8	59	2753	2	skin
slain	5	49	2357	2	slain
spin	6	62	3130	2	spin
staid	6	67	2208	2	staid
staig	6	55	1964	2	staig
stains	6	49	2365	2	stains
stair	5	47	1994	2	stair
statin	6	39	2147	2	statin
stein	5	46	2054	2	stein
strain	6	49	1957	2	strain
swain	8	49	1905	2	swain
ta	2	116	6245	2	ta__
tab	5	74	6032	2	ta_b
tabid	8	44	1826	2	tabid
tabs	6	68	4298	2	tabs
tabu	6	63	2849	2	tabu
tabun	7	59	1437	2	tabun
tace	6	53	4251	2	tace
tach	9	61	3275	2	tach
tacit	7	63	3367	2	tacit
tack	10	65	3629	2	tack
taco	6	70	3135	2	taco
tact	6	73	4903	2	tact
tad	4	79	5982	2	ta_d
tads	5	71	4394	2	tads
tae	3	82	6705	2	ta_e
tael	4	60	3071	2	tael
tafia	8	42	1549	2	tafia
tag	4	72	5949	2	ta_g
tags	5	55	4523	2	tags
tahini	9	3	989	2	tahini
tahr	7	52	1715	2	tahr
taiga	6	41	1566	2	taiga
tails	5	56	3419	2	tails
taints	6	45	2053	2	taints
taipan	8	24	1066	2	taipan
taj	10	64	4219	2	ta_j
taka	8	76	2359	2	taka
take	8	47	3926	2	take
taken	9	48	1914	2	taken
taking	11	47	2595	2	taking
takins	10	51	1740	2	takins
tala	4	59	3805	2	tala
talc	6	62	2681	2	talc
tale	4	61	5416	2	tale
tali	4	68	3716	2	tali
talion	6	3	1771	2	talion
talk	8	62	3009	2	talk
tall	4	72	4021	2	tall
talon	5	58	2411	2	talon
tam	5	86	6342	2	ta_m
tame	6	63	4366	2	tame
tamein	8	3	1309	2	tamein
taming	9	40	2343	2	taming
tamis	7	67	2873	2	tamis
tamp	8	61	3300	2	tamp
tams	6	72	4793	2	tams
tang	5	61	3867	2	tang
tank	8	51	3402	2	tank
tannin	6	26	1392	2	tannin
tans	4	61	5482	2	tans
tao	3	83	5895	2	ta_o
taos	4	55	4100	2	taos
tap	5	76	6387	2	ta_p
tapa	6	51	2914	2	tapa
tape	6	45	3814	2	tape
taping	9	42	2239	2	taping
tapir	7	59	1706	2	tapir
tapis	7	50	2886	2	tapis
taps	6	60	5067	2	taps
tar	3	75	7069	2	ta_r
tare	4	59	5762	2	tare
taring	7	39	3228	2	taring
tarns	5	64	3395	2	tarns
taro	4	68	4691	2	taro
tarp	6	69	3641	2	tarp
tars	4	67	6395	2	tars
tart	4	75	6618	2	tart
tas	3	84	7710	2	ta_s
task	8	53	2665	2	task
tass	4	56	4057	2	tass
tat	3	76	9029	2	ta_t
tate	4	47	4860	2	tate
tats	4	68	5813	2	tats
tau	3	68	5690	2	ta_u
taunt	5	55	3228	2	taunt
tauon	5	48	1658	2	tauon
taus	4	63	4273	2	taus
taut	4	70	4896	2	taut
tav	6	60	4321	2	ta_v
tavs	7	56	3097	2	tavs
taw	6	101	5545	2	ta_w
tawie	8	48	1981	2	tawie
tawing	10	45	2155	2	tawing
tawny	11	47	1365	2	tawny
taws	7	56	4159	2	taws
tax	10	94	4915	2	ta_x
taxa	11	68	2009	2	taxa
taxi	11	71	2476	2	taxi
taxing	14	38	1671	2	taxing
taxis	12	68	2197	2	taxis
taxon	12	44	1466	2	taxon
teen	4	59	3820	2	teen
teind	6	2	1361	2	teind
ten	3	58	5611	2	t_en
tern	4	61	3480	2	tern
than	7	61	2877	2	than
thein	8	59	1902	2	thein
then	7	84	2969	2	then
thine	8	50	2686	2	thine
thing	9	66	2298	2	thing
think	12	50	1880	2	think
thins	8	58	2633	2	thins
thio	7	72	2541	2	thio
thir	7	64	2054	2	thir
this	7	60	2738	2	this
ti	2	84	4829	2	t_i_
tic	5	63	4346	2	t_ic
tie	3	65	5753	2	t_ie
til	3	63	5026	2	t_il
tine	4	58	5513	2	t_ine
ting	5	61	3990	2	t_ing
tins	4	52	5130	2	t_ins
tint	4	67	5886	2	t_int
tiny	7	61	3463	2	t_iny
tip	5	65	5122	2	t_ip
tis	3	70	5664	2	t_is
tit	3	67	7105	2	t_it
toil	4	65	3628	2	toil
toit	4	63	5306	2	toit
ton	3	102	6510	2	t_on
toon	4	77	4063	2	toon
torn	4	60	4425	2	torn
town	7	69	2870	2	town
toxin	12	47	1671	2	toxin
traik	9	54	1820	2	traik
trail	5	51	2677	2	trail
trains	6	47	2534	2	trains
trait	5	69	4084	2	trait
trig	5	55	2816	2	trig
trim	6	53	2952	2	trim
trine	5	47	3460	2	trine
trio	4	52	3334	2	trio
trip	6	68	3039	2	trip
tui	3	70	3402	2	tui_
tuis	4	48	2964	2	tuis
tun	3	58	4519	2	t_un
turn	4	63	3038	2	turn
twains	9	58	1118	2	twains
twig	8	76	1577	2	twig
twine	8	58	2236	2	twine
twins	8	51	1898	2	twins
twiny	11	60	1281	2	twiny
twit	7	63	2906	2	twit
tying	9	60	1984	2	tying
tyiyn	11	63	533	2	tyiyn
vail	7	54	3255	2	vail
vair	7	56	2414	2	vair
van	6	62	4633	2	va_n
vein	7	56	2575	2	vein
waif	10	58	3675	2	waif
wail	7	52	3882	2	wail
wains	8	69	3087	2	wains
wair	7	58	3005	2	wair
wait	7	55	5369	2	wait
wan	6	67	6194	2	wa_n
warn	7	52	3932	2	warn
whin	10	52	2569	2	whin
win	6	64	5629	2	_win
yarn	7	52	3004	2	yarn
yawn	10	62	1909	2	yawn
yin	6	76	4873	2	_yin
zayin	17	45	1204	2	zayin
zein	13	56	2060	2	zein
zin	12	56	4377	2	_zin

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.076	2351197.4
2	DLD Change Limit	29872	355	1.453	20558.8
3	Display Results	355	355	0.093	3817.2
	(SQL Overall)	178691	355	1.622	110167.1