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

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

295 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
arid	5	76	4271	(None)
acid	7	75	3339	1	acid
acrid	8	69	2010	1	acrid
aid	4	92	6908	1	a_id
amid	7	70	3635	1	amid
aria	4	62	4542	1	aria
aril	4	58	4302	1	aril
aroid	6	54	2834	1	aroid
avid	8	83	2596	1	avid
grid	6	58	2961	1	grid
irid	5	59	2717	1	irid
raid	5	52	4307	1	raid
rid	4	67	5463	1	_rid
abed	7	97	3413	2	abed
abide	8	62	2371	2	abide
abri	6	55	2221	2	abri_
abris	7	57	2260	2	abris
acarid	9	50	1707	2	acarid
aced	7	95	4088	2	aced
acids	8	71	2100	2	acids
acidy	11	72	1489	2	acidy
acred	8	71	2635	2	acred
ad	3	119	7503	2	a__d
add	5	101	3236	2	a_dd
adit	5	64	4365	2	adit
aerie	5	46	3460	2	aerie
aeried	7	42	2186	2	aeried
afraid	10	4	972	2	afraid
afrit	8	3	2317	2	afrit
aged	6	73	3425	2	aged
agin	5	61	3271	2	agin
agio	5	78	2845	2	agio
agria	6	55	1714	2	agria
ahed	8	95	3625	2	ahed
ahi	6	80	4023	2	ahi_
ahis	7	61	3538	2	ahis
ai	2	112	8839	2	a_i_
aide	5	60	4500	2	a_ide
aids	5	78	4636	2	a_ids
ail	3	71	7104	2	a_il
aim	5	78	5821	2	a_im
ain	3	75	7909	2	a_in
air	3	80	5839	2	a_ir
aired	6	60	3292	2	aired
airn	4	64	3383	2	airn
airs	4	64	4742	2	airs
airt	4	57	5778	2	airt
airy	7	57	3415	2	airy
ais	3	90	8357	2	a_is
ait	3	80	9390	2	a_it
akin	8	63	2803	2	akin
alcid	8	58	1797	2	alcid
algid	7	54	1558	2	algid
alif	7	62	4214	2	alif
alit	4	61	5569	2	alit
ami	5	66	4681	2	ami_
amia	6	68	3690	2	amia
amide	8	61	2848	2	amide
amido	8	57	2098	2	amido
amids	8	56	2751	2	amids
amie	6	63	3985	2	amie
amin	6	60	4225	2	amin
amir	6	51	2975	2	amir
amis	6	64	4532	2	amis
and	4	72	4417	2	a_nd
ani	3	77	5118	2	ani_
anil	4	64	3743	2	anil
anis	4	57	4646	2	anis
aped	7	85	3815	2	aped
aphid	11	55	1539	2	aphid
apod	7	81	2318	2	apod
ar	2	113	7938	2	ar__
arak	8	69	2957	2	arak
aramid	9	33	1561	2	aramid
arb	5	104	4842	2	ar_b
arbs	6	68	3473	2	arbs
arc	5	102	5090	2	ar_c
arced	8	82	2416	2	arced
arch	9	86	2844	2	arch
arco	6	83	3154	2	arco
arcs	6	78	3478	2	arcs
are	3	78	7457	2	ar_e
area	4	58	4339	2	area
areic	7	32	1939	2	areic
ares	4	58	7102	2	ares
arf	6	74	5337	2	ar_f
arfs	7	60	2996	2	arfs
argil	6	51	1688	2	argil
arias	5	54	3802	2	arias
arider	7	47	1774	2	arider
aridly	10	55	1370	2	aridly
ariel	5	52	2897	2	ariel
ariled	7	56	2032	2	ariled
arils	5	87	3220	2	arils
arise	5	64	3643	2	arise
ark	7	70	4496	2	ar_k
arks	8	59	3687	2	arks
arm	5	84	4962	2	ar_m
armed	8	63	2443	2	armed
arms	6	61	3749	2	arms
army	9	66	2418	2	army
aroids	7	51	1822	2	aroids
arris	5	68	2468	2	arris
ars	3	76	7093	2	ar_s
arse	4	65	3927	2	arse
arsis	5	57	2242	2	arsis
art	3	86	7914	2	ar_t
arts	4	96	5026	2	arts
arty	7	75	3131	2	arty
arum	6	61	2903	2	arum
arvo	7	60	2343	2	arvo
aryl	7	59	2234	2	aryl
aside	6	51	2208	2	aside
atria	5	60	2234	2	atria
atrip	7	53	1575	2	atrip
auld	5	41	2536	2	auld
auric	7	45	2173	2	auric
auris	5	53	3153	2	auris
avoid	9	55	1668	2	avoid
awed	8	84	3603	2	awed
axed	12	88	2961	2	axed
axil	11	64	2445	2	axil
axis	11	61	2791	2	axis
ayin	7	63	3174	2	ayin
azide	15	56	1716	2	azide
azido	15	54	1154	2	azido
bard	7	56	4886	2	bar_d
bared	8	51	4448	2	bared
baric	9	61	2569	2	baric
bid	6	77	5181	2	_bid
bird	7	61	2832	2	bird
brad	7	52	3434	2	brad
braid	8	58	2226	2	braid
bred	7	51	3097	2	bred
bride	8	64	2553	2	bride
brie	6	58	3790	2	brie
brig	7	65	2803	2	brig
brim	8	56	2937	2	brim
brin	6	70	3819	2	brin
brio	6	54	3249	2	brio
bris	6	55	3961	2	bris
brit	6	63	5015	2	brit
caid	7	78	3753	2	caid
caird	8	57	1723	2	caird
canid	8	55	2634	2	canid
card	7	102	4587	2	car_d
cared	8	60	5009	2	cared
caried	9	45	2869	2	caried
chid	10	66	2640	2	chid
cred	7	65	3088	2	cred
crib	8	63	2358	2	crib
cried	8	46	2428	2	cried
cris	6	62	3343	2	cris
crit	6	57	4371	2	crit
crud	7	52	1961	2	crud
dared	7	59	3501	2	dared
daric	8	56	2311	2	daric
did	5	68	5052	2	_did
drib	7	68	2326	2	drib
dried	7	53	2138	2	dried
drip	7	62	2395	2	drip
droid	7	42	1854	2	droid
druid	7	41	1132	2	druid
eared	6	51	3950	2	eared
farad	9	57	2067	2	farad
fard	8	56	3906	2	far_d
fared	9	58	4234	2	fared
fid	7	68	4769	2	_fid
fried	9	53	2291	2	fried
frig	8	54	2450	2	frig
frit	7	70	4447	2	frit
friz	16	63	2434	2	friz
gadid	8	55	1738	2	gadid
gid	5	70	4727	2	_gid
gird	6	54	2499	2	gird
grad	6	68	2986	2	grad
gride	7	52	2358	2	gride
grids	7	53	2139	2	grids
grig	6	54	2477	2	grig
grim	7	69	2942	2	grim
grin	5	57	3372	2	grin
grind	7	59	1756	2	grind
grip	7	61	2702	2	grip
grit	5	52	4724	2	grit
guid	6	60	2282	2	guid
halid	9	44	2498	2	halid
hard	8	54	4350	2	har_d
hared	9	57	4218	2	hared
hid	7	62	4838	2	_hid
id	3	89	4184	2	__id
imid	7	61	2229	2	imid
ired	5	51	3187	2	ired
irids	6	64	1777	2	irids
iris	4	57	3255	2	iris
jerid	13	23	1642	2	jerid
kid	8	65	4062	2	_kid
kris	8	64	2360	2	kris
laid	5	64	3914	2	laid
laird	6	54	1779	2	laird
lard	5	67	4200	2	lar_d
lari	4	58	3915	2	lari_
laris	5	47	3746	2	laris
lid	4	74	5352	2	_lid
loid	5	55	3149	2	loid
lurid	6	46	1897	2	lurid
maid	7	55	3766	2	maid
maria	7	50	3288	2	maria
mid	6	73	5447	2	_mid
murid	8	45	2058	2	murid
nard	5	66	3445	2	nar_d
naric	7	68	2417	2	naric
naris	5	57	3529	2	naris
oared	6	50	3065	2	oared
orad	5	60	3169	2	orad
oxid	12	8	1548	2	oxid
paid	7	57	3748	2	paid
pard	7	64	4132	2	par_d
pardi	8	57	2395	2	pardi
pared	8	69	4676	2	pared
paris	7	51	4594	2	paris
pavid	11	57	1700	2	pavid
pride	8	47	2473	2	pride
pried	8	44	2686	2	pried
prig	7	59	2487	2	prig
prim	8	51	3220	2	prim
prod	7	61	2950	2	prod
qaid	14	60	2384	2	qaid
quid	14	49	2235	2	quid
rabid	8	45	2078	2	rabid
rad	4	76	6200	2	_rad
rai	3	76	5822	2	rai_
raia	4	66	3838	2	raia
raids	6	58	2751	2	raids
rail	4	61	4776	2	rail
rain	4	62	5173	2	rain
rais	4	52	5262	2	rais
rand	5	58	3957	2	rand
ranid	6	64	2933	2	ranid
rapid	8	64	2203	2	rapid
rared	6	57	3832	2	rared
red	4	67	5580	2	_red
ria	3	67	4550	2	_ria
rib	5	68	4803	2	_rib
ride	5	59	4513	2	_ride
rids	5	65	3955	2	_rids
rif	6	59	5156	2	_rif
rig	4	67	4812	2	_rig
rim	5	60	5227	2	_rim
rin	3	66	6318	2	_rin
rind	5	65	3560	2	_rind
rip	5	68	5130	2	_rip
rod	4	79	5389	2	_rod
said	5	57	4211	2	said
sapid	8	47	2093	2	sapid
sard	5	53	4424	2	sar_d
sari	4	54	4404	2	sari_
sarin	5	52	3925	2	sarin
saris	5	45	4495	2	saris
sarod	6	53	2587	2	sarod
sayid	9	55	1672	2	sayid
skid	9	57	2093	2	skid
slid	5	58	2898	2	slid
sparid	9	40	1693	2	sparid
sri	3	56	3400	2	sri_
sris	4	54	3415	2	sris
tabid	8	44	1826	2	tabid
tared	6	93	4005	2	tared
trad	5	56	3091	2	trad
triad	6	52	1772	2	triad
tried	6	50	2691	2	tried
trig	5	55	2816	2	trig
trim	6	53	2952	2	trim
trio	4	52	3334	2	trio
trip	6	68	3039	2	trip
trod	5	76	2795	2	trod
urd	4	64	2705	2	ur_d
uric	6	36	2494	2	uric
ursid	6	3	1148	2	ursid
valid	9	46	1839	2	valid
vapid	11	56	1428	2	vapid
varia	8	58	2420	2	varia
varied	10	48	1786	2	varied
varix	15	43	1351	2	varix
vid	7	72	4181	2	_vid
virid	9	41	1604	2	virid
void	8	62	2056	2	void
ward	8	65	4225	2	war_d
wared	9	63	3987	2	wared
whid	11	54	1887	2	whid
wried	9	55	1856	2	wried
writ	7	55	3791	2	writ
yaird	9	61	1191	2	yaird
yard	8	56	3325	2	yar_d
yid	7	66	4083	2	_yid
yird	8	70	1898	2	yird

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	295	0.826	36164.6
3	Display Results	295	295	0.063	4682.5
	(SQL Overall)	178691	295	1.155	154710.8