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

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

343 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
rand	5	58	3957	(None)
and	4	72	4418	1	_and
band	7	67	4092	1	band
brand	8	51	2449	1	brand
grand	7	51	2269	1	grand
hand	8	68	3371	1	hand
land	5	63	3731	1	land
rad	4	76	6201	1	ra_d
raid	5	52	4308	1	raid
ran	3	82	6662	1	ran_
rands	6	59	3045	1	rands
randy	9	50	2208	1	randy
rang	5	69	3917	1	rang
rani	4	66	4011	1	rani
ranid	6	64	2933	1	ranid
rank	8	51	3553	1	rank
rant	4	58	6468	1	rant
rend	5	61	3657	1	rend
rind	5	65	3561	1	rind
rynd	8	64	1410	1	rynd
sand	5	53	3847	1	sand
wand	8	58	3388	1	wand
ad	3	119	7504	2	_a_d
add	5	101	3237	2	_add
aid	4	92	6909	2	_aid
aland	6	55	2641	2	aland
an	2	118	7908	2	_an_
ana	3	95	5983	2	_ana
ands	5	78	3362	2	_ands
ane	3	78	6695	2	_ane
ani	3	77	5118	2	_ani
ant	3	72	7079	2	_ant
any	6	84	4049	2	_any
arid	5	76	4272	2	arid
bad	6	77	6316	2	ba_d
bald	7	64	3290	2	bald
ban	5	83	6684	2	ban_
banda	8	52	2311	2	banda
bands	8	52	3343	2	bands
bandy	11	48	2419	2	bandy
bane	6	52	5043	2	bane
baned	8	54	3635	2	baned
bang	7	48	3701	2	bang
bani	6	53	3496	2	bani
bank	10	58	3575	2	bank
bans	6	65	5514	2	bans
bard	7	56	4886	2	bard
baud	7	49	2842	2	baud
bawd	10	55	2084	2	bawd
bend	7	64	3526	2	bend
bind	7	62	3452	2	bind
bland	8	53	2045	2	bland
bond	7	53	3436	2	bond
brad	7	52	3434	2	bra_d
braid	8	58	2226	2	braid
bran	6	57	4038	2	bran_
brands	9	51	1894	2	brands
brandy	12	47	1206	2	brandy
brank	11	52	2228	2	brank
brans	7	54	3743	2	brans
brant	7	47	4217	2	brant
bund	7	55	3066	2	bund
cad	6	74	5637	2	ca_d
caid	7	78	3754	2	caid
can	5	77	6014	2	can_
candy	11	51	1982	2	candy
cane	6	66	5312	2	cane
caned	8	58	3809	2	caned
canid	8	55	2634	2	canid
cans	6	50	5085	2	cans
cant	6	63	6203	2	cant
card	7	102	4587	2	card
crane	7	53	3160	2	crane
craned	9	61	2165	2	craned
crank	11	48	1961	2	crank
dad	5	84	5617	2	da_d
dan	4	68	5967	2	dan_
dandy	10	44	1670	2	dandy
dang	6	51	3155	2	dang
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
drank	10	48	1620	2	drank
eland	6	58	2039	2	eland
end	4	68	3436	2	_end
errand	7	5	879	2	errand
fad	7	74	5242	2	fa_d
fan	6	71	5886	2	fan_
fane	7	53	4357	2	fane
fang	8	54	3256	2	fang
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
fard	8	56	3906	2	fard
fend	8	48	3297	2	fend
find	8	75	3261	2	find
fond	8	63	3095	2	fond
franc	10	46	1541	2	franc
frank	12	44	1751	2	frank
fraud	9	3	986	2	fraud
frond	9	53	1634	2	frond
fund	8	56	2498	2	fund
gad	5	75	5666	2	ga_d
gaed	6	60	3151	2	gaed
gan	4	80	6013	2	gan_
gane	5	51	4530	2	gane
gang	6	60	3198	2	gang
gaud	6	70	2543	2	gaud
gland	7	52	1771	2	gland
grad	6	68	2986	2	gra_d
gran	5	63	3501	2	gran_
grana	6	57	2209	2	grana
grands	8	42	1824	2	grands
grans	6	48	3254	2	grans
grant	6	48	4002	2	grant
grind	7	59	1756	2	grind
had	7	76	5877	2	ha_d
haed	8	63	3858	2	haed
hands	9	53	2738	2	hands
handy	12	55	2087	2	handy
hang	8	55	3556	2	hang
hank	11	51	3414	2	hank
hant	7	54	6159	2	hant
hard	8	54	4350	2	hard
hind	8	55	2976	2	hind
jane	11	50	3148	2	jane
kana	8	59	2854	2	kana
kane	8	51	3398	2	kane
kind	9	61	2857	2	kind
lad	4	81	6571	2	la_d
laid	5	64	3915	2	laid
lands	6	54	2690	2	lands
lane	4	51	5333	2	lane
lang	5	66	3739	2	lang
lank	8	47	3445	2	lank
lard	5	67	4200	2	lard
laud	5	65	2772	2	laud
lend	5	62	3367	2	lend
mad	6	89	5872	2	ma_d
maid	7	55	3767	2	maid
man	5	74	6587	2	man_
mana	6	53	4196	2	mana
mane	6	50	5203	2	mane
maned	8	66	3410	2	maned
mano	6	65	3681	2	mano
mans	6	63	5455	2	mans
many	9	57	3186	2	many
maud	7	53	2540	2	maud
maund	8	55	1545	2	maund
mend	7	53	3403	2	mend
mind	7	54	3439	2	mind
nan	3	78	5488	2	nan_
nana	4	66	3290	2	nana
nans	4	61	3940	2	nans
nard	5	66	3445	2	nard
orad	5	60	3169	2	ora_d
orang	6	51	1994	2	orang
pad	6	80	5733	2	pa_d
paid	7	57	3749	2	paid
pan	5	84	6645	2	pan_
panda	8	50	2261	2	panda
pandy	11	50	2117	2	pandy
pane	6	49	5029	2	pane
paned	8	54	3718	2	paned
pang	7	53	3630	2	pang
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
pard	7	64	4132	2	pard
pend	7	59	3453	2	pend
pond	7	55	3049	2	pond
prang	8	48	2032	2	prang
prank	11	50	1945	2	prank
qaid	14	60	2385	2	qaid
rabid	8	45	2078	2	rabid
race	6	67	4626	2	race
raced	8	76	3531	2	raced
rack	10	62	3488	2	rack
racy	9	58	2568	2	racy
rads	5	60	4661	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
raged	7	48	2945	2	raged
ragg	6	56	2269	2	ragg
ragi	5	60	3228	2	ragi
rags	5	54	4837	2	rags
rah	6	80	5240	2	ra_h
rai	3	76	5822	2	ra_i
raia	4	66	3838	2	raia
raids	6	58	2752	2	raids
rail	4	61	4776	2	rail
rain	4	62	5173	2	rain
rained	7	50	2460	2	rained
rains	5	51	4023	2	rains
rainy	8	59	2108	2	rainy
rais	4	52	5262	2	rais
raj	10	57	4022	2	ra_j
raja	11	79	1868	2	raja
rake	8	48	4157	2	rake
raked	10	58	3142	2	raked
raki	8	71	2783	2	raki
raku	8	54	2377	2	raku
rale	4	50	5056	2	rale
ram	5	68	6727	2	ra_m
rami	6	60	3409	2	rami
ramp	8	59	3400	2	ramp
rams	6	59	5077	2	rams
rance	7	50	2851	2	rance
ranch	10	50	1979	2	ranch
rancid	9	5	1386	2	rancid
randan	7	3	1525	2	randan
random	9	25	1355	2	random
ranee	5	54	3810	2	ranee
range	6	47	2842	2	range
ranged	8	48	2432	2	ranged
rangy	9	53	2039	2	rangy
ranids	7	51	1870	2	ranids
ranis	5	52	3584	2	ranis
ranked	11	46	2074	2	ranked
ranks	9	52	2573	2	ranks
ranted	7	43	2470	2	ranted
rants	5	59	3534	2	rants
rap	5	62	6196	2	ra_p
rape	6	50	4163	2	rape
raped	8	53	3462	2	raped
rapid	8	64	2203	2	rapid
raps	6	62	4773	2	raps
rapt	6	72	4531	2	rapt
rare	4	53	4843	2	rare
rared	6	57	3832	2	rared
ras	3	75	7539	2	ra_s
rase	4	61	4998	2	rase
rased	6	50	3393	2	rased
rash	7	60	3993	2	rash
rasp	6	60	2916	2	rasp
rat	3	78	9274	2	ra_t
rate	4	54	5876	2	rate
rated	6	54	4138	2	rated
rath	7	60	3766	2	rath
rato	4	54	3697	2	rato
rats	4	62	6037	2	rats
rave	7	55	4209	2	rave
raved	9	49	3143	2	raved
raw	6	72	5225	2	ra_w
raws	7	52	3821	2	raws
rax	10	84	4572	2	ra_x
raxed	13	56	2266	2	raxed
ray	6	63	6199	2	ra_y
raya	7	52	2482	2	raya
rayed	9	51	2750	2	rayed
rays	7	76	4235	2	rays
raze	13	52	3543	2	raze
razed	15	50	2798	2	razed
razz	12	52	1942	2	razz
read	5	59	4253	2	read
readd	7	46	1713	2	readd
red	4	67	5581	2	r_ed
redd	6	63	2318	2	redd
reed	5	55	4962	2	reed
reland	7	59	2043	2	reland
remand	9	56	1896	2	remand
rends	6	51	2995	2	rends
rent	4	66	6124	2	rent
repand	9	53	1606	2	repand
riant	5	58	3315	2	riant
riband	9	23	962	2	riband
rid	4	67	5464	2	r_id
rin	3	66	6319	2	rin_
rinds	6	48	2615	2	rinds
rindy	9	57	1740	2	rindy
ring	5	65	4116	2	ring
rink	8	77	3700	2	rink
rins	4	61	5320	2	rins
road	5	63	3211	2	road
roan	4	72	3420	2	roan_
roans	5	49	2644	2	roans
roband	9	23	1072	2	roband
rod	4	79	5390	2	r_od
rondo	6	52	1837	2	rondo
rood	5	67	3300	2	rood
round	6	43	1843	2	round
ruana	5	3	1242	2	ruana
rudd	6	59	1748	2	rudd
rued	5	57	2979	2	rued
run	3	62	4499	2	run_
rune	4	52	3630	2	rune
rung	5	64	2998	2	rung
runs	4	64	3808	2	runs
runt	4	66	4799	2	runt
rynds	9	56	997	2	rynds
sad	4	74	5921	2	sa_d
said	5	57	4212	2	said
sands	6	52	2858	2	sands
sandy	9	42	2113	2	sandy
sane	4	59	5434	2	sane
saned	6	56	3627	2	saned
sang	5	54	4124	2	sang
sank	8	52	3683	2	sank
sans	4	51	5336	2	sans
sard	5	53	4424	2	sard
send	5	52	3729	2	send
stand	6	59	2328	2	stand
strand	7	45	1482	2	strand
tad	4	79	5983	2	ta_d
tan	3	71	6758	2	tan_
tang	5	61	3869	2	tang
tank	8	51	3403	2	tank
tans	4	61	5483	2	tans
tend	5	64	3377	2	tend
trad	5	56	3091	2	tra_d
trank	9	62	2242	2	trank
tranq	14	54	1689	2	tranq
trans	5	49	3304	2	trans
trend	6	48	1745	2	trend
van	6	62	4633	2	van_
vanda	9	45	1592	2	vanda
vane	7	55	3469	2	vane
vaned	9	46	2242	2	vaned
vang	8	49	2605	2	vang
vans	7	62	3674	2	vans
vend	8	66	2642	2	vend
viand	9	5	1107	2	viand
wad	7	70	5390	2	wa_d
wan	6	67	6194	2	wan_
wands	9	64	2548	2	wands
wane	7	63	4472	2	wane
waned	9	58	3178	2	waned
wank	11	56	3251	2	wank
wans	7	64	5227	2	wans
want	7	61	5617	2	want
wany	10	64	3236	2	wany
ward	8	65	4225	2	ward
wend	8	53	3045	2	wend
wind	8	55	3386	2	wind
wrang	9	47	1611	2	wrang
wynd	11	61	1446	2	wynd
yald	8	69	2061	2	yald
yang	8	56	2608	2	yang
yank	11	54	2367	2	yank
yard	8	56	3325	2	yard
yaud	8	70	2008	2	yaud
yond	8	61	2231	2	yond
zany	16	73	1699	2	zany

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.406	440125.6
2	DLD Change Limit	29872	343	1.346	22193.2
3	Display Results	343	343	0.076	4513.2
	(SQL Overall)	178691	343	1.828	97752.2