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

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

350 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
rains	5	51	4023	(None)
ains	4	61	5888	1	_ains
brains	8	51	2547	1	brains
cains	7	53	3430	1	cains
drains	7	37	1940	1	drains
gains	6	57	2951	1	gains
grains	7	42	2309	1	grains
kains	9	61	2564	1	kains
mains	7	56	3511	1	mains
pains	7	51	3828	1	pains
raias	5	46	3112	1	raias
raids	6	58	2751	1	raids
rails	5	59	3740	1	rails
rain	4	62	5173	1	rain_
rainy	8	59	2108	1	rainy
rais	4	52	5262	1	rai_s
ranis	5	52	3583	1	ranis
ravins	9	46	2256	1	ravins
rawins	9	56	1762	1	rawins
reins	5	62	3456	1	reins
rins	4	61	5319	1	r_ins
ruins	5	58	2203	1	ruins
sains	5	56	3997	1	sains
tains	5	49	3632	1	tains
trains	6	47	2534	1	trains
wains	8	69	3087	1	wains
aids	5	78	4636	2	_aids
ails	4	56	5471	2	_ails
aims	6	77	3818	2	_aims
ain	3	75	7909	2	_ain_
airns	5	55	2103	2	_airns
airs	4	64	4742	2	_airs
ais	3	90	8357	2	_ai_s
aits	4	63	5553	2	_aits
amins	7	55	3432	2	amins
anis	4	57	4646	2	_anis
arias	5	54	3802	2	arias
arils	5	87	3220	2	arils
awns	7	53	2443	2	_awns
ayins	8	53	2161	2	ayins
bails	7	59	3352	2	bails
bairns	8	67	1087	2	bairns
baits	7	66	3058	2	baits
banns	7	53	2123	2	banns
bans	6	65	5514	2	ba_ns
barns	7	63	3514	2	barns
basins	8	57	2276	2	basins
bins	6	65	4825	2	_bins
blains	8	45	1637	2	blains
braids	9	50	1569	2	braids
brails	8	46	2129	2	brails
brain	7	62	2938	2	brain_
brainy	11	48	1564	2	brainy
brans	7	54	3743	2	bra_ns
brawns	11	56	1408	2	brawns
brins	7	55	3397	2	brins
bruins	8	60	1495	2	bruins
cabins	10	44	1892	2	cabins
caids	8	52	2642	2	caids
cain	6	56	4391	2	cain_
cairns	8	53	1330	2	cairns
cans	6	50	5085	2	ca_ns
carns	7	59	3756	2	carns
chains	11	48	1970	2	chains
chins	10	56	3146	2	chins
coins	7	58	3455	2	coins
dais	5	70	4070	2	dai_s
damns	8	49	1692	2	damns
dans	5	67	4815	2	da_ns
darns	6	69	2789	2	darns
dawns	9	59	1659	2	dawns
dins	5	66	5204	2	_dins
djins	13	6	845	2	djins
drails	7	47	1695	2	drails
drain	6	52	2289	2	drain_
earns	5	59	2756	2	earns
elains	6	49	1985	2	elains
fagins	10	5	1386	2	fagins
fails	8	56	3148	2	fails
fain	7	58	4056	2	fain_
faint	8	58	3706	2	faint
faints	9	48	1878	2	faints
fairs	8	58	2544	2	fairs
fans	7	62	4737	2	fa_ns
fauns	8	45	1675	2	fauns
fawns	11	59	1426	2	fawns
fins	7	58	4909	2	_fins
foins	8	55	2338	2	foins
frails	9	37	1647	2	frails
gain	5	60	4216	2	gain_
gainst	7	49	1470	2	gainst
gaits	6	57	2601	2	gaits
gamins	9	44	2005	2	gamins
gins	5	55	4395	2	_gins
gradins	9	34	1623	2	gradins
grails	7	75	1878	2	grails
grain	6	51	2625	2	grain_
grainy	10	39	1421	2	grainy
grans	6	48	3254	2	gra_ns
gratins	8	41	1918	2	gratins
grins	6	54	2722	2	grins
groins	7	39	1720	2	groins
haiks	12	51	2093	2	haiks
hails	8	52	3164	2	hails
haint	8	54	3632	2	haint
haints	9	44	1758	2	haints
hairs	8	62	2517	2	hairs
hins	7	64	4799	2	_hins
ins	3	59	4560	2	__ins
jails	12	54	2294	2	jails
jins	11	56	3501	2	_jins
joins	12	58	1841	2	joins
kaifs	12	57	1564	2	kaifs
kails	9	55	2521	2	kails
kain	8	53	3429	2	kain_
kaons	9	50	1485	2	kaons
karns	9	66	2414	2	karns
kins	8	57	4791	2	_kins
kraits	10	49	1220	2	kraits
laics	7	64	1925	2	laics
lain	4	61	4628	2	lain_
lairs	5	54	2587	2	lairs
lapins	8	45	2068	2	lapins
lawns	8	52	1542	2	lawns
layins	9	38	1765	2	layins
lins	4	70	5905	2	_lins
loins	5	67	2842	2	loins
maids	8	63	2714	2	maids
mails	7	60	3778	2	mails
maims	9	63	2179	2	maims
main	6	53	4552	2	main_
mairs	7	62	2830	2	mairs
mans	6	63	5455	2	ma_ns
matins	8	45	2778	2	matins
mavins	11	51	1918	2	mavins
naans	5	58	1525	2	naans
naifs	8	76	1742	2	naifs
nails	5	57	3040	2	nails
nans	4	61	3940	2	na_ns
orcins	8	33	1343	2	orcins
ordains	8	7	965	2	ordains
orpins	8	36	1416	2	orpins
paiks	11	47	1985	2	paiks
pails	7	58	3306	2	pails
pain	6	56	4724	2	pain_
paint	7	54	4369	2	paint
paints	8	59	2183	2	paints
pairs	7	53	2583	2	pairs
pans	6	58	5573	2	pa_ns
patins	8	75	2878	2	patins
pavins	11	49	1966	2	pavins
pawns	10	88	1813	2	pawns
peins	7	61	2806	2	peins
pians	7	51	2696	2	pians
pins	6	55	5845	2	_pins
plains	8	50	1959	2	plains
prawns	11	50	902	2	prawns
pyins	10	58	1586	2	pyins
qaids	15	61	1631	2	qaids
quins	14	48	1985	2	quins
rabbins	11	28	1134	2	rabbins
rabies	8	52	2602	2	rabies
races	7	49	4324	2	races
racing	9	50	3053	2	racing
racings	10	50	1513	2	racings
racks	11	50	2885	2	racks
racons	8	43	1934	2	racons
radians	8	30	1382	2	radians
radios	7	40	1867	2	radios
radius	7	39	1487	2	radius
radons	7	41	1853	2	radons
rads	5	60	4660	2	ra_ds
raffs	11	50	1752	2	raffs
rafts	8	78	2063	2	rafts
ragas	6	53	2606	2	ragas
rages	6	45	3944	2	rages
raggs	7	52	1647	2	raggs
raging	8	51	2643	2	raging
ragis	6	63	2560	2	ragis
rags	5	54	4837	2	ra_gs
rai	3	76	5822	2	rai__
raia	4	66	3838	2	rai_a
raid	5	52	4307	2	rai_d
rail	4	61	4776	2	rai_l
rained	7	50	2460	2	rained
raise	5	48	2805	2	raise
raises	6	48	2654	2	raises
raisins	7	27	1534	2	raisins
raita	5	46	2307	2	raita
raitas	6	44	1767	2	raitas
rajas	12	73	1772	2	rajas
rajes	12	50	2278	2	rajes
rakes	9	44	4035	2	rakes
raking	11	47	2842	2	raking
rakis	9	53	2344	2	rakis
rakus	9	44	1367	2	rakus
rales	5	49	4749	2	rales
ramies	8	46	3046	2	ramies
ramps	9	62	2463	2	ramps
rams	6	59	5077	2	ra_ms
ramus	7	64	1828	2	ramus
ran	3	82	6662	2	ra_n_
rand	5	58	3957	2	ra_nd
rands	6	59	3045	2	rands
rang	5	69	3916	2	ra_ng
rani	4	66	4011	2	ra_ni
ranid	6	64	2933	2	ranid
ranids	7	51	1870	2	ranids
rank	8	51	3553	2	ra_nk
ranks	9	52	2573	2	ranks
rant	4	58	6468	2	ra_nt
rants	5	59	3534	2	rants
rapes	7	57	4072	2	rapes
rapids	9	49	1389	2	rapids
rapine	8	50	2308	2	rapine
rapines	9	51	2086	2	rapines
raping	9	48	2985	2	raping
rapini	8	47	1468	2	rapini
raps	6	62	4773	2	ra_ps
rares	5	52	4744	2	rares
raring	7	43	3287	2	raring
ras	3	75	7539	2	ra__s
rases	5	54	4721	2	rases
rasing	7	43	3083	2	rasing
rasps	7	43	1666	2	rasps
ratans	6	38	1937	2	ratans
rates	5	53	5201	2	rates
ratine	6	51	3182	2	ratine
ratines	7	53	2858	2	ratines
rating	7	49	3870	2	rating
ratings	8	42	1741	2	ratings
rations	7	41	2343	2	rations
ratios	6	49	2267	2	ratios
ratlins	7	36	1558	2	ratlins
ratos	5	55	2876	2	ratos
rats	4	62	6037	2	ra_ts
ravens	9	39	1688	2	ravens
raves	8	54	4197	2	raves
ravin	8	56	2465	2	ravin_
ravine	9	55	2222	2	ravine
ravines	10	42	2023	2	ravines
raving	10	51	2885	2	raving
ravings	11	46	1450	2	ravings
rawin	8	55	2147	2	rawin_
raws	7	52	3821	2	ra_ws
raxes	12	47	2939	2	raxes
raxing	14	43	2102	2	raxing
rayas	8	59	2205	2	rayas
raying	10	50	2719	2	raying
rayons	9	41	1334	2	rayons
rays	7	76	4235	2	ra_ys
razes	14	50	3270	2	razes
razing	16	45	2454	2	razing
reagins	8	42	1564	2	reagins
regains	8	43	1658	2	regains
reifs	8	48	1909	2	reifs
reigns	7	48	1175	2	reigns
rein	4	60	4089	2	rein_
reink	9	55	1809	2	reink
reinks	10	50	1215	2	reinks
reis	4	53	4323	2	rei_s
remains	9	41	1791	2	remains
renins	6	45	2645	2	renins
repins	8	49	2431	2	repins
resins	6	45	2877	2	resins
retains	7	45	2225	2	retains
rewins	9	50	2082	2	rewins
rhino	8	46	1432	2	rhino
rhinos	9	44	1112	2	rhinos
rials	5	50	2667	2	rials
riant	5	58	3315	2	riant
rias	4	55	4059	2	r_ias
ribs	6	58	3302	2	r_ibs
ricins	8	36	1870	2	ricins
rids	5	65	3955	2	r_ids
rifs	7	49	2900	2	r_ifs
rigs	5	51	3759	2	r_igs
rims	6	59	3630	2	r_ims
rin	3	66	6318	2	r_in_
rind	5	65	3560	2	r_ind
rinds	6	48	2614	2	r_inds
ring	5	65	4115	2	r_ing
rings	6	50	2917	2	r_ings
rink	8	77	3699	2	r_ink
rinks	9	48	2710	2	r_inks
rinse	5	48	2097	2	r_inse
rips	6	62	3743	2	r_ips
roans	5	49	2644	2	roans
robins	8	36	1745	2	robins
roils	5	48	2679	2	roils
rosins	6	45	2186	2	rosins
ruin	4	74	3051	2	ruin_
ruing	6	72	2105	2	ruing
runs	4	64	3808	2	r_uns
rutins	6	38	1839	2	rutins
sabins	8	55	2198	2	sabins
saids	6	53	2885	2	saids
sails	5	57	3810	2	sails
sain	4	55	5129	2	sain_
saint	5	51	4707	2	saint
saints	6	51	2242	2	saints
sans	4	51	5336	2	sa_ns
sarins	6	39	3262	2	sarins
sasins	6	49	2310	2	sasins
satins	6	49	3048	2	satins
savins	9	39	2313	2	savins
shins	8	51	3104	2	shins
sins	4	67	5527	2	_sins
skins	9	47	2346	2	skins
spins	7	53	2798	2	spins
sprains	9	30	1359	2	sprains
stains	6	49	2365	2	stains
strains	7	42	1815	2	strains
swains	9	45	1395	2	swains
tails	5	56	3419	2	tails
tain	4	55	4807	2	tain_
taint	5	55	4228	2	taint
taints	6	45	2053	2	taints
takins	10	51	1740	2	takins
tans	4	61	5482	2	ta_ns
tarns	5	64	3395	2	tarns
thins	8	58	2633	2	thins
tins	4	52	5130	2	_tins
traiks	10	40	1371	2	traiks
trails	6	46	2251	2	trails
train	5	65	2911	2	train_
traits	6	51	2198	2	traits
trans	5	49	3304	2	tra_ns
twains	9	58	1118	2	twains
twins	8	51	1898	2	twins
vails	8	58	2593	2	vails
vain	7	52	3300	2	vain_
vairs	8	50	1913	2	vairs
vans	7	62	3673	2	va_ns
veins	8	46	2049	2	veins
waifs	11	57	1987	2	waifs
wails	8	66	3148	2	wails
wain	7	58	4020	2	wain_
wairs	8	64	2406	2	wairs
waits	8	83	3352	2	waits
wans	7	64	5227	2	wa_ns
warns	8	72	3100	2	warns
whins	11	49	2233	2	whins
wins	7	59	4917	2	_wins
yarns	8	56	2179	2	yarns
yawns	11	42	1327	2	yawns
yins	7	53	3512	2	_yins
zayins	18	40	971	2	zayins
zeins	14	47	1539	2	zeins
zins	13	57	3500	2	_zins

Search took 3 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	53800	0.313	570897.8
2	DLD Change Limit	53800	350	2.030	26502.5
3	Display Results	350	350	0.110	3181.8
	(SQL Overall)	178691	350	2.453	72845.9