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

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

375 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
soar	4	68	3867	(None)
boar	6	61	3429	1	boar
hoar	7	67	2916	1	hoar
oar	3	70	5795	1	_oar
osar	4	68	2095	1	osar
roar	4	63	2857	1	roar
scar	6	64	3420	1	scar
sear	4	73	5384	1	sear
soak	8	72	2766	1	soak
soap	6	58	3113	1	soap
soars	5	47	3251	1	soars
sofar	8	61	1549	1	sofar
solar	5	59	2734	1	solar
sonar	5	65	2342	1	sonar
sora	4	57	4691	1	sora
sour	4	59	3589	1	sour
sowar	8	58	2134	1	sowar
spar	6	54	3330	1	spar
star	4	80	3776	1	star
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
bar	5	80	7055	2	_bar
bear	6	68	4464	2	bear
boa	5	69	5403	2	boa_
board	8	55	2300	2	board
boars	7	52	2960	2	boars
boart	7	88	3593	2	boart
boas	6	61	5083	2	boas
boat	6	63	6031	2	boat
bolar	7	51	2347	2	bolar
boor	6	61	3068	2	boor
bora	6	61	4163	2	bora
boyar	10	60	1376	2	boyar
car	5	91	6556	2	_car
char	9	51	3215	2	char
coal	6	69	3925	2	coal
coat	6	75	5835	2	coat
coax	13	69	2298	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
escar	7	40	1199	2	escar
eskar	9	45	745	2	eskar
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	2555	2	hoars
hoary	11	45	1676	2	hoary
hoax	14	77	1829	2	hoax
hoer	7	65	3398	2	hoer
hora	7	61	3656	2	hora
hour	7	58	2731	2	hour
isobar	8	3	614	2	isobar
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	2506	2	maar
mar	5	79	6595	2	_mar
moa	5	72	4918	2	moa_
moan	6	58	3202	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
or	2	73	5473	2	_o_r
ora	3	72	5083	2	_ora
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
psoae	7	44	1162	2	psoae
psoai	7	46	992	2	psoai
psoas	7	50	1298	2	psoas
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	2224	2	roars
sab	5	65	6320	2	s_ab
sac	5	74	5286	2	s_ac
sad	4	74	5920	2	s_ad
sae	3	83	6518	2	s_ae
sag	4	61	6340	2	s_ag
sal	3	64	6288	2	s_al
sap	5	64	6323	2	s_ap
sard	5	53	4424	2	s_ard
sari	4	54	4404	2	s_ari
sark	8	49	3897	2	s_ark
sat	3	62	8848	2	s_at
sau	3	63	5657	2	s_au
saw	6	82	5535	2	s_aw
sax	10	74	4764	2	s_ax
say	6	72	6476	2	s_ay
scab	8	59	2671	2	scab
scad	7	57	2577	2	scad
scag	7	66	2689	2	scag
scam	8	59	3235	2	scam
scan	6	55	3045	2	scan
scare	7	53	3446	2	scare
scarf	10	54	2714	2	scarf
scarp	9	57	2410	2	scarp
scars	7	54	3353	2	scars
scart	7	61	3977	2	scart
scary	10	52	2259	2	scary
scat	6	58	4837	2	scat
scaur	7	58	1490	2	scaur
scour	7	53	1553	2	scour
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sears	5	47	4491	2	sears
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
seer	4	55	4704	2	seer
ser	3	67	5240	2	s_er
sera	4	61	4139	2	sera
sewar	8	54	2110	2	sewar
sha	6	98	3778	2	sha_
shad	8	62	3091	2	shad
shag	8	64	3056	2	shag
shah	10	56	2778	2	shah
sham	9	64	3636	2	sham
shard	9	61	2596	2	shard
share	8	64	3708	2	share
shark	12	62	2502	2	shark
sharn	8	48	2370	2	sharn
sharp	10	49	2253	2	sharp
shat	7	64	5660	2	shat
shaw	10	81	3255	2	shaw
shay	10	71	3334	2	shay
shear	8	54	2483	2	shear
shoal	8	39	2027	2	shoal
shoat	8	56	3395	2	shoat
shoer	8	47	2216	2	shoer
shofar	12	3	631	2	shofar
sial	4	59	3883	2	sial
simar	7	49	2081	2	simar
sir	3	57	4667	2	s_ir
sitar	5	48	2054	2	sitar
sizar	14	52	1499	2	sizar
ska	7	69	2586	2	ska_
skag	9	63	2151	2	skag
skas	8	53	2571	2	skas
skat	8	70	3790	2	skat
skoal	9	38	1146	2	skoal
slab	6	71	3376	2	slab
slag	5	59	3435	2	slag
slam	6	77	3797	2	slam
slap	6	64	3404	2	slap
slat	4	69	5902	2	slat
slaw	7	79	3071	2	slaw
slay	7	64	3638	2	slay
slur	4	55	2515	2	slur
smarm	9	55	1760	2	smarm
smart	7	58	3409	2	smart
smear	7	44	1639	2	smear
snag	5	58	2787	2	snag
snap	6	57	2703	2	snap
snare	5	44	2998	2	snare
snarf	8	65	2542	2	snarf
snark	9	54	1994	2	snark
snarl	5	49	2108	2	snarl
snaw	7	89	2307	2	snaw
so	2	88	5544	2	so__
soaker	10	57	1753	2	soaker
soaks	9	52	2029	2	soaks
soaper	8	45	1787	2	soaper
soaps	7	51	2071	2	soaps
soapy	10	61	1478	2	soapy
soared	7	43	2429	2	soared
soarer	6	45	2224	2	soarer
soave	8	42	1905	2	soave
sob	5	78	5794	2	so_b
soba	6	49	2792	2	soba
sobas	7	44	2425	2	sobas
sober	7	48	2241	2	sober
sobs	6	49	4175	2	sobs
soca	6	63	3005	2	soca
socas	7	40	2618	2	socas
sock	10	52	3321	2	sock
sod	4	60	5370	2	so_d
soda	5	63	2938	2	soda
sodas	6	41	2354	2	sodas
sods	5	49	4021	2	sods
sofa	7	56	2560	2	sofa
sofars	9	47	1278	2	sofars
sofas	8	53	2071	2	sofas
soft	7	69	4282	2	soft
soil	4	61	3883	2	soil
soja	11	56	1951	2	soja
sojas	12	47	1639	2	sojas
soke	8	54	3626	2	soke
sol	3	72	5662	2	so_l
sola	4	55	4186	2	sola
solan	5	53	2815	2	solan
sold	5	48	3741	2	sold
sole	4	60	5367	2	sole
soli	4	66	3701	2	soli
solo	4	55	3894	2	solo
sols	4	54	4816	2	sols
som	5	91	5381	2	so_m
soma	6	56	3529	2	soma
soman	7	50	2490	2	soman
somas	7	60	3037	2	somas
some	6	60	4038	2	some
soms	6	62	3937	2	soms
son	3	77	6195	2	so_n
sonars	6	48	1897	2	sonars
sone	4	66	4998	2	sone
song	5	51	3367	2	song
sons	4	60	4955	2	sons
sook	8	49	3339	2	sook
soon	4	62	4050	2	soon
soot	4	57	6106	2	soot
sop	5	75	5786	2	so_p
soph	9	70	2420	2	soph
sopor	7	40	1649	2	sopor
sops	6	52	4456	2	sops
soras	5	50	4101	2	soras
sorb	6	83	3304	2	sorb
sord	5	62	3720	2	sord
sore	4	70	5953	2	sore
sorer	5	62	3659	2	sorer
sori	4	60	3984	2	sori
sorn	4	66	4106	2	sorn
sorry	8	46	1825	2	sorry
sort	4	62	6481	2	sort
sos	3	77	6160	2	so_s
sot	3	103	8430	2	so_t
soth	7	59	3252	2	soth
sots	4	55	5245	2	sots
sou	3	78	5369	2	so_u
souari	6	3	1138	2	souari
soucar	8	3	932	2	soucar
souk	8	61	2717	2	souk
soul	4	64	3571	2	soul
soup	6	62	3291	2	soup
sours	5	52	3050	2	sours
sous	4	69	4721	2	sous
sow	6	65	5476	2	so_w
sowars	9	43	1801	2	sowars
sowcar	11	3	586	2	sowcar
sower	8	52	2931	2	sower
sown	7	51	2745	2	sown
sows	7	53	4249	2	sows
sox	10	64	4419	2	so_x
soy	6	78	5145	2	so_y
soya	7	57	2443	2	soya
soyas	8	45	2091	2	soyas
soys	7	52	3393	2	soys
spa	5	57	3081	2	spa_
spae	6	50	3432	2	spae
spam	8	59	3004	2	spam
span	6	52	3466	2	span
spare	7	51	3556	2	spare
spark	11	49	2089	2	spark
spars	7	54	3154	2	spars
spas	6	70	3672	2	spas
spat	6	65	4852	2	spat
spay	9	66	3166	2	spay
spaz	15	56	2616	2	spaz
spear	7	58	2106	2	spear
spoor	7	50	1635	2	spoor
spur	6	53	2119	2	spur
stab	6	73	2993	2	stab
stag	5	73	3200	2	stag
stair	5	47	1994	2	stair
stare	5	44	4026	2	stare
stark	9	54	2562	2	stark
stars	5	58	3657	2	stars
start	5	56	4231	2	start
stat	4	73	5269	2	stat
staw	7	86	2769	2	staw
stay	7	83	3372	2	stay
stir	4	57	2325	2	stir
stoa	4	54	2591	2	stoa_
stoae	5	50	2426	2	stoae
stoai	5	54	1787	2	stoai
stoas	5	51	2602	2	stoas
stoat	5	71	3595	2	stoat
stour	5	49	1674	2	stour
suer	4	53	3403	2	suer
sugar	6	3	1291	2	sugar
sura	4	57	4029	2	sura
swab	9	68	2531	2	swab
swag	8	75	2673	2	swag
swam	9	63	2998	2	swam
swan	7	66	3131	2	swan
swap	9	59	2543	2	swap
sward	9	42	2146	2	sward
sware	8	58	2821	2	sware
swarf	11	53	2465	2	swarf
swarm	10	62	1884	2	swarm
swart	8	62	3464	2	swart
swat	7	72	4444	2	swat
sway	10	71	2823	2	sway
swear	8	53	1685	2	swear
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	3038	2	tour
tsar	4	78	1980	2	tsar
tzar	13	63	1537	2	tzar
upsoar	8	10	568	2	upsoar
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.280	638182.1
2	DLD Change Limit	29872	375	0.910	32826.4
3	Display Results	375	375	0.090	4166.7
	(SQL Overall)	178691	375	1.280	139602.3