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

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

287 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
loin	4	68	3872	(None)
aloin	5	52	2742	1	aloin
coin	6	66	4535	1	coin
eloin	5	59	2320	1	eloin
foin	7	72	3156	1	foin
join	11	67	2483	1	join
lain	4	61	4628	1	lain
lin	3	79	6737	1	l_in
lion	4	63	3444	1	lion
loan	4	74	3645	1	loan
login	6	60	2500	1	login
loid	5	55	3149	1	loid
loins	5	67	2842	1	loins
loon	4	73	4479	1	loon
lorn	4	64	3525	1	lorn
lown	7	69	2929	1	lown
agin	5	61	3271	2	agin
ain	3	75	7909	2	_ain
akin	8	63	2803	2	akin
algin	6	57	1876	2	algin
aloins	6	50	2220	2	aloins
amin	6	60	4225	2	amin
ayin	7	63	3174	2	ayin
bin	5	66	5864	2	_bin
blain	7	54	2179	2	blain
blin	6	72	2817	2	blin
blown	10	57	1667	2	blown
boil	6	63	3518	2	boil
boing	8	47	2555	2	boing
boink	11	55	1633	2	boink
boon	6	71	4217	2	boon
born	6	73	3841	2	born
brin	6	70	3819	2	brin
cain	6	56	4391	2	cain
chin	9	69	3474	2	chin
cion	6	133	3091	2	cion
clon	6	62	3248	2	clo_n
clown	10	52	1473	2	clown
coif	9	63	3791	2	coif
coign	8	50	1391	2	coign
coil	6	64	3965	2	coil
coins	7	58	3455	2	coins
coir	6	63	2724	2	coir
colin	7	62	3169	2	colin
con	5	102	6802	2	co_n
coni	6	55	3480	2	coni
conin	7	62	3272	2	conin
conn	6	62	2913	2	conn
coon	6	72	4894	2	coon
corn	6	99	4581	2	corn
covin	10	56	2112	2	covin
din	4	64	5946	2	_din
djin	12	9	1163	2	djin
doing	7	49	2358	2	doing
doit	5	63	4785	2	doit
don	4	67	5765	2	do_n
down	8	64	2749	2	down
elain	5	53	2470	2	elain
elfin	8	43	1246	2	elfin
eloign	7	45	698	2	eloign
eloins	6	54	1938	2	eloins
eon	3	60	5208	2	eo_n
eosin	5	52	2092	2	eosin
fain	7	58	4056	2	fain
fin	6	64	5803	2	_fin
florin	9	3	1265	2	florin
flown	11	62	1399	2	flown
fohn	10	61	1655	2	fohn
foil	7	64	3391	2	foil
foins	8	55	2338	2	foins
fon	6	63	5227	2	fo_n
gain	5	60	4216	2	gain
gin	4	60	5575	2	_gin
globin	9	30	972	2	globin
going	7	52	1849	2	going
goon	5	72	3617	2	goon
gown	8	57	2407	2	gown
grin	5	57	3372	2	grin
groin	6	55	2108	2	groin
hin	6	75	5956	2	_hin
hon	6	77	5938	2	ho_n
horn	7	67	3561	2	horn
in	2	81	5086	2	__in
iodin	6	44	1935	2	iodin
ion	3	60	5102	2	io_n
jin	10	64	4393	2	_jin
john	14	55	1290	2	john
joins	12	58	1841	2	joins
joint	12	52	2772	2	joint
kain	8	53	3429	2	kain
kin	7	63	5397	2	_kin
koan	8	54	2503	2	koan
koi	7	75	3475	2	koi_
koine	9	5	1648	2	koine
kois	8	51	2940	2	kois
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
lean	4	63	4524	2	lean
lei	3	68	4638	2	lei_
leis	4	57	3960	2	leis
levin	8	48	1641	2	levin
li	2	99	4875	2	l_i_
lib	5	77	5027	2	l_ib
lid	4	74	5352	2	l_id
lie	3	82	6452	2	l_ie
lien	4	53	3980	2	lien
limn	6	65	2769	2	limn
line	4	69	6557	2	l_ine
ling	5	74	4796	2	l_ing
linin	5	80	2552	2	linin
link	8	69	4344	2	l_ink
linn	4	60	3459	2	linn
lino	4	63	4337	2	l_ino
lins	4	70	5905	2	l_ins
lint	4	162	6623	2	l_int
liny	7	81	4132	2	l_iny
lions	5	59	2321	2	lions
lip	5	147	5580	2	l_ip
lipin	7	55	1889	2	lipin
lis	3	71	6227	2	l_is
lit	3	93	7731	2	l_it
lo	2	80	5344	2	lo__
load	5	67	3060	2	load
loaf	7	67	3490	2	loaf
loam	6	56	3048	2	loam
loans	5	60	2646	2	loans
lob	5	71	5446	2	lo_b
lobe	6	55	3536	2	lobe
lobo	6	72	2986	2	lobo
lobs	6	64	4108	2	lobs
loca	6	55	2768	2	loca
loch	9	55	2713	2	loch
loci	6	61	2628	2	loci
lock	10	61	3436	2	lock
loco	6	70	3074	2	loco
lode	5	62	4011	2	lode
loden	6	66	2114	2	loden
loft	7	65	3914	2	loft
log	4	62	5268	2	lo_g
logan	6	81	2328	2	logan
loge	5	68	3719	2	loge
logia	6	81	1660	2	logia
logic	8	82	1783	2	logic
logins	7	78	2064	2	logins
logion	7	60	1372	2	logion
logo	5	79	3176	2	logo
logon	6	159	2231	2	logon
logs	5	73	4311	2	logs
logy	8	70	2578	2	logy
loids	6	62	2070	2	loids
loll	4	61	2838	2	loll
lomein	8	4	1020	2	lomein
lone	4	58	4913	2	lone
long	5	69	3334	2	long
loo	3	83	5982	2	lo_o
loof	7	81	4105	2	loof
looie	5	56	2424	2	looie
looing	7	36	2104	2	looing
look	8	73	3347	2	look
loom	6	70	3505	2	loom
loons	5	57	3172	2	loons
loony	8	69	1896	2	loony
loop	6	78	3501	2	loop
loos	4	90	5112	2	loos
loot	4	69	5582	2	loot
lop	5	82	5531	2	lo_p
lope	6	59	4192	2	lope
loping	9	39	2141	2	loping
lops	6	60	4335	2	lops
loran	5	59	2509	2	loran
lord	5	50	3208	2	lord
lore	4	58	5035	2	lore
loris	5	53	2915	2	loris
lory	7	59	3171	2	lory
lose	4	51	4458	2	lose
losing	7	40	2287	2	losing
loss	4	53	3796	2	loss
lost	4	79	5149	2	lost
lot	3	81	7926	2	lo_t
lota	4	72	3350	2	lota
loth	7	61	3213	2	loth
loti	4	64	3184	2	loti
lotic	7	64	2067	2	lotic
lotion	6	57	1652	2	lotion
lots	4	76	5209	2	lots
loud	5	52	2804	2	loud
louie	5	50	2351	2	louie
louis	5	73	2232	2	louis
loup	6	60	2843	2	loup
lour	4	54	3068	2	lour
lout	4	59	5214	2	lout
love	7	52	3476	2	love
loving	10	44	1672	2	loving
low	6	60	5187	2	lo_w
lowe	7	54	3531	2	lowe
lowing	10	46	2327	2	lowing
lows	7	58	4301	2	lows
lox	10	82	4096	2	lo_x
loxing	14	36	1527	2	loxing
lupin	7	52	1584	2	lupin
lying	9	57	1745	2	lying
lysin	8	45	1278	2	lysin
main	6	53	4552	2	main
moan	6	58	3202	2	moan
moil	6	55	3409	2	moil
mon	5	75	6158	2	mo_n
moon	6	71	4081	2	moon
morn	6	62	3756	2	morn
mown	9	54	2444	2	mown
noil	4	61	3324	2	noil
noir	4	67	2243	2	noir
noon	4	71	3462	2	noon
noun	4	57	2418	2	noun
oi	2	90	6148	2	_oi_
oil	3	74	5205	2	_oil
oink	8	54	2934	2	_oink
olein	5	3	1600	2	olein
olio	4	68	2967	2	olio
on	2	80	5718	2	_o_n
own	6	64	2970	2	_own
pain	6	56	4724	2	pain
pein	6	58	3494	2	pein
pin	5	70	6672	2	_pin
pion	6	72	3529	2	pion
plain	7	48	2330	2	plain
poi	5	72	4466	2	poi_
poind	8	42	1791	2	poind
point	7	53	3873	2	point
pois	6	65	3904	2	pois
poon	6	73	4126	2	poon
porn	6	56	3602	2	porn
pyin	9	68	2323	2	pyin
quin	13	58	2392	2	quin
quoin	14	40	1232	2	quoin
rain	4	62	5173	2	rain
rein	4	60	4089	2	rein
rin	3	66	6318	2	_rin
roan	4	72	3420	2	roan
robin	7	48	2028	2	robin
roil	4	62	3529	2	roil
rosin	5	53	2531	2	rosin
ruin	4	74	3051	2	ruin
sain	4	55	5129	2	sain
shin	7	56	3431	2	shin
sin	3	62	6589	2	_sin
skin	8	59	2753	2	skin
slain	5	49	2357	2	slain
sloid	6	46	1971	2	sloid
soil	4	61	3883	2	soil
son	3	77	6195	2	so_n
soon	4	62	4050	2	soon
sorn	4	66	4106	2	sorn
sown	7	51	2745	2	sown
sozin	14	5	1454	2	sozin
spin	6	62	3130	2	spin
tain	4	55	4807	2	tain
thin	7	67	3239	2	thin
tin	3	63	6217	2	_tin
toil	4	65	3628	2	toil
toit	4	63	5306	2	toit
ton	3	102	6510	2	to_n
toon	4	77	4063	2	toon
torn	4	60	4425	2	torn
town	7	69	2870	2	town
toxin	12	47	1671	2	toxin
twin	7	60	2308	2	twin
tyin	7	64	2400	2	tyin
vain	7	52	3300	2	vain
vein	7	56	2575	2	vein
void	8	62	2056	2	void
wain	7	58	4020	2	wain
whin	10	52	2569	2	whin
win	6	64	5629	2	_win
won	6	62	5206	2	wo_n
worn	7	56	3175	2	worn
yin	6	76	4873	2	_yin
yogin	9	83	1774	2	yogin
yon	6	73	4895	2	yo_n
yoni	7	75	2439	2	yoni
zein	13	56	2060	2	zein
zin	12	56	4377	2	_zin
zoic	15	23	1607	2	zoic
zoon	13	73	2698	2	zoon

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.266	671770.7
2	DLD Change Limit	29872	287	0.936	31914.5
3	Display Results	287	287	0.076	3776.3
	(SQL Overall)	178691	287	1.278	139820.8