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

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

486 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
air	3	80	5839	(None)
ai	2	112	8839	1	ai_
aid	4	92	6907	1	aid
ail	3	71	7104	1	ail
aim	5	78	5821	1	aim
ain	3	75	7909	1	ain
airn	4	64	3383	1	airn
airs	4	64	4742	1	airs
airt	4	57	5778	1	airt
airy	7	57	3415	1	airy
ais	3	90	8357	1	ais
ait	3	80	9390	1	ait
amir	6	51	2974	1	amir
ar	2	113	7938	1	a_r
fair	7	63	3252	1	fair
fir	6	67	4489	1	fir
hair	7	63	3014	1	hair
kir	7	65	3567	1	kir
lair	4	59	3415	1	lair
mair	6	61	3376	1	mair
mir	5	70	4676	1	mir
pair	6	60	3151	1	pair
sir	3	57	4667	1	sir
vair	7	56	2414	1	vair
wair	7	58	3005	1	wair
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
acid	7	75	3339	2	acid
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
adit	5	64	4365	2	adit
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
afar	7	67	2078	2	afar
aff	9	55	3761	2	aff
afire	8	62	1591	2	afire
aft	6	68	4901	2	aft
ag	3	110	6746	2	a_g
aga	4	104	4723	2	aga
agar	5	87	2641	2	agar
age	4	71	5433	2	age
ager	5	59	3584	2	ager
agin	5	61	3271	2	agin
agio	5	78	2845	2	agio
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
ahis	7	61	3538	2	ahis
ahs	6	86	4482	2	ahs
aide	5	60	4499	2	aide
aider	6	54	3113	2	aider
aids	5	78	4635	2	aids
ails	4	56	5471	2	ails
aimer	7	59	2682	2	aimer
aims	6	77	3818	2	aims
ains	4	61	5888	2	ains
aired	6	60	3292	2	aired
airer	5	49	2789	2	airer
airns	5	55	2103	2	airns
airth	8	56	2102	2	airth
airts	5	56	2634	2	airts
aits	4	63	5553	2	aits
aiver	8	57	2516	2	aiver
ajar	11	62	1770	2	ajar
akin	8	63	2803	2	akin
al	2	106	7404	2	a_l
ala	3	124	6360	2	ala
alar	4	63	4007	2	alar
alb	5	73	4265	2	alb
ale	3	65	7234	2	ale
alif	7	62	4213	2	alif
alit	4	61	5569	2	alit
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	4680	2	ami
amia	6	68	3689	2	amia
amid	7	70	3633	2	amid
amie	6	63	3984	2	amie
amin	6	60	4224	2	amin
amirs	7	59	2491	2	amirs
amis	6	64	4531	2	amis
amp	7	75	4102	2	amp
amu	5	82	3732	2	amu
an	2	118	7907	2	a_n
ana	3	95	5982	2	ana
and	4	72	4416	2	and
ane	3	78	6694	2	ane
ani	3	77	5117	2	ani
anil	4	64	3743	2	anil
anis	4	57	4646	2	anis
ant	3	72	7078	2	ant
any	6	84	4048	2	any
ape	5	72	5118	2	ape
aper	6	63	3623	2	aper
apo	5	111	4212	2	apo
app	7	68	2760	2	app
apt	5	73	5254	2	apt
arb	5	104	4842	2	arb
arc	5	102	5090	2	arc
are	3	78	7457	2	are
arf	6	74	5337	2	arf
aria	4	62	4542	2	aria
arid	5	76	4271	2	arid
aril	4	58	4302	2	aril
ark	7	70	4496	2	ark
arm	5	84	4962	2	arm
ars	3	76	7093	2	ars
art	3	86	7914	2	art
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
astir	5	55	1709	2	astir
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
aver	7	59	3188	2	aver
avid	8	83	2596	2	avid
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
axil	11	64	2445	2	axil
axis	11	61	2791	2	axis
ay	5	117	7389	2	a_y
aye	6	71	5176	2	aye
ayin	7	63	3174	2	ayin
ays	6	70	5029	2	ays
azo	12	82	3339	2	azo
bail	6	50	4280	2	bail
bairn	7	75	1553	2	bairn
bait	6	65	5600	2	bait
bar	5	80	7055	2	bar
bi	4	80	4646	2	bi_
bib	7	70	4592	2	bib
bid	6	77	5178	2	bid
bier	6	55	3182	2	bier
big	6	73	4571	2	big
bin	5	66	5863	2	bin
bio	5	78	4607	2	bio
bird	7	61	2831	2	bird
birk	10	63	2685	2	birk
birl	6	58	3046	2	birl
biro	6	61	3120	2	biro
birr	6	60	2235	2	birr
bis	5	68	6065	2	bis
bit	5	70	7089	2	bit
biz	14	79	3935	2	biz
brr	5	69	2192	2	brr
bur	5	57	4469	2	bur
caid	7	78	3753	2	caid
cain	6	56	4391	2	cain
caird	8	57	1723	2	caird
cairn	7	57	1751	2	cairn
car	5	91	6556	2	car
carr	6	54	3470	2	carr
chair	10	55	1963	2	chair
cig	6	70	3618	2	cig
cire	6	58	3637	2	cire
cis	5	77	4803	2	cis
coir	6	63	2724	2	coir
cor	5	99	6094	2	cor
cur	5	68	4198	2	cur
dairy	9	70	1630	2	dairy
dais	5	70	4070	2	dais
deair	6	58	1719	2	deair
dib	6	57	4693	2	dib
did	5	68	5051	2	did
die	4	67	5965	2	die
dif	7	68	4689	2	dif
dig	5	75	4447	2	dig
dim	6	81	4649	2	dim
din	4	64	5946	2	din
dip	6	78	4898	2	dip
dire	5	66	4414	2	dire
dirk	9	63	2683	2	dirk
dirl	5	74	3002	2	dirl
dirt	5	55	5038	2	dirt
dis	4	64	5989	2	dis
dit	4	70	7133	2	dit
dor	4	72	5392	2	dor
ear	3	68	6788	2	ear
emir	6	59	1869	2	emir
er	2	83	4514	2	_er
err	3	56	2653	2	err
fail	7	48	4024	2	fail
fain	7	58	4056	2	fain
fairs	8	58	2544	2	fairs
fairy	11	53	1828	2	fairy
fakir	12	51	1149	2	fakir
faqir	17	54	864	2	faqir
far	6	77	6260	2	far
fer	6	66	4612	2	fer
fiar	7	64	2733	2	fiar
fib	8	63	4426	2	fib
fid	7	68	4768	2	fid
fie	6	71	5244	2	fie
fig	7	62	4283	2	fig
fil	6	54	4714	2	fil
fin	6	64	5803	2	fin
fire	7	62	4559	2	fire
firm	9	60	2645	2	firm
firn	7	69	2750	2	firn
firs	7	66	3771	2	firs
fit	6	63	6545	2	fit
fix	13	62	3610	2	fix
fiz	15	62	3876	2	fiz
flair	8	61	1412	2	flair
flir	7	64	2220	2	flir
for	6	69	5207	2	for
fur	6	66	3732	2	fur
gain	5	60	4216	2	gain
gait	5	61	5019	2	gait
gar	4	72	5990	2	gar
gaur	5	67	2335	2	gaur
gib	6	64	4352	2	gib
gid	5	70	4726	2	gid
gie	4	71	4954	2	gie
gig	5	60	4075	2	gig
gin	4	60	5575	2	gin
gip	6	76	4536	2	gip
gird	6	54	2499	2	gird
girl	5	62	2655	2	girl
girn	5	60	2686	2	girn
giro	5	58	2863	2	giro
girt	5	66	4642	2	girt
git	4	62	6605	2	git
glair	6	53	1355	2	glair
gor	4	78	4826	2	gor
haar	7	73	2349	2	haar
haik	11	55	2698	2	haik
hail	7	48	3906	2	hail
hairs	8	62	2517	2	hairs
hairy	11	53	1683	2	hairy
heir	7	75	2380	2	heir
her	6	65	4781	2	her
hi	5	79	4758	2	hi_
hic	8	65	4056	2	hic
hid	7	62	4836	2	hid
hie	6	76	5270	2	hie
him	8	62	4765	2	him
hin	6	75	5956	2	hin
hip	8	67	5043	2	hip
hire	7	55	3896	2	hire
his	6	63	5950	2	his
hit	6	65	6919	2	hit
id	3	89	4183	2	_id
if	5	72	3994	2	_if
in	2	81	5086	2	_in
ire	3	69	4317	2	_ire
irk	7	64	2636	2	_irk
is	2	70	4821	2	_is
it	2	84	5568	2	_it
jail	11	55	2909	2	jail
jar	10	76	4615	2	jar
jib	12	58	3596	2	jib
jig	11	56	3351	2	jig
jin	10	64	4393	2	jin
kafir	12	48	890	2	kafir
kaif	11	69	3392	2	kaif
kail	8	51	3149	2	kail
kain	8	53	3429	2	kain
keir	8	62	1787	2	keir
ki	6	75	3795	2	ki_
kid	8	65	4061	2	kid
kier	8	65	2680	2	kier
kif	10	59	4117	2	kif
kin	7	63	5396	2	kin
kip	9	70	4213	2	kip
kirk	7	62	2156	2	kirk
kirn	8	71	2343	2	kirn
kirs	8	58	3173	2	kirs
kis	7	80	5147	2	kis
kit	7	85	5987	2	kit
kor	7	65	3889	2	kor
laic	6	59	3156	2	laic
laid	5	64	3914	2	laid
lain	4	61	4628	2	lain
laird	6	54	1779	2	laird
lairs	5	54	2587	2	lairs
lar	3	79	6753	2	lar
lari	4	58	3915	2	lari
li	2	99	4875	2	li_
liar	4	72	2968	2	liar
lib	5	77	5026	2	lib
lid	4	74	5351	2	lid
lie	3	82	6452	2	lie
lier	4	59	4246	2	lier
lin	3	79	6737	2	lin
lip	5	147	5580	2	lip
lira	4	69	2868	2	lira
lire	4	78	4529	2	lire
liri	4	51	2825	2	liri
lis	3	71	6227	2	lis
lit	3	93	7731	2	lit
maar	6	60	2505	2	maar
maid	7	55	3763	2	maid
mail	6	55	4343	2	mail
maim	8	58	3147	2	maim
main	6	53	4550	2	main
mairs	7	62	2829	2	mairs
mar	5	79	6594	2	mar
mi	4	82	4904	2	mi_
mib	7	69	4610	2	mib
mic	7	76	4763	2	mic
mid	6	73	5445	2	mid
mig	6	56	4607	2	mig
mil	5	57	5210	2	mil
mim	7	60	4841	2	mim
mire	6	67	4822	2	mire
miri	6	67	3036	2	miri
mirk	10	67	2949	2	mirk
mirs	6	69	4056	2	mirs
miry	9	63	2674	2	miry
mis	5	81	6261	2	mis
mix	12	61	3817	2	mix
mor	5	68	5500	2	mor
nadir	6	10	1297	2	nadir
naif	7	68	3901	2	naif
nail	4	58	3865	2	nail
naira	5	3	1474	2	naira
nairu	5	4	1381	2	nairu
nib	5	67	4518	2	nib
nil	3	61	4419	2	nil
nim	5	71	4295	2	nim
nip	5	69	4598	2	nip
nit	3	70	6594	2	nit
nix	10	69	3283	2	nix
noir	4	67	2243	2	noir
nor	3	80	4882	2	nor
oar	3	70	5795	2	oar
oi	2	90	6148	2	oi_
oil	3	74	5205	2	oil
or	2	73	5473	2	_or
our	3	60	4289	2	our
paid	7	57	3748	2	paid
paik	10	57	2680	2	paik
pail	6	61	4183	2	pail
pain	6	56	4724	2	pain
pairs	7	53	2583	2	pairs
par	5	74	6702	2	par
parr	6	57	3115	2	parr
per	5	63	5309	2	per
pi	4	81	4536	2	pi_
pia	5	68	4803	2	pia
pic	7	60	4682	2	pic
pie	5	54	5740	2	pie
pier	6	60	3529	2	pier
pig	6	57	4497	2	pig
pin	5	70	6672	2	pin
pip	7	80	5104	2	pip
pirn	6	71	2837	2	pirn
pis	5	63	6203	2	pis
pit	5	64	7192	2	pit
piu	5	66	3954	2	piu
pix	12	64	3793	2	pix
pur	5	68	4055	2	pur
qaid	14	60	2384	2	qaid
qi	11	65	2690	2	qi_
qis	12	69	3438	2	qis
rai	3	76	5822	2	rai_
raia	4	66	3838	2	raia
raid	5	52	4307	2	raid
rail	4	61	4776	2	rail
rain	4	62	5173	2	rain
rais	4	52	5262	2	rais
ria	3	67	4550	2	ria
rib	5	68	4802	2	rib
rid	4	67	5462	2	rid
rif	6	59	5155	2	rif
rig	4	67	4812	2	rig
rim	5	60	5227	2	rim
rin	3	66	6318	2	rin
rip	5	68	5130	2	rip
sabir	7	59	1699	2	sabir
said	5	57	4211	2	said
sail	4	54	4716	2	sail
sain	4	55	5129	2	sain
sari	4	54	4404	2	sari
ser	3	67	5240	2	ser
si	2	91	4957	2	si_
sib	5	68	5030	2	sib
sic	5	58	4787	2	sic
sim	5	65	5313	2	sim
sin	3	62	6589	2	sin
sip	5	76	5601	2	sip
sire	4	61	5041	2	sire
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	sis
sit	3	58	7775	2	sit
six	10	53	3974	2	six
sri	3	56	3400	2	sri
stair	5	47	1993	2	stair
stir	4	57	2324	2	stir
tahr	7	52	1715	2	tahr
tail	4	54	4365	2	tail
tain	4	55	4807	2	tain
tapir	7	59	1706	2	tapir
tar	3	75	7069	2	tar
thir	7	64	2054	2	thir
ti	2	84	4829	2	ti_
tic	5	63	4346	2	tic
tie	3	65	5753	2	tie
tier	4	49	3614	2	tier
til	3	63	5026	2	til
tin	3	63	6217	2	tin
tip	5	65	5122	2	tip
tire	4	61	4335	2	tire
tirl	4	50	2992	2	tirl
tiro	4	68	3236	2	tiro
tis	3	70	5664	2	tis
tit	3	67	7104	2	tit
tor	3	92	6168	2	tor
vail	7	54	3255	2	vail
vain	7	52	3300	2	vain
vairs	8	50	1913	2	vairs
var	6	61	4833	2	var
via	6	56	3624	2	via
vid	7	72	4180	2	vid
vie	6	54	4763	2	vie
vier	7	54	2815	2	vier
vig	7	56	3752	2	vig
vim	8	74	3702	2	vim
virl	7	62	2447	2	virl
vis	6	67	4761	2	vis
waif	10	58	3674	2	waif
wail	7	52	3882	2	wail
wain	7	58	4019	2	wain
wairs	8	64	2406	2	wairs
wait	7	55	5369	2	wait
war	6	72	6242	2	war
waur	7	68	1990	2	waur
weir	7	60	1992	2	weir
whir	10	55	1928	2	whir
wig	7	67	4038	2	wig
win	6	64	5629	2	win
wire	7	58	3981	2	wire
wiry	10	64	2283	2	wiry
wis	6	65	5233	2	wis
wit	6	65	6377	2	wit
wiz	15	64	3415	2	wiz
xi	9	81	2816	2	xi_
xis	10	69	3533	2	xis
yaird	9	61	1191	2	yaird
yar	6	72	5383	2	yar
yid	7	66	4082	2	yid
yin	6	76	4873	2	yin
yip	8	72	4117	2	yip
yird	8	70	1898	2	yird
yirr	7	65	1357	2	yirr
zaire	14	3	1199	2	zaire
zig	13	69	3190	2	zig
zin	12	56	4377	2	zin
zip	14	66	3622	2	zip
zit	12	60	4999	2	zit

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.110	1624463.6
2	DLD Change Limit	14084	486	0.390	36112.8
3	Display Results	486	486	0.093	5225.8
	(SQL Overall)	178691	486	0.593	301333.9