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

Here are the results of your fuzzy-string dictionary search for “boar” 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
boar	6	61	3429	(None)
bar	5	80	7055	1	b_ar
bear	6	68	4464	1	bear
boa	5	69	5403	1	boa_
board	8	55	2300	1	board
boars	7	52	2960	1	boars
boart	7	88	3593	1	boart
boas	6	61	5083	1	boas
boat	6	63	6031	1	boat
bolar	7	51	2347	1	bolar
boor	6	61	3068	1	boor
bora	6	61	4163	1	bora
boyar	10	60	1376	1	boyar
hoar	7	67	2916	1	hoar
oar	3	70	5795	1	_oar
roar	4	63	2857	1	roar
soar	4	68	3867	1	soar
aboard	9	3	1261	2	aboard
afar	7	67	2078	2	afar
agar	5	87	2641	2	agar
ajar	11	62	1770	2	ajar
alar	4	63	4007	2	alar
ar	2	113	7938	2	__ar
ba	4	99	6234	2	b_a_
baa	5	106	5042	2	b_aa
baal	6	70	3311	2	baal
baas	6	68	4467	2	baas
bad	6	77	6315	2	b_ad
bag	6	70	5922	2	b_ag
bah	8	77	5535	2	b_ah
bal	5	66	6272	2	b_al
bam	7	85	6014	2	b_am
ban	5	83	6683	2	b_an
bap	7	64	5584	2	b_ap
barb	8	52	4006	2	b_arb
bard	7	56	4886	2	b_ard
bare	6	54	6052	2	b_are
barf	9	58	4440	2	b_arf
bark	10	62	4215	2	b_ark
barm	8	67	3960	2	b_arm
barn	6	64	4464	2	b_arn
bars	6	65	6409	2	b_ars
bas	5	86	8175	2	b_as
bat	5	109	8895	2	b_at
bay	8	96	6164	2	b_ay
bazar	16	38	1600	2	bazar
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
beard	8	60	2496	2	beard
bears	7	57	3904	2	bears
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
beer	6	56	3599	2	beer
bezoar	17	3	691	2	bezoar
bias	6	47	3815	2	bias
bier	6	55	3182	2	bier
birr	6	60	2235	2	birr
blab	8	66	2913	2	blab
blae	6	61	3464	2	blae
blah	9	86	2506	2	blah
blam	8	61	3170	2	blam
blare	7	58	2623	2	blare
blat	6	65	5095	2	blat
blaw	9	70	2672	2	blaw
blear	7	59	1868	2	blear
bloat	7	52	2992	2	bloat
blur	6	60	2053	2	blur
bo	4	109	5757	2	bo__
boards	9	46	1693	2	boards
boarts	8	47	1687	2	boarts
boast	7	59	3570	2	boast
boater	8	46	2209	2	boater
boats	7	56	3515	2	boats
bob	7	67	5566	2	bo_b
bobs	8	63	4064	2	bobs
bock	12	60	3251	2	bock
bod	6	70	5554	2	bo_d
bode	7	58	3875	2	bode
bods	7	62	4471	2	bods
body	10	74	2567	2	body
boff	12	47	2732	2	boff
bog	6	78	5241	2	bo_g
bogan	8	75	1900	2	bogan
bogart	9	6	1719	2	bogart
bogs	7	57	4275	2	bogs
bogy	10	64	2619	2	bogy
boho	9	69	2332	2	boho
boil	6	63	3518	2	boil
bola	6	60	3556	2	bola
bolas	7	47	3376	2	bolas
bold	7	54	3281	2	bold
bole	6	64	4869	2	bole
boll	6	56	3475	2	boll
bolo	6	55	3595	2	bolo
bolt	6	62	5417	2	bolt
bomb	10	69	2742	2	bomb
bond	7	53	3436	2	bond
bone	6	59	4932	2	bone
boner	7	51	3308	2	boner
bong	7	56	3341	2	bong
bonk	10	55	3171	2	bonk
bony	9	67	3208	2	bony
boo	5	81	6366	2	bo_o
boob	8	59	3258	2	boob
book	10	68	3633	2	book
boom	8	74	3567	2	boom
boon	6	71	4217	2	boon
boors	7	43	2501	2	boors
boos	6	79	5503	2	boos
boot	6	77	5937	2	boot
bop	7	75	4948	2	bo_p
bops	8	60	3798	2	bops
boral	7	58	3170	2	boral
boras	7	59	3830	2	boras
borax	14	59	1872	2	borax
bore	6	60	5133	2	bore
borer	7	51	3127	2	borer
bork	10	69	3382	2	bork
born	6	73	3841	2	born
bort	6	59	6096	2	bort
bos	5	79	6681	2	bo_s
bosh	9	63	2897	2	bosh
bosk	10	58	2573	2	bosk
boss	6	59	3834	2	boss
bot	5	96	8040	2	bo_t
bota	6	62	3650	2	bota
botas	7	53	2878	2	botas
both	9	65	3343	2	both
bots	6	64	5395	2	bots
bott	6	65	4857	2	bott
bourg	8	41	1384	2	bourg
bourn	7	55	1848	2	bourn
bout	6	63	5329	2	bout
bow	8	70	5190	2	bo_w
bower	10	73	2818	2	bower
bowl	9	68	2770	2	bowl
bows	9	62	4286	2	bows
box	12	101	4234	2	bo_x
boxcar	17	3	475	2	boxcar
boxer	14	50	1652	2	boxer
boxy	16	64	2073	2	boxy
boy	8	77	5356	2	bo_y
boyard	12	54	1128	2	boyard
boyars	11	56	1198	2	boyars
boyo	9	69	2384	2	boyo
boys	9	67	3733	2	boys
bozo	15	68	2141	2	bozo
bra	5	63	3946	2	bra_
brad	7	52	3434	2	brad
brae	6	56	3911	2	brae
brag	7	52	2972	2	brag
bran	6	57	4038	2	bran
bras	6	57	4645	2	bras
brat	6	60	5554	2	brat
braw	9	48	2956	2	braw
bray	9	52	3290	2	bray
briar	7	57	1815	2	briar
broad	8	48	1769	2	broad
brr	5	69	2192	2	b_rr
brrr	6	53	1229	2	brrr
buhr	9	53	1538	2	buhr
bur	5	57	4469	2	b_ur
bura	6	61	3953	2	bura
burr	6	56	3123	2	burr
car	5	91	6556	2	_car
char	9	51	3215	2	char
coal	6	69	3925	2	coal
coat	6	75	5834	2	coat
coax	13	69	2297	2	coax
coir	6	63	2724	2	coir
cor	5	99	6094	2	co_r
czar	15	60	1313	2	czar
dear	5	53	4360	2	dear
doat	5	69	4767	2	doat
doer	5	77	3470	2	doer
door	5	69	2851	2	door
dor	4	72	5392	2	do_r
dorr	5	66	2772	2	dorr
dour	5	63	3043	2	dour
ear	3	68	6788	2	_ear
far	6	77	6260	2	_far
fear	7	53	3779	2	fear
fiar	7	64	2733	2	fiar
foal	7	66	3092	2	foal
foam	9	71	2717	2	foam
for	6	69	5207	2	fo_r
fora	7	59	3739	2	fora
four	7	62	2686	2	four
gar	4	72	5990	2	_gar
gear	5	59	3497	2	gear
gnar	5	60	2138	2	gnar
goa	4	73	4380	2	goa_
goad	6	68	3098	2	goad
goal	5	58	2930	2	goal
goas	5	52	3994	2	goas
goat	5	62	5083	2	goat
goer	5	68	2710	2	goer
gor	4	78	4826	2	go_r
guar	5	69	2329	2	guar
haar	7	73	2349	2	haar
hear	7	61	4388	2	hear
hoard	9	49	1831	2	hoard
hoars	8	59	2554	2	hoars
hoary	11	45	1676	2	hoary
hoax	14	77	1829	2	hoax
hoer	7	65	3398	2	hoer
hora	7	61	3655	2	hora
hour	7	58	2731	2	hour
izar	13	66	1601	2	izar
jar	10	76	4615	2	_jar
jowar	15	52	1143	2	jowar
kbar	10	65	1465	2	kbar
knar	8	58	1872	2	knar
koa	7	67	3777	2	koa_
koan	8	54	2503	2	koan
koas	8	56	3509	2	koas
kor	7	65	3889	2	ko_r
kora	8	64	3155	2	kora
kyar	11	69	1684	2	kyar
lar	3	79	6753	2	_lar
lear	4	70	4595	2	lear
liar	4	72	2968	2	liar
load	5	67	3060	2	load
loaf	7	67	3490	2	loaf
loam	6	56	3048	2	loam
loan	4	74	3645	2	loan
lobar	7	3	1301	2	lobar
lour	4	54	3068	2	lour
maar	6	60	2505	2	maar
mar	5	79	6594	2	_mar
moa	5	72	4918	2	moa_
moan	6	58	3201	2	moan
moas	6	55	4534	2	moas
moat	6	63	5203	2	moat
molar	7	52	2309	2	molar
moor	6	66	2855	2	moor
mor	5	68	5500	2	mo_r
mora	6	66	4127	2	mora
near	4	52	3650	2	near
noir	4	67	2243	2	noir
nor	3	80	4882	2	no_r
oaf	6	59	5288	2	_oaf
oak	7	62	3865	2	_oak
oars	4	68	4603	2	_oars
oat	3	98	8826	2	_oat
oba	5	75	3155	2	oba_
obas	6	57	3093	2	obas
or	2	73	5473	2	_o_r
ora	3	72	5083	2	_ora
osar	4	68	2095	2	osar
our	3	60	4289	2	_our
par	5	74	6702	2	_par
pear	6	97	4523	2	pear
polar	7	56	2345	2	polar
poor	6	56	3022	2	poor
pour	6	115	2747	2	pour
rear	4	56	4455	2	rear
road	5	63	3211	2	road
roam	6	71	3241	2	roam
roan	4	72	3420	2	roan
roars	5	56	2223	2	roars
scar	6	64	3420	2	scar
sear	4	73	5384	2	sear
soak	8	72	2766	2	soak
soap	6	58	3113	2	soap
soars	5	47	3251	2	soars
sofar	8	61	1549	2	sofar
solar	5	59	2734	2	solar
sonar	5	65	2342	2	sonar
sora	4	57	4691	2	sora
sour	4	59	3589	2	sour
sowar	8	58	2134	2	sowar
spar	6	54	3330	2	spar
star	4	80	3776	2	star
tar	3	75	7069	2	_tar
tear	4	52	4288	2	tear
toad	5	58	3018	2	toad
tolar	5	55	2411	2	tolar
tor	3	92	6168	2	to_r
tora	4	75	4599	2	tora
torr	4	56	3090	2	torr
tour	4	55	3037	2	tour
tsar	4	78	1980	2	tsar
tzar	13	63	1537	2	tzar
var	6	61	4833	2	_var
volar	8	69	1741	2	volar
war	6	72	6242	2	_war
wear	7	58	3672	2	wear
woad	8	55	2394	2	woad
yar	6	72	5383	2	_yar
year	7	65	3425	2	year
your	7	86	2343	2	your
zoa	12	85	2999	2	zoa_

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.076	2351197.4
2	DLD Change Limit	29872	295	0.860	34734.9
3	Display Results	295	295	0.063	4682.5
	(SQL Overall)	178691	295	0.999	178869.9