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

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

390 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
sain	4	55	5129	(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	4551	1	main
pain	6	56	4724	1	pain
rain	4	62	5173	1	rain
sabin	7	49	2495	1	sabin
said	5	57	4211	1	said
sail	4	54	4716	1	sail
sains	5	56	3997	1	sains
saint	5	51	4707	1	saint
sarin	5	52	3925	1	sarin
sasin	5	46	2657	1	sasin
satin	5	59	3521	1	satin
savin	8	46	2508	1	savin
sawn	7	54	2816	1	sawn
shin	7	56	3430	1	shin
sin	3	62	6589	1	s_in
skin	8	59	2752	1	skin
slain	5	49	2357	1	slain
spin	6	62	3130	1	spin
stain	5	57	2793	1	stain
swain	8	49	1905	1	swain
tain	4	55	4807	1	tain
vain	7	52	3300	1	vain
wain	7	58	4019	1	wain
again	6	52	1811	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	2289	2	amain
amin	6	60	4225	2	amin
an	2	118	7907	2	_a_n
ani	3	77	5117	2	_ani
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	6683	2	ba_n
bani	6	53	3495	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	6013	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	5966	2	da_n
darn	5	64	3462	2	darn
dawn	8	56	2420	2	dawn
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
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	5885	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
fusain	9	5	864	2	fusain
gaen	5	73	2960	2	gaen
gains	6	57	2951	2	gains
gait	5	61	5019	2	gait
gamin	8	44	2299	2	gamin
gan	4	80	6012	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
isatin	6	4	1221	2	isatin
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	3764	2	maid
mail	6	55	4344	2	mail
maim	8	58	3148	2	maim
mains	7	56	3510	2	mains
mair	6	61	3377	2	mair
man	5	74	6585	2	ma_n
matin	7	51	3285	2	matin
maun	6	57	2720	2	maun
mavin	10	57	2295	2	mavin
mawn	9	44	2413	2	mawn
naan	4	76	2193	2	naan
naif	7	68	3902	2	naif
nail	4	58	3865	2	nail
nan	3	78	5487	2	na_n
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	6644	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	6661	2	ra_n
rani	4	66	4010	2	rani
ravin	8	56	2465	2	ravin
rawin	8	55	2147	2	rawin
rein	4	60	4089	2	rein
rin	3	66	6318	2	_rin
ruin	4	74	3051	2	ruin
sab	5	65	6320	2	sa_b
sabe	6	61	4057	2	sabe
sabine	8	40	2039	2	sabine
sabins	8	55	2198	2	sabins
sabir	7	59	1700	2	sabir
sabs	6	66	4374	2	sabs
sac	5	74	5286	2	sa_c
sack	10	53	3731	2	sack
sacs	6	57	3907	2	sacs
sad	4	74	5920	2	sa_d
sade	5	55	4447	2	sade
sadi	5	58	3464	2	sadi
sadis	6	49	3085	2	sadis
sae	3	83	6518	2	sa_e
safe	7	59	3095	2	safe
sag	4	61	6340	2	sa_g
saga	5	53	3117	2	saga
sage	5	50	4459	2	sage
sago	5	63	3267	2	sago
sags	5	59	4840	2	sags
sagy	8	53	2708	2	sagy
sahib	10	3	1476	2	sahib
saice	7	54	2405	2	saice
saids	6	53	2885	2	saids
saiga	6	47	1793	2	saiga
sails	5	57	3810	2	sails
saimin	8	3	1366	2	saimin
sained	7	54	2424	2	sained
saints	6	51	2242	2	saints
saith	8	58	2655	2	saith
sake	8	52	4496	2	sake
saki	8	56	2847	2	saki
sakis	9	53	2366	2	sakis
sal	3	64	6288	2	sa_l
sale	4	49	5970	2	sale
salic	7	34	2471	2	salic
salina	6	42	2112	2	salina
saline	6	51	3270	2	saline
sall	4	45	4468	2	sall
salon	5	52	2855	2	salon
salp	6	45	3409	2	salp
sals	4	68	5167	2	sals
salt	4	57	5852	2	salt
same	6	52	4564	2	same
samp	8	57	3359	2	samp
sand	5	53	3846	2	sand
sane	4	59	5433	2	sane
sang	5	54	4122	2	sang
saning	7	51	2764	2	saning
sank	8	52	3682	2	sank
sans	4	51	5335	2	sans
sap	5	64	6323	2	sa_p
sapid	8	47	2093	2	sapid
saps	6	53	4637	2	saps
saran	5	37	3030	2	saran
sard	5	53	4424	2	sard
sari	4	54	4404	2	sari
sarins	6	39	3262	2	sarins
saris	5	45	4495	2	saris
sark	8	49	3897	2	sark
sash	7	72	3530	2	sash
sasins	6	49	2310	2	sasins
sass	4	50	3562	2	sass
sat	3	62	8848	2	sa_t
sate	4	55	5610	2	sate
sati	4	55	3932	2	sati
sating	7	47	3545	2	sating
satins	6	49	3048	2	satins
satiny	9	38	1798	2	satiny
satis	5	56	3367	2	satis
sau	3	63	5657	2	sa_u
saul	4	58	3652	2	saul
sauna	5	41	1755	2	sauna
save	7	57	4136	2	save
savine	9	42	2028	2	savine
saving	10	47	2451	2	saving
savins	9	39	2313	2	savins
saw	6	82	5535	2	sa_w
sawing	10	43	2381	2	sawing
saws	7	58	3948	2	saws
sax	10	74	4764	2	sa_x
say	6	72	6476	2	sa_y
sayid	9	55	1672	2	sayid
saying	10	43	2554	2	saying
says	7	59	4210	2	says
scan	6	55	3045	2	scan
scion	7	22	1499	2	scion
seen	4	69	4312	2	seen
sei	3	60	4893	2	sei_
seif	7	56	3873	2	seif
seine	5	57	3287	2	seine
seis	4	55	4239	2	seis
sen	3	60	5852	2	s_en
serin	5	54	3444	2	serin
sewn	7	61	2433	2	sewn
shairn	9	26	906	2	shairn
sharn	8	48	2370	2	sharn
shawn	11	64	1761	2	shawn
shim	9	58	2784	2	shim
shine	8	55	3309	2	shine
shins	8	51	3104	2	shins
shiny	11	51	2214	2	shiny
ship	9	52	2823	2	ship
shit	7	67	4593	2	shit
shiv	10	57	2116	2	shiv
shun	7	51	2277	2	shun
si	2	91	4957	2	s_i_
sial	4	59	3883	2	sial
sib	5	68	5031	2	s_ib
sic	5	58	4787	2	s_ic
sign	5	55	2305	2	sign
sim	5	65	5313	2	s_im
sine	4	65	6062	2	s_ine
sing	5	75	4417	2	s_ing
sinh	7	62	3804	2	s_inh
sink	8	66	4014	2	s_ink
sins	4	67	5527	2	s_ins
sip	5	76	5601	2	s_ip
sir	3	57	4667	2	s_ir
sis	3	73	6054	2	s_is
sit	3	58	7775	2	s_it
six	10	53	3974	2	s_ix
skein	9	48	1440	2	skein
ski	7	49	2568	2	ski_
skid	9	57	2091	2	skid
skim	10	53	2249	2	skim
skink	8	59	1685	2	skink
skins	9	47	2346	2	skins
skint	9	56	2922	2	skint
skip	10	54	2174	2	skip
skis	8	48	2528	2	skis
skit	8	54	3752	2	skit
slid	5	58	2898	2	slid
slim	6	66	3195	2	slim
sling	6	60	2880	2	sling
slink	9	54	2291	2	slink
slip	6	70	3173	2	slip
slit	4	62	5010	2	slit
smit	6	51	3841	2	smit
snail	5	70	2020	2	snail
snib	6	65	2298	2	snib
snip	6	64	2465	2	snip
snit	4	63	4247	2	snit
soil	4	61	3882	2	soil
son	3	77	6195	2	s_on
soon	4	62	4050	2	soon
sorn	4	66	4106	2	sorn
sown	7	51	2745	2	sown
sozin	14	5	1452	2	sozin
spail	7	49	2155	2	spail
spait	7	56	3160	2	spait
span	6	52	3466	2	span
spavin	11	42	1065	2	spavin
spawn	10	78	1171	2	spawn
spic	8	52	2743	2	spic
spik	10	54	1971	2	spik
spine	7	65	3442	2	spine
spins	7	53	2798	2	spins
spiny	10	49	2130	2	spiny
spit	6	55	4508	2	spit
spiv	9	59	1779	2	spiv
sprain	8	36	1486	2	sprain
spun	6	62	2146	2	spun
sri	3	56	3400	2	sri_
sris	4	54	3415	2	sris
staid	6	67	2207	2	staid
staig	6	55	1963	2	staig
stains	6	49	2365	2	stains
stair	5	47	1993	2	stair
statin	6	39	2146	2	statin
stein	5	46	2053	2	stein
sting	6	53	3024	2	sting
stink	9	51	2250	2	stink
stint	5	70	3766	2	stint
stir	4	57	2324	2	stir
strain	6	49	1957	2	strain
stun	4	56	2345	2	stun
suing	6	50	2636	2	suing
suint	5	56	3818	2	suint
suit	4	56	4987	2	suit
sun	3	71	4903	2	s_un
sunn	4	54	2359	2	sunn
swail	8	62	1716	2	swail
swains	9	45	1395	2	swains
swan	7	66	3131	2	swan
swig	8	58	1802	2	swig
swim	9	62	2139	2	swim
swine	8	56	2530	2	swine
swing	9	61	2484	2	swing
swink	12	51	1635	2	swink
syn	6	70	2412	2	s_yn
tail	4	54	4365	2	tail
tains	5	49	3632	2	tains
taint	5	55	4228	2	taint
takin	9	49	2130	2	takin
tan	3	71	6756	2	ta_n
tarn	4	68	4272	2	tarn
thin	7	67	3238	2	thin
tin	3	63	6217	2	_tin
train	5	65	2911	2	train
twain	8	63	1362	2	twain
twin	7	60	2308	2	twin
tyin	7	64	2400	2	tyin
vail	7	54	3255	2	vail
vair	7	56	2414	2	vair
van	6	62	4632	2	va_n
vein	7	56	2575	2	vein
waif	10	58	3675	2	waif
wail	7	52	3882	2	wail
wains	8	69	3086	2	wains
wair	7	58	3005	2	wair
wait	7	55	5369	2	wait
wan	6	67	6193	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	390	0.906	32971.3
3	Display Results	390	390	0.093	4193.5
	(SQL Overall)	178691	390	1.075	166224.2