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

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

283 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
alar	4	63	4007	(None)
afar	7	67	2078	1	afar
agar	5	87	2641	1	agar
ajar	11	62	1770	1	ajar
ala	3	124	6360	1	ala_
alae	4	56	4375	1	alae
alan	4	68	4408	1	alan
alarm	7	66	2142	1	alarm
alary	8	61	2344	1	alary
alas	4	63	5812	1	alas
altar	5	55	2064	1	altar
lar	3	79	6753	1	_lar
malar	7	64	2444	1	malar
talar	5	62	2538	1	talar
aa	2	191	7995	2	a_a_
aah	6	162	5296	2	a_ah
aal	3	90	5867	2	a_al
aals	4	99	4114	2	aals
aas	3	109	7539	2	a_as
aba	5	128	5095	2	aba_
abas	6	86	4208	2	abas
abler	7	56	2431	2	abler
acari	7	50	2028	2	acari
afars	8	57	1651	2	afars
aga	4	104	4723	2	aga_
agars	6	61	2064	2	agars
agas	5	59	3884	2	agas
ager	5	59	3584	2	ager
aglare	7	3	1242	2	aglare
aha	6	112	4664	2	aha_
air	3	80	5839	2	a_ir
al	2	106	7404	2	al__
alack	11	48	2006	2	alack
alamo	7	4	1814	2	alamo
aland	6	55	2641	2	aland
alane	5	61	3561	2	alane
alang	6	60	2351	2	alang
alans	5	56	3617	2	alans
alant	5	57	4229	2	alant
alarms	8	59	1305	2	alarms
alarum	8	54	1198	2	alarum
alate	5	53	4032	2	alate
alb	5	73	4265	2	al_b
alba	6	83	2833	2	alba
albas	7	59	2539	2	albas
albs	6	86	2857	2	albs
alder	6	54	2191	2	alder
ale	3	65	7234	2	al_e
alec	6	64	3006	2	alec
alee	4	66	5232	2	alee
alef	7	63	4069	2	alef
alegar	7	3	928	2	alegar
alert	5	47	4065	2	alert
ales	4	70	6710	2	ales
alfa	7	76	2427	2	alfa
alfas	8	72	1904	2	alfas
alga	5	79	2760	2	alga
algae	6	53	1962	2	algae
algal	6	65	1821	2	algal
algas	6	56	2493	2	algas
algor	6	5	1305	2	algor
alias	5	58	3460	2	alias
alif	7	62	4213	2	alif
alit	4	61	5569	2	alit
alky	11	59	2034	2	alky
all	3	61	4823	2	al_l
allay	8	56	2039	2	allay
alls	4	67	4092	2	alls
ally	7	69	3564	2	ally
alma	6	63	3302	2	alma
almah	10	69	1725	2	almah
almas	7	66	2977	2	almas
alme	6	58	3216	2	alme
alms	6	58	3492	2	alms
aloe	4	55	4019	2	aloe
alow	7	53	2859	2	alow
alp	5	66	4113	2	al_p
alps	6	55	2924	2	alps
als	3	66	6302	2	al_s
also	4	64	2344	2	also
alt	3	64	6796	2	al_t
altars	6	45	1815	2	altars
alter	5	48	2850	2	alter
alto	4	78	3126	2	alto
alts	4	66	3990	2	alts
alular	6	3	1135	2	alular
alum	6	52	2761	2	alum
alway	11	61	1392	2	alway
ama	5	108	5330	2	ama_
amah	9	89	2748	2	amah
amas	6	77	4629	2	amas
amir	6	51	2974	2	amir
ana	3	95	5982	2	ana_
anal	4	80	3752	2	anal
anas	4	66	4986	2	anas
anear	5	54	2032	2	anear
anlas	5	56	2693	2	anlas
apart	7	43	3067	2	apart
aper	6	63	3623	2	aper
ar	2	113	7938	2	__ar
arak	8	69	2957	2	arak
ashlar	9	33	819	2	ashlar
atap	6	67	2245	2	atap
atlas	5	58	2158	2	atlas
attar	5	65	1669	2	attar
aura	4	58	3625	2	aura
aurar	5	44	2025	2	aurar
ava	6	101	3932	2	ava_
aver	7	59	3188	2	aver
awa	6	119	3967	2	awa_
award	9	71	1804	2	award
aware	8	64	2002	2	aware
away	10	80	2422	2	away
axal	11	65	2049	2	axal
ayah	10	80	2299	2	ayah
azan	13	65	2178	2	azan
balas	7	69	3721	2	balas
baler	7	56	3527	2	baler
bar	5	80	7055	2	_bar
bazar	16	38	1600	2	bazar
bear	6	68	4464	2	bear
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
blur	6	60	2053	2	blur
boar	6	61	3429	2	boar
bolar	7	51	2347	2	bolar
calcar	10	3	1275	2	calcar
car	5	91	6556	2	_car
char	9	51	3215	2	char
clad	7	62	2582	2	clad
clag	7	59	2457	2	clag
clam	8	63	3229	2	clam
clan	6	56	3392	2	clan
clap	8	64	2904	2	clap
claro	7	50	1869	2	claro
clary	10	57	1961	2	clary
claw	9	56	2434	2	claw
clay	9	59	2741	2	clay
clear	7	62	1905	2	clear
czar	15	60	1313	2	czar
damar	8	41	1773	2	damar
dear	5	53	4360	2	dear
ear	3	68	6788	2	_ear
elan	4	67	3424	2	elan
far	6	77	6260	2	_far
fear	7	53	3779	2	fear
fiar	7	64	2733	2	fiar
filar	8	48	1929	2	filar
flab	9	66	2835	2	flab
flag	8	74	2708	2	flag
flair	8	61	1412	2	flair
flak	11	60	2617	2	flak
flam	9	63	3329	2	flam
flan	7	61	3418	2	flan
flap	9	61	2870	2	flap
flare	8	48	2363	2	flare
flat	7	71	4782	2	flat
flaw	10	63	2664	2	flaw
flax	14	73	2563	2	flax
flay	10	63	3280	2	flay
flir	7	64	2220	2	flir
gala	5	56	3516	2	gala_
galah	9	59	1762	2	galah
galas	6	57	3164	2	galas
galax	13	53	1446	2	galax
gar	4	72	5990	2	_gar
gazar	15	46	1298	2	gazar
gear	5	59	3497	2	gear
glad	6	56	2401	2	glad
glair	6	53	1355	2	glair
glam	7	65	2934	2	glam
glare	6	52	2295	2	glare
glary	9	60	1854	2	glary
gnar	5	60	2138	2	gnar
guar	5	69	2329	2	guar
gular	6	3	1483	2	gular
haar	7	73	2349	2	haar
halal	8	56	2359	2	halal
haler	8	50	3352	2	haler
hear	7	61	4388	2	hear
hilar	8	54	1814	2	hilar
hoar	7	67	2916	2	hoar
izar	13	66	1601	2	izar
jalap	14	36	1247	2	jalap
jar	10	76	4615	2	_jar
kabar	11	48	1555	2	kabar
kalam	11	3	1511	2	kalam
kbar	10	65	1465	2	kbar
knar	8	58	1872	2	knar
kyar	11	69	1684	2	kyar
la	2	192	6163	2	_la_
laari	5	44	1571	2	laari
lab	5	88	6478	2	_lab
lac	5	101	5582	2	_lac
lad	4	81	6570	2	_lad
lag	4	78	6212	2	_lag
lahar	8	31	1426	2	lahar
lair	4	59	3415	2	lair
lam	5	76	6671	2	_lam
lap	5	85	6527	2	_lap
lard	5	67	4200	2	_lard
lari	4	58	3915	2	_lari
lark	8	57	3386	2	_lark
lars	4	69	5657	2	_lars
las	3	72	8147	2	_las
lat	3	75	9340	2	_lat
lav	6	68	4734	2	_lav
law	6	86	5664	2	_law
lax	10	76	5152	2	_lax
lay	6	88	6535	2	_lay
lazar	14	41	1364	2	lazar
lear	4	70	4595	2	lear
liar	4	72	2968	2	liar
maar	6	60	2505	2	maar
makar	11	56	1497	2	makar
malars	8	50	2068	2	malars
mar	5	79	6594	2	_mar
molar	7	52	2309	2	molar
mylar	10	53	1153	2	mylar
nala	4	69	3039	2	nala_
nalas	5	55	2836	2	nalas
navar	8	39	1273	2	navar
near	4	52	3650	2	near
oar	3	70	5795	2	_oar
osar	4	68	2095	2	osar
paler	7	54	3693	2	paler
palmar	10	41	1346	2	palmar
par	5	74	6702	2	_par
pear	6	97	4523	2	pear
pilar	7	52	2150	2	pilar
plan	6	58	3394	2	plan
plat	6	60	4887	2	plat
play	9	59	2898	2	play
polar	7	56	2345	2	polar
radar	6	13	1672	2	radar
rear	4	56	4455	2	rear
roar	4	63	2857	2	roar
salad	6	53	2183	2	salad
salal	5	54	2570	2	salal
salary	9	5	1521	2	salary
scalar	8	36	1243	2	scalar
scar	6	64	3420	2	scar
sear	4	73	5384	2	sear
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
soar	4	68	3867	2	soar
solar	5	59	2734	2	solar
spar	6	54	3330	2	spar
star	4	80	3776	2	star
tala	4	59	3805	2	tala_
talars	6	60	2168	2	talars
talas	5	59	3589	2	talas
taler	5	60	3486	2	taler
tar	3	75	7069	2	_tar
tatar	5	61	2206	2	tatar
tear	4	52	4288	2	tear
tolar	5	55	2411	2	tolar
tsar	4	78	1980	2	tsar
tzar	13	63	1537	2	tzar
ulan	4	65	2739	2	ulan
ulnar	5	60	1398	2	ulnar
valor	8	36	1489	2	valor
valvar	12	38	865	2	valvar
var	6	61	4833	2	_var
velar	8	58	1763	2	velar
volar	8	69	1741	2	volar
waler	8	42	2926	2	waler
war	6	72	6242	2	_war
wear	7	58	3672	2	wear
yar	6	72	5383	2	_yar
year	7	65	3425	2	year

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.126	1418182.5
2	DLD Change Limit	29872	283	1.093	27330.3
3	Display Results	283	283	0.063	4492.1
	(SQL Overall)	178691	283	1.282	139384.6