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

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

364 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
rain	4	62	5173	(None)
ain	3	75	7909	1	_ain
brain	7	62	2938	1	brain
cain	6	56	4391	1	cain
drain	6	52	2289	1	drain
fain	7	58	4056	1	fain
gain	5	60	4216	1	gain
grain	6	51	2625	1	grain
kain	8	53	3429	1	kain
lain	4	61	4628	1	lain
main	6	53	4552	1	main
pain	6	56	4724	1	pain
rai	3	76	5822	1	rai_
raia	4	66	3838	1	raia
raid	5	52	4307	1	raid
rail	4	61	4776	1	rail
rains	5	51	4023	1	rains
rainy	8	59	2108	1	rainy
rais	4	52	5262	1	rais
ran	3	82	6662	1	ra_n
rani	4	66	4011	1	rani
ravin	8	56	2465	1	ravin
rawin	8	55	2147	1	rawin
rein	4	60	4089	1	rein
rin	3	66	6318	1	r_in
ruin	4	74	3051	1	ruin
sain	4	55	5129	1	sain
tain	4	55	4807	1	tain
train	5	65	2911	1	train
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	6908	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
aria	4	62	4542	2	aria
arid	5	76	4271	2	arid
aril	4	58	4302	2	aril
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
braid	8	58	2226	2	braid
brail	7	55	2555	2	brail
brains	8	51	2547	2	brains
brainy	11	48	1564	2	brainy
bran	6	57	4038	2	bra_n
brawn	10	60	1856	2	brawn
brin	6	70	3819	2	brin
bruin	7	58	1833	2	bruin
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
din	4	64	5946	2	_din
djin	12	9	1163	2	djin
drail	6	50	2097	2	drail
drains	7	37	1940	2	drains
drawn	9	56	1424	2	drawn
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	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
frail	8	52	2021	2	frail
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
gradin	8	35	1748	2	gradin
grail	6	46	2287	2	grail
grains	7	42	2309	2	grains
grainy	10	39	1421	2	grainy
gran	5	63	3501	2	gra_n
gratin	7	45	2058	2	gratin
grin	5	57	3372	2	grin
groin	6	55	2108	2	groin
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	5397	2	_kin
krait	9	47	2677	2	krait
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
orcin	7	27	1657	2	orcin
ordain	7	8	1040	2	ordain
orpin	7	34	1553	2	orpin
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
prawn	10	53	1243	2	prawn
pyin	9	68	2323	2	pyin
qaid	14	60	2384	2	qaid
quin	13	58	2392	2	quin
rabbin	10	31	1230	2	rabbin
rabic	9	38	1740	2	rabic
rabid	8	45	2078	2	rabid
race	6	67	4626	2	race
racing	9	50	3053	2	racing
rack	10	62	3488	2	rack
racon	7	54	2214	2	racon
racy	9	58	2568	2	racy
rad	4	76	6200	2	ra_d
radian	7	41	1727	2	radian
radii	6	40	1641	2	radii
radio	6	49	2249	2	radio
radix	13	44	1460	2	radix
radon	6	46	2050	2	radon
rads	5	60	4660	2	rads
raff	10	49	3304	2	raff
raft	7	62	4591	2	raft
rag	4	57	6132	2	ra_g
raga	5	59	3081	2	raga
rage	5	57	4235	2	rage
ragg	6	56	2269	2	ragg
ragi	5	60	3228	2	ragi
raging	8	51	2643	2	raging
ragis	6	63	2560	2	ragis
rags	5	54	4837	2	rags
rah	6	80	5240	2	ra_h
raias	5	46	3112	2	raias
raids	6	58	2751	2	raids
rails	5	59	3740	2	rails
rained	7	50	2460	2	rained
raise	5	48	2805	2	raise
raisin	6	27	1692	2	raisin
raita	5	46	2307	2	raita
raj	10	57	4022	2	ra_j
raja	11	79	1868	2	raja
rake	8	48	4157	2	rake
raki	8	71	2783	2	raki
raking	11	47	2842	2	raking
rakis	9	53	2344	2	rakis
raku	8	54	2377	2	raku
rale	4	50	5056	2	rale
ram	5	68	6727	2	ra_m
ramen	7	56	2519	2	ramen
rami	6	60	3409	2	rami
ramie	7	50	2782	2	ramie
ramp	8	59	3400	2	ramp
rams	6	59	5077	2	rams
rand	5	58	3957	2	rand
rang	5	69	3916	2	rang
ranid	6	64	2933	2	ranid
ranis	5	52	3583	2	ranis
rank	8	51	3553	2	rank
rant	4	58	6468	2	rant
rap	5	62	6196	2	ra_p
rape	6	50	4163	2	rape
rapid	8	64	2203	2	rapid
rapine	8	50	2308	2	rapine
raping	9	48	2985	2	raping
rapini	8	47	1468	2	rapini
raps	6	62	4773	2	raps
rapt	6	72	4531	2	rapt
rare	4	53	4843	2	rare
raring	7	43	3287	2	raring
ras	3	75	7539	2	ra_s
rase	4	61	4998	2	rase
rash	7	60	3993	2	rash
rasing	7	43	3083	2	rasing
rasp	6	60	2916	2	rasp
rat	3	78	9274	2	ra_t
ratan	5	37	2266	2	ratan
rate	4	54	5876	2	rate
rath	7	60	3766	2	rath
ratine	6	51	3182	2	ratine
rating	7	49	3870	2	rating
ratio	5	52	2758	2	ratio
ration	6	42	2601	2	ration
ratlin	6	41	1652	2	ratlin
rato	4	54	3697	2	rato
rats	4	62	6037	2	rats
rave	7	55	4209	2	rave
raven	8	47	2344	2	raven
ravine	9	55	2222	2	ravine
raving	10	51	2885	2	raving
ravins	9	46	2256	2	ravins
raw	6	72	5225	2	ra_w
rawins	9	56	1762	2	rawins
raws	7	52	3821	2	raws
rax	10	84	4572	2	ra_x
raxing	14	43	2102	2	raxing
ray	6	63	6199	2	ra_y
raya	7	52	2482	2	raya
raying	10	50	2719	2	raying
rayon	8	38	1570	2	rayon
rays	7	76	4235	2	rays
raze	13	52	3543	2	raze
razing	16	45	2454	2	razing
razz	12	52	1942	2	razz
reagin	7	49	1553	2	reagin
regain	7	45	1776	2	regain
rei	3	56	4725	2	rei_
reif	7	69	3765	2	reif
reign	6	50	1519	2	reign
reink	9	55	1809	2	reink
reins	5	62	3456	2	reins
reis	4	53	4323	2	reis
remain	8	59	1986	2	remain
renin	5	48	3003	2	renin
repin	7	53	2470	2	repin
resin	5	41	3105	2	resin
retain	6	45	2328	2	retain
rewin	8	56	2396	2	rewin
rhino	8	46	1432	2	rhino
ria	3	67	4550	2	r_ia
rial	4	59	3809	2	rial
riant	5	58	3315	2	riant
rias	4	55	4059	2	rias
rib	5	68	4803	2	r_ib
ricin	7	46	2021	2	ricin
rid	4	67	5463	2	r_id
rif	6	59	5156	2	r_if
rig	4	67	4812	2	r_ig
rim	5	60	5227	2	r_im
rind	5	65	3560	2	r_ind
ring	5	65	4115	2	r_ing
rink	8	77	3699	2	r_ink
rins	4	61	5319	2	r_ins
rip	5	68	5130	2	r_ip
roan	4	72	3420	2	roan
robin	7	48	2028	2	robin
roil	4	62	3529	2	roil
rosin	5	53	2531	2	rosin
ruing	6	72	2105	2	ruing
ruins	5	58	2203	2	ruins
run	3	62	4499	2	r_un
rutin	5	54	2134	2	rutin
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
sprain	8	36	1486	2	sprain
stain	5	57	2794	2	stain
strain	6	49	1957	2	strain
swain	8	49	1905	2	swain
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	6757	2	ta_n
tarn	4	68	4272	2	tarn
thin	7	67	3239	2	thin
tin	3	63	6217	2	_tin
traik	9	54	1820	2	traik
trail	5	51	2677	2	trail
trains	6	47	2534	2	trains
trait	5	69	4084	2	trait
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	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.296	603685.8
2	DLD Change Limit	29872	364	0.970	30795.9
3	Display Results	364	364	0.093	3914.0
	(SQL Overall)	178691	364	1.359	131487.1