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

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

325 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
arf	6	74	5337	(None)
aff	9	55	3761	1	aff
ar	2	113	7938	1	ar_
arb	5	104	4842	1	arb
arc	5	102	5090	1	arc
are	3	78	7457	1	are
arfs	7	60	2996	1	arfs
ark	7	70	4496	1	ark
arm	5	84	4962	1	arm
ars	3	76	7093	1	ars
art	3	86	7914	1	art
barf	9	58	4441	1	barf
zarf	16	69	2912	1	zarf
aa	2	191	7995	2	a_a
aah	6	162	5296	2	aah
aal	3	90	5867	2	aal
aas	3	109	7539	2	aas
ab	4	106	7476	2	a_b
aba	5	128	5095	2	aba
abo	5	90	4596	2	abo
abri	6	55	2221	2	abri
abs	5	93	5607	2	abs
aby	8	102	3806	2	aby
ace	5	96	5683	2	ace
acre	6	73	3077	2	acre
act	5	95	5784	2	act
ad	3	119	7503	2	a_d
add	5	101	3236	2	add
ado	4	91	4687	2	ado
ads	4	97	5573	2	ads
adz	13	123	3286	2	adz
ae	2	125	9029	2	a_e
aero	4	54	3534	2	aero
aery	7	72	3168	2	aery
aft	6	68	4901	2	aft
ag	3	110	6746	2	a_g
aga	4	104	4723	2	aga
age	4	71	5433	2	age
ago	4	88	4552	2	ago
ags	4	75	5166	2	ags
ah	5	138	6879	2	a_h
aha	6	112	4664	2	aha
ahi	6	80	4023	2	ahi
ahs	6	86	4482	2	ahs
ai	2	112	8839	2	a_i
aid	4	92	6908	2	aid
ail	3	71	7104	2	ail
aim	5	78	5821	2	aim
ain	3	75	7909	2	ain
air	3	80	5839	2	air
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	ais
ait	3	80	9390	2	ait
al	2	106	7404	2	a_l
ala	3	124	6360	2	ala
alb	5	73	4265	2	alb
ale	3	65	7234	2	ale
alef	7	63	4069	2	alef
alfa	7	76	2427	2	alfa
alif	7	62	4214	2	alif
all	3	61	4823	2	all
alp	5	66	4113	2	alp
als	3	66	6302	2	als
alt	3	64	6796	2	alt
am	4	118	7556	2	a_m
ama	5	108	5330	2	ama
ami	5	66	4681	2	ami
amp	7	75	4102	2	amp
amu	5	82	3732	2	amu
an	2	118	7908	2	a_n
ana	3	95	5983	2	ana
and	4	72	4417	2	and
ane	3	78	6695	2	ane
ani	3	77	5118	2	ani
ant	3	72	7079	2	ant
any	6	84	4049	2	any
ape	5	72	5118	2	ape
apo	5	111	4212	2	apo
app	7	68	2760	2	app
apt	5	73	5254	2	apt
arak	8	69	2957	2	arak
arbs	6	68	3473	2	arbs
arch	9	86	2844	2	arch
arco	6	83	3154	2	arco
arcs	6	78	3478	2	arcs
area	4	58	4339	2	area
ares	4	58	7102	2	ares
aria	4	62	4542	2	aria
arid	5	76	4271	2	arid
aril	4	58	4302	2	aril
arks	8	59	3687	2	arks
arms	6	61	3749	2	arms
army	9	66	2418	2	army
arse	4	65	3927	2	arse
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
as	2	110	8307	2	a_s
ash	6	79	4460	2	ash
ask	7	71	3070	2	ask
asp	5	72	3534	2	asp
ass	3	78	4406	2	ass
at	2	123	9340	2	a_t
ate	3	70	5924	2	ate
att	3	54	5465	2	att
auk	7	62	3414	2	auk
aura	4	58	3625	2	aura
ava	6	101	3932	2	ava
ave	6	77	4870	2	ave
avo	6	89	3623	2	avo
aw	5	125	6340	2	a_w
awa	6	119	3967	2	awa
awe	6	77	4662	2	awe
awl	6	76	3530	2	awl
awn	6	80	3591	2	awn
awry	10	76	1968	2	awry
ax	9	110	5778	2	a_x
axe	10	82	3949	2	axe
ay	5	117	7389	2	a_y
aye	6	71	5176	2	aye
ays	6	70	5029	2	ays
azo	12	82	3339	2	azo
baff	12	46	3227	2	baff
bar	5	80	7055	2	bar_
barb	8	52	4006	2	barb
bard	7	56	4886	2	bard
bare	6	54	6052	2	bare
barfs	10	48	2600	2	barfs
bark	10	62	4215	2	bark
barm	8	67	3960	2	barm
barn	6	64	4464	2	barn
bars	6	65	6409	2	bars
bra	5	63	3946	2	bra
bro	5	62	3660	2	bro
brr	5	69	2192	2	brr
caff	12	56	3167	2	caff
calf	9	63	3956	2	calf
car	5	91	6556	2	car_
carb	8	51	4316	2	carb
card	7	102	4587	2	card
care	6	69	6837	2	care
cark	10	55	3927	2	cark
carl	6	51	4478	2	carl
carn	6	62	4543	2	carn
carp	8	51	3981	2	carp
carr	6	54	3470	2	carr
cars	6	73	6476	2	cars
cart	6	65	7034	2	cart
corf	9	59	4148	2	corf
cru	5	71	2956	2	cru
cry	8	97	2624	2	cry
curf	9	75	3878	2	curf
daff	11	52	2968	2	daff
darb	7	60	3353	2	darb
dare	5	58	4886	2	dare
dark	9	51	3321	2	dark
darn	5	64	3462	2	darn
dart	5	58	5787	2	dart
def	7	65	4672	2	def
dif	7	68	4690	2	dif
dry	7	65	2603	2	dry
dwarf	12	60	1524	2	dwarf
ear	3	68	6788	2	ear_
earl	4	58	3814	2	earl
earn	4	67	3755	2	earn
ears	4	63	5659	2	ears
ef	5	73	4536	2	_ef
eff	9	61	2862	2	eff
elf	6	61	3852	2	elf
er	2	83	4514	2	er_
era	3	57	4150	2	era
ere	3	63	5277	2	ere
erg	4	55	3107	2	erg
ern	3	57	3836	2	ern
err	3	56	2653	2	err
ers	3	60	4628	2	ers
far	6	77	6260	2	far_
fard	8	56	3906	2	fard
fare	7	63	5446	2	fare
farl	7	63	3855	2	farl
farm	9	59	3453	2	farm
faro	7	61	3692	2	faro
fart	7	68	6056	2	fart
fro	6	55	3064	2	fro
fry	9	62	2650	2	fry
gaff	11	48	2815	2	gaff
gar	4	72	5990	2	gar_
garb	7	53	3267	2	garb
gars	5	57	5074	2	gars
haaf	10	62	2773	2	haaf
half	10	62	3845	2	half
hard	8	54	4350	2	hard
hare	7	62	5573	2	hare
hark	11	52	3739	2	hark
harl	7	57	4000	2	harl
harm	9	56	3779	2	harm
harp	9	61	3429	2	harp
hart	7	68	6577	2	hart
if	5	72	3995	2	_if
iff	9	67	3039	2	iff
ire	3	69	4317	2	ire
irk	7	64	2636	2	irk
jar	10	76	4615	2	jar_
jarl	11	58	2813	2	jarl
jars	11	73	3835	2	jars
kaf	10	68	4551	2	kaf
kaif	11	69	3393	2	kaif
karn	8	61	2941	2	karn
kart	8	67	5080	2	kart
kef	10	56	3966	2	kef
kerf	11	58	2746	2	kerf
kif	10	59	4119	2	kif
lar	3	79	6753	2	lar_
lard	5	67	4200	2	lard
lari	4	58	3915	2	lari
lark	8	57	3386	2	lark
lars	4	69	5657	2	lars
mar	5	79	6595	2	mar_
mara	6	74	4457	2	mara
marc	8	70	3463	2	marc
mare	6	47	5933	2	mare
mark	10	51	3806	2	mark
marl	6	63	4162	2	marl
mars	6	62	6187	2	mars
mart	6	68	6598	2	mart
naff	10	51	2893	2	naff
naif	7	68	3902	2	naif
narc	6	71	2795	2	narc
nard	5	66	3445	2	nard
nark	8	52	3006	2	nark
nary	7	69	3122	2	nary
oaf	6	59	5288	2	oaf
oar	3	70	5795	2	oar_
oars	4	68	4603	2	oars
of	5	82	4777	2	_of
off	9	63	3163	2	off
or	2	73	5473	2	or_
ora	3	72	5083	2	ora
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
ore	3	66	6183	2	ore
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
par	5	74	6702	2	par_
para	6	52	4217	2	para
pard	7	64	4132	2	pard
pare	6	67	6084	2	pare
park	10	52	3749	2	park
parr	6	57	3115	2	parr
pars	6	75	6079	2	pars
part	6	59	6746	2	part
pro	5	58	3726	2	pro
prof	9	61	3466	2	prof
pry	8	57	2805	2	pry
rad	4	76	6200	2	rad
raff	10	49	3304	2	raff
raft	7	62	4591	2	raft
rag	4	57	6132	2	rag
rah	6	80	5240	2	rah
rai	3	76	5822	2	rai
raj	10	57	4022	2	raj
ram	5	68	6727	2	ram
ran	3	82	6662	2	ran
rap	5	62	6196	2	rap
rare	4	53	4843	2	rare
ras	3	75	7539	2	ras
rat	3	78	9274	2	rat
raw	6	72	5225	2	raw
rax	10	84	4572	2	rax
ray	6	63	6199	2	ray
re	2	61	5374	2	_re
ref	6	60	5329	2	ref
rif	6	59	5156	2	rif
sard	5	53	4424	2	sard
sari	4	54	4404	2	sari
sark	8	49	3897	2	sark
scarf	10	54	2714	2	scarf
serf	7	63	4011	2	serf
snarf	8	65	2542	2	snarf
sri	3	56	3400	2	sri
surf	7	60	3931	2	surf
swarf	11	53	2465	2	swarf
tar	3	75	7069	2	tar_
tare	4	59	5762	2	tare
tarn	4	68	4272	2	tarn
taro	4	68	4691	2	taro
tarp	6	69	3641	2	tarp
tars	4	67	6395	2	tars
tart	4	75	6618	2	tart
tref	7	70	3099	2	tref
try	6	65	2967	2	try
turf	7	53	3405	2	turf
urb	5	57	3111	2	urb
urd	4	64	2705	2	urd
urn	3	57	3147	2	urn
urp	5	64	2640	2	urp
var	6	61	4833	2	var_
vara	7	55	3088	2	vara
vars	7	57	4207	2	vars
vary	10	52	2606	2	vary
waff	13	42	2804	2	waff
waif	10	58	3675	2	waif
war	6	72	6242	2	war_
ward	8	65	4225	2	ward
ware	7	62	5472	2	ware
wark	11	57	3777	2	wark
warm	9	59	3567	2	warm
warn	7	52	3932	2	warn
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
wart	7	78	6608	2	wart
wary	10	67	4001	2	wary
wharf	14	3	1582	2	wharf
wry	9	65	2470	2	wry
yaff	13	53	2426	2	yaff
yar	6	72	5383	2	yar_
yard	8	56	3325	2	yard
yare	7	56	3694	2	yare
yarn	7	52	3004	2	yarn
zarfs	17	47	1362	2	zarfs

Search took 1 second 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	14084	0.250	714764.0
2	DLD Change Limit	14084	325	0.423	33295.5
3	Display Results	325	325	0.076	4276.3
	(SQL Overall)	178691	325	0.749	238572.8