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

Here are the results of your fuzzy-string dictionary search for “shin” 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
shin	7	56	3430	(None)
chin	9	69	3474	1	chin
hin	6	75	5956	1	_hin
sain	4	55	5129	1	sain
shim	9	58	2784	1	shim
shine	8	55	3309	1	shine
shins	8	51	3104	1	shins
shiny	11	51	2214	1	shiny
ship	9	52	2823	1	ship
shit	7	67	4593	1	shit
shiv	10	57	2116	1	shiv
shun	7	51	2277	1	shun
sin	3	62	6589	1	s_in
skin	8	59	2752	1	skin
spin	6	62	3130	1	spin
thin	7	67	3238	1	thin
whin	10	52	2569	1	whin
agin	5	61	3271	2	agin
ahi	6	80	4023	2	ahi_
ahing	9	89	2834	2	ahing
ahis	7	61	3538	2	ahis
ain	3	75	7909	2	_ain
akin	8	63	2803	2	akin
amin	6	60	4225	2	amin
arshin	9	3	1217	2	arshin
ashen	8	78	1867	2	ashen
ashing	10	78	2409	2	ashing
ayin	7	63	3174	2	ayin
bin	5	66	5864	2	_bin
blin	6	72	2817	2	blin
brin	6	70	3819	2	brin
cain	6	56	4391	2	cain
chain	10	57	2367	2	chain
chi	8	62	2865	2	chi_
chia	9	60	2662	2	chia
chic	11	59	2520	2	chic
chid	10	66	2640	2	chid
china	10	50	2247	2	china
chine	10	52	3172	2	chine
chink	14	53	2159	2	chink
chino	10	58	2331	2	chino
chins	10	56	3146	2	chins
chip	11	67	2642	2	chip
chis	9	59	3331	2	chis
chit	9	69	3746	2	chit
chon	9	66	2779	2	chon
coin	6	66	4535	2	coin
din	4	64	5946	2	_din
djin	12	9	1163	2	djin
fain	7	58	4056	2	fain
fin	6	64	5803	2	_fin
foin	7	72	3156	2	foin
gain	5	60	4216	2	gain
ghi	7	70	1988	2	ghi_
ghis	8	50	2016	2	ghis
gin	4	60	5575	2	_gin
grin	5	57	3372	2	grin
hen	6	75	5527	2	_hen
hi	5	79	4758	2	_hi_
hic	8	65	4056	2	_hic
hid	7	62	4836	2	_hid
hie	6	76	5270	2	_hie
him	8	62	4765	2	_him
hind	8	55	2975	2	_hind
hins	7	64	4799	2	_hins
hint	7	74	5574	2	_hint
hip	8	67	5043	2	_hip
his	6	63	5950	2	_his
hisn	7	96	2093	2	_hisn
hit	6	65	6919	2	_hit
hon	6	77	5938	2	_hon
hun	6	58	4471	2	_hun
in	2	81	5086	2	__in
jin	10	64	4393	2	_jin
join	11	67	2483	2	join
kain	8	53	3429	2	kain
khan	11	58	1914	2	khan
khi	10	63	1830	2	khi_
khis	11	70	1798	2	khis
kin	7	63	5396	2	_kin
lain	4	61	4628	2	lain
lin	3	79	6737	2	_lin
loin	4	68	3872	2	loin
main	6	53	4551	2	main
ohia	7	57	1936	2	ohia
ohing	9	60	1880	2	ohing
pain	6	56	4724	2	pain
pein	6	58	3494	2	pein
phi	8	65	2420	2	phi_
phis	9	57	2490	2	phis
phiz	18	67	1884	2	phiz
phon	9	59	2538	2	phon
pin	5	70	6672	2	_pin
pyin	9	68	2323	2	pyin
quin	13	58	2392	2	quin
rain	4	62	5173	2	rain
rein	4	60	4089	2	rein
rhino	8	46	1432	2	rhino
rin	3	66	6318	2	_rin
ruin	4	74	3051	2	ruin
sabin	7	49	2495	2	sabin
sahib	10	3	1476	2	sahib
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	3521	2	satin
savin	8	46	2508	2	savin
sawn	7	54	2816	2	sawn
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
sh	5	68	2852	2	sh__
sha	6	98	3778	2	sh_a
shad	8	62	3091	2	shad
shag	8	64	3056	2	shag
shah	10	56	2778	2	shah
shairn	9	26	906	2	shairn
sham	9	64	3635	2	sham
shank	12	54	2219	2	shank
sharn	8	48	2370	2	sharn
shat	7	64	5659	2	shat
shaw	10	81	3255	2	shaw
shawn	11	64	1761	2	shawn
shay	10	71	3334	2	shay
she	6	68	3769	2	sh_e
shea	7	60	3157	2	shea
shed	8	65	3615	2	shed
sheen	8	50	2331	2	sheen
sheik	12	25	1465	2	sheik
shend	9	47	1997	2	shend
shent	8	59	3349	2	shent
shes	7	57	3435	2	shes
shew	10	80	3076	2	shew
shewn	11	57	1570	2	shewn
shh	9	71	2107	2	sh_h
shied	9	61	2549	2	shied
shiel	8	110	2377	2	shiel
shier	8	54	2894	2	shier
shies	8	61	3655	2	shies
shift	11	42	2513	2	shift
shill	8	53	2533	2	shill
shily	11	52	2201	2	shily
shims	10	44	2254	2	shims
shindy	13	44	932	2	shindy
shined	10	46	2078	2	shined
shiner	9	38	2087	2	shiner
shines	9	50	2891	2	shines
shinny	12	48	1078	2	shinny
ships	10	51	2377	2	ships
shire	8	47	2713	2	shire
shirk	12	48	1784	2	shirk
shirr	8	47	1692	2	shirr
shirt	8	45	3389	2	shirt
shist	8	48	2960	2	shist
shits	8	47	3116	2	shits
shiva	11	59	1500	2	shiva
shive	11	44	2342	2	shive
shivs	11	50	1880	2	shivs
shmo	9	53	1809	2	shmo
shod	8	62	2505	2	shod
shoe	7	59	3343	2	shoe
shog	8	60	2513	2	shog
shone	8	37	2597	2	shone
shoo	7	59	2988	2	shoo
shoon	8	40	2200	2	shoon
shop	9	56	2983	2	shop
shorn	8	57	2217	2	shorn
shot	7	61	5024	2	shot
show	10	62	2918	2	show
shown	11	52	1647	2	shown
shri	7	60	2169	2	shri
shrine	9	49	2005	2	shrine
shrink	13	45	1173	2	shrink
shris	8	42	2144	2	shris
shtik	12	32	1094	2	shtik
shul	7	58	2315	2	shul
shuln	8	47	1311	2	shuln
shuns	8	50	1814	2	shuns
shunt	8	52	2650	2	shunt
shut	7	61	3758	2	shut
shwa	10	60	1496	2	shwa
shy	9	67	2819	2	sh_y
shying	13	42	1184	2	shying
si	2	91	4957	2	s_i_
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
slain	5	49	2357	2	slain
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
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
span	6	52	3466	2	span
sphinx	18	6	620	2	sphinx
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
spun	6	62	2146	2	spun
sri	3	56	3400	2	sri_
sris	4	54	3415	2	sris
stain	5	57	2793	2	stain
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
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
swain	8	49	1905	2	swain
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
tain	4	55	4807	2	tain
than	7	61	2877	2	than
thein	8	59	1902	2	thein
then	7	84	2969	2	then
thine	8	50	2685	2	thine
thing	9	66	2296	2	thing
think	12	50	1879	2	think
thins	8	58	2632	2	thins
thio	7	72	2541	2	thio
thir	7	64	2054	2	thir
this	7	60	2738	2	this
tin	3	63	6217	2	_tin
twin	7	60	2308	2	twin
tyin	7	64	2400	2	tyin
vain	7	52	3300	2	vain
vein	7	56	2575	2	vein
wain	7	58	4019	2	wain
when	10	57	2304	2	when
whid	11	54	1887	2	whid
whig	11	55	1642	2	whig
whim	12	62	2052	2	whim
whine	11	60	2281	2	whine
whins	11	49	2233	2	whins
whiny	14	49	1557	2	whiny
whip	12	55	2184	2	whip
whir	10	55	1928	2	whir
whit	10	48	3417	2	whit
whiz	19	59	1994	2	whiz
win	6	64	5629	2	_win
yin	6	76	4873	2	_yin
zein	13	56	2060	2	zein
zin	12	56	4377	2	_zin

Search took 4 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.216	827273.1
2	DLD Change Limit	29872	299	3.050	9794.1
3	Display Results	299	299	0.200	1495.0
	(SQL Overall)	178691	299	3.466	51555.4