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

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

450 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
firs	7	66	3772	(None)
airs	4	64	4743	1	airs
fairs	8	58	2544	1	fairs
fiars	8	67	2083	1	fiars
fibs	9	63	2951	1	fibs
fids	8	70	3475	1	fids
figs	8	53	3265	1	figs
fils	7	58	3870	1	fils
fins	7	58	4910	1	fins
fir	6	67	4490	1	fir_
fire	7	62	4560	1	fire
fires	8	57	4075	1	fires
firm	9	60	2646	1	firm
firms	10	52	1742	1	firms
firn	7	69	2751	1	firn
firns	8	60	1854	1	firns
first	8	62	2612	1	first
fits	7	60	4347	1	fits
flirs	8	55	1893	1	flirs
furs	7	67	3504	1	furs
kirs	8	58	3175	1	kirs
mirs	6	69	4058	1	mirs
sirs	4	43	3834	1	sirs
afars	8	57	1651	2	afars
afire	8	62	1591	2	afire
aids	5	78	4637	2	aids
ails	4	56	5472	2	ails
aims	6	77	3819	2	aims
ains	4	61	5889	2	ains
air	3	80	5840	2	air_
airn	4	64	3384	2	airn
airns	5	55	2103	2	airns
airt	4	57	5779	2	airt
airts	5	56	2634	2	airts
airy	7	57	3416	2	airy
ais	3	90	8358	2	ai_s
aits	4	63	5554	2	aits
amirs	7	59	2492	2	amirs
ars	3	76	7093	2	_ars
bars	6	65	6409	2	bars
bias	6	47	3817	2	bias
bibs	8	48	3100	2	bibs
bids	7	58	3846	2	bids
biers	7	62	2522	2	biers
bigs	7	62	3503	2	bigs
bins	6	65	4826	2	bins
bios	6	63	3533	2	bios
bird	7	61	2833	2	bird
birds	8	54	2134	2	birds
birk	10	63	2687	2	birk
birks	11	49	2030	2	birks
birl	6	58	3048	2	birl
birls	7	40	2316	2	birls
biro	6	61	3122	2	biro
biros	7	53	2513	2	biros
birr	6	60	2237	2	birr
birrs	7	49	1710	2	birrs
birse	7	45	1740	2	birse
bis	5	68	6067	2	bi_s
bits	6	61	4817	2	bits
bris	6	55	3961	2	bris
burs	6	58	4742	2	burs
cars	6	73	6476	2	cars
cigs	7	56	2511	2	cigs
cire	6	58	3638	2	cire
cires	7	49	3291	2	cires
cis	5	77	4804	2	ci_s
coirs	7	52	2105	2	coirs
cors	6	66	5644	2	cors
cris	6	62	3343	2	cris
curs	6	56	4554	2	curs
dibs	7	62	3369	2	dibs
dies	5	56	5353	2	dies
difs	8	60	2733	2	difs
digs	6	60	3606	2	digs
dims	7	54	3503	2	dims
dins	5	66	5205	2	dins
dips	7	55	3692	2	dips
dire	5	66	4415	2	dire
dirk	9	63	2684	2	dirk
dirks	10	56	1952	2	dirks
dirl	5	74	3003	2	dirl
dirls	6	47	2050	2	dirls
dirt	5	55	5039	2	dirt
dirts	6	68	2446	2	dirts
dis	4	64	5990	2	di_s
diss	5	64	3449	2	diss
dits	5	64	5053	2	dits
dors	5	67	4760	2	dors
ears	4	63	5659	2	ears
emirs	7	61	1616	2	emirs
errs	4	56	2253	2	errs
ers	3	60	4628	2	_ers
fabs	9	86	3586	2	fabs
fads	8	69	3988	2	fads
fags	8	69	3912	2	fags
fails	8	56	3148	2	fails
fair	7	63	3252	2	fair_
fairy	11	53	1828	2	fairy
fakirs	13	46	808	2	fakirs
fans	7	62	4737	2	fans
faqirs	18	45	603	2	faqirs
far	6	77	6260	2	far_
fard	8	56	3906	2	fard
fards	9	66	2984	2	fards
fare	7	63	5446	2	fare
fares	8	58	5287	2	fares
farl	7	63	3855	2	farl
farls	8	57	3111	2	farls
farm	9	59	3453	2	farm
farms	10	63	2495	2	farms
faro	7	61	3692	2	faro
faros	8	55	3202	2	faros
fart	7	68	6056	2	fart
farts	8	83	3684	2	farts
fas	6	82	6293	2	f_as
fats	7	62	5250	2	fats
fays	10	85	3536	2	fays
fears	8	48	2939	2	fears
feds	8	52	3432	2	feds
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
fems	9	64	2870	2	fems
fens	7	61	3976	2	fens
fer	6	66	4612	2	fer_
fere	7	63	4223	2	fere
feres	8	60	3818	2	feres
fern	7	61	2932	2	fern
ferns	8	52	2008	2	ferns
fes	6	65	5167	2	f_es
fess	7	65	2916	2	fess
fets	7	53	4594	2	fets
feus	7	58	3075	2	feus
fiar	7	64	2734	2	fiar
fiat	7	66	4665	2	fiat
fiats	8	53	2448	2	fiats
fib	8	63	4428	2	fi_b
fibers	11	47	1752	2	fibers
fibre	10	48	1284	2	fibre
fibres	11	43	1212	2	fibres
fice	9	57	3712	2	fice
fices	10	60	3116	2	fices
fico	9	58	2460	2	fico
ficus	10	50	1549	2	ficus
fid	7	68	4770	2	fi_d
fido	8	77	2641	2	fido
fidos	9	58	1906	2	fidos
fie	6	71	5245	2	fi_e
fief	10	73	3137	2	fief
fiefs	11	62	1370	2	fiefs
fiery	11	47	1479	2	fiery
fife	10	60	2771	2	fife
fifers	12	54	1492	2	fifers
fifes	11	48	2239	2	fifes
fig	7	62	4284	2	fi_g
fil	6	54	4715	2	fi_l
fila	7	47	2914	2	fila
file	7	54	4665	2	file
filers	9	46	2372	2	filers
files	8	54	4127	2	files
fill	7	55	4020	2	fill
fills	8	46	3237	2	fills
film	9	48	2818	2	film
films	10	56	1796	2	films
filo	7	60	3429	2	filo
filos	8	61	2538	2	filos
fin	6	64	5804	2	fi_n
find	8	75	3261	2	find
finds	9	54	2483	2	finds
fine	7	51	4796	2	fine
fines	8	66	4426	2	fines
finis	8	68	2426	2	finis
fink	11	75	3213	2	fink
finks	12	54	2422	2	finks
fino	7	60	3470	2	fino
finos	8	62	2695	2	finos
fiord	9	43	1334	2	fiord
fiords	10	49	862	2	fiords
fired	9	48	2974	2	fired
firer	8	112	2925	2	firer
firers	9	49	2268	2	firers
firry	11	57	1353	2	firry
firsts	9	51	1092	2	firsts
firth	11	58	1953	2	firth
firths	12	51	1350	2	firths
fisc	9	68	1976	2	fisc
fiscs	10	53	1188	2	fiscs
fish	10	69	2628	2	fish
fist	7	62	4843	2	fist
fists	8	55	2754	2	fists
fit	6	63	6546	2	fi_t
five	10	76	2975	2	five
fivers	12	44	2092	2	fivers
fives	11	60	2736	2	fives
fix	13	62	3611	2	fi_x
fixers	16	51	1298	2	fixers
fixes	15	47	2359	2	fixes
fixt	14	107	2972	2	fixt
fiz	15	62	3877	2	fi_z
fizz	15	75	1983	2	fizz
flairs	9	57	1191	2	flairs
flics	10	54	1836	2	flics
fliers	9	44	1719	2	fliers
flies	8	56	3071	2	flies
flips	10	51	1774	2	flips
flir	7	64	2220	2	flir_
flirt	8	74	2475	2	flirt
flirts	9	54	1148	2	flirts
flits	8	56	2522	2	flits
flus	7	56	2654	2	flus
fobs	9	60	3427	2	fobs
foes	7	65	4344	2	foes
fogs	8	70	3500	2	fogs
foils	8	50	2581	2	foils
foins	8	55	2338	2	foins
fons	7	69	4389	2	fons
fops	9	65	3268	2	fops
for	6	69	5207	2	for_
fora	7	59	3739	2	fora
forb	9	71	3133	2	forb
forbs	10	57	2080	2	forbs
ford	8	68	3549	2	ford
fords	9	53	2818	2	fords
fore	7	83	5147	2	fore
fores	8	58	4710	2	fores
fork	11	59	3094	2	fork
forks	12	53	2468	2	forks
form	9	58	3687	2	form
forms	10	53	2705	2	forms
fort	7	64	5644	2	fort
forts	8	60	3445	2	forts
foss	7	64	3164	2	foss
fours	8	55	2149	2	fours
foys	10	56	2829	2	foys
friars	9	38	1209	2	friars
friers	9	47	1893	2	friers
fries	8	55	3560	2	fries
frig	8	54	2450	2	frig
frigs	9	60	1927	2	frigs
frise	8	53	2245	2	frise
frisk	12	53	1237	2	frisk
frit	7	70	4447	2	frit
frits	8	61	2910	2	frits
friz	16	63	2434	2	friz
fro	6	55	3064	2	f_ro
fry	9	62	2650	2	f_ry
fubs	9	63	2879	2	fubs
fuds	8	65	2857	2	fuds
fugs	8	57	3069	2	fugs
funs	7	52	3573	2	funs
fur	6	66	3732	2	fur_
furl	7	70	3088	2	furl
furls	8	53	2205	2	furls
fury	10	77	2797	2	fury
fuss	7	60	2793	2	fuss
gars	5	57	5074	2	gars
gibs	7	55	2928	2	gibs
gids	6	59	3375	2	gids
gies	5	56	4143	2	gies
gigs	6	66	3119	2	gigs
gins	5	55	4396	2	gins
gips	7	56	3293	2	gips
gird	6	54	2500	2	gird
girds	7	48	1700	2	girds
girl	5	62	2656	2	girl
girls	6	45	1839	2	girls
girn	5	60	2687	2	girn
girns	6	45	1680	2	girns
giro	5	58	2864	2	giro
giros	6	57	2265	2	giros
girsh	9	53	1002	2	girsh
girt	5	66	4643	2	girt
girts	6	54	2362	2	girts
gits	5	57	4460	2	gits
hairs	8	62	2517	2	hairs
heirs	8	56	1856	2	heirs
hers	7	58	4487	2	hers
hies	7	48	4284	2	hies
hims	9	52	3098	2	hims
hins	7	64	4800	2	hins
hips	9	64	3371	2	hips
hire	7	55	3897	2	hire
hires	8	61	3434	2	hires
his	6	63	5951	2	hi_s
hiss	7	56	2922	2	hiss
hits	7	55	4514	2	hits
ids	4	75	3548	2	_ids
ifs	6	71	2425	2	_ifs
ins	3	59	4561	2	_ins
ire	3	69	4318	2	_ire
ires	4	56	3928	2	_ires
iris	4	57	3255	2	_iris
irk	7	64	2637	2	_irk
irks	8	62	2013	2	_irks
is	2	70	4822	2	_i_s
its	3	55	3884	2	_its
jars	11	73	3835	2	jars
jibs	13	67	2409	2	jibs
jigs	12	65	2477	2	jigs
jins	11	56	3502	2	jins
kafirs	13	30	698	2	kafirs
kefirs	13	39	665	2	kefirs
keirs	9	53	1368	2	keirs
kids	9	60	2965	2	kids
kiers	9	53	2010	2	kiers
kifs	11	60	2352	2	kifs
kins	8	57	4792	2	kins
kips	10	64	3053	2	kips
kir	7	65	3569	2	kir_
kirk	7	62	2158	2	kirk
kirks	8	49	1527	2	kirks
kirn	8	71	2345	2	kirn
kirns	9	53	1546	2	kirns
kis	7	80	5149	2	ki_s
kiss	8	52	2741	2	kiss
kits	8	64	4178	2	kits
kors	8	59	3302	2	kors
kris	8	64	2361	2	kris
lairs	5	54	2587	2	lairs
lars	4	69	5657	2	lars
liars	5	47	2316	2	liars
libs	6	67	3277	2	libs
lids	5	63	3647	2	lids
liers	5	51	3040	2	liers
lies	4	64	5420	2	lies
lins	4	70	5906	2	lins
lips	6	71	4145	2	lips
lira	4	69	2869	2	lira
liras	5	60	2198	2	liras
lire	4	78	4530	2	lire
liri	4	51	2826	2	liri
lis	3	71	6228	2	li_s
lits	4	62	5250	2	lits
mairs	7	62	2830	2	mairs
mars	6	62	6187	2	mars
mibs	8	53	3049	2	mibs
mics	8	74	3516	2	mics
mids	7	65	4180	2	mids
migs	7	69	3533	2	migs
mils	6	60	4534	2	mils
mips	8	55	3409	2	mips
mir	5	70	4678	2	mir_
mire	6	67	4824	2	mire
mires	7	56	4088	2	mires
miri	6	67	3038	2	miri
mirk	10	67	2951	2	mirk
mirks	11	51	2214	2	mirks
miry	9	63	2676	2	miry
mis	5	81	6263	2	mi_s
miss	6	53	3943	2	miss
mors	6	59	5006	2	mors
nibs	6	50	2832	2	nibs
nils	4	61	3246	2	nils
nims	6	62	2689	2	nims
nips	6	58	3093	2	nips
nits	4	57	4165	2	nits
noirs	5	56	1546	2	noirs
oars	4	68	4603	2	oars
oils	4	63	3798	2	oils
ors	3	57	5011	2	_ors
ours	4	72	3756	2	ours
pairs	7	53	2583	2	pairs
pars	6	75	6079	2	pars
pias	6	65	4256	2	pias
pics	8	56	3392	2	pics
piers	7	59	2633	2	piers
pies	6	69	4961	2	pies
pigs	7	66	3423	2	pigs
pins	6	55	5846	2	pins
pips	8	58	3714	2	pips
pirn	6	71	2838	2	pirn
pirns	7	60	2009	2	pirns
pis	5	63	6204	2	pi_s
piss	6	50	3334	2	piss
pits	6	63	4875	2	pits
purs	6	56	4104	2	purs
qis	12	69	3439	2	qi_s
rias	4	55	4060	2	rias
ribs	6	58	3303	2	ribs
rids	5	65	3956	2	rids
rifs	7	49	2901	2	rifs
rigs	5	51	3760	2	rigs
rims	6	59	3631	2	rims
rins	4	61	5320	2	rins
rips	6	62	3744	2	rips
sers	4	57	4665	2	sers
sibs	6	59	3355	2	sibs
sics	6	52	3410	2	sics
sims	6	57	3718	2	sims
sins	4	67	5528	2	sins
sips	6	57	4011	2	sips
sir	3	57	4668	2	sir_
sire	4	61	5042	2	sire
sires	5	59	4537	2	sires
sis	3	73	6055	2	si_s
sits	4	50	5021	2	sits
sris	4	54	3415	2	sris
stirs	5	59	2162	2	stirs
tars	4	67	6395	2	tars
tics	6	57	2964	2	tics
tiers	5	55	2652	2	tiers
ties	4	52	4832	2	ties
tils	4	57	3962	2	tils
tins	4	52	5131	2	tins
tips	6	64	3677	2	tips
tire	4	61	4336	2	tire
tires	5	54	3749	2	tires
tirl	4	50	2993	2	tirl
tirls	5	45	1980	2	tirls
tiro	4	68	3237	2	tiro
tiros	5	45	2489	2	tiros
tis	3	70	5665	2	ti_s
tits	4	61	4505	2	tits
tors	4	61	5738	2	tors
vairs	8	50	1913	2	vairs
vars	7	57	4207	2	vars
vids	8	56	2755	2	vids
viers	8	56	2195	2	viers
vies	7	52	3863	2	vies
vigs	8	54	2728	2	vigs
vims	9	54	2332	2	vims
vires	8	45	2968	2	vires
virl	7	62	2448	2	virl
virls	8	56	1860	2	virls
virus	8	53	1684	2	virus
vis	6	67	4762	2	vi_s
wairs	8	64	2406	2	wairs
wars	7	86	5980	2	wars
weirs	8	43	1649	2	weirs
whirs	11	52	1809	2	whirs
wigs	8	49	3126	2	wigs
wins	7	59	4918	2	wins
wire	7	58	3982	2	wire
wires	8	60	3491	2	wires
wiry	10	64	2284	2	wiry
wis	6	65	5234	2	wi_s
wiss	7	56	3055	2	wiss
wits	7	60	4488	2	wits
xis	10	69	3534	2	xi_s
yids	8	52	2497	2	yids
yins	7	53	3513	2	yins
yips	9	52	2671	2	yips
yird	8	70	1899	2	yird
yirds	9	66	1252	2	yirds
yirr	7	65	1358	2	yirr
yirrs	8	46	919	2	yirrs
zigs	14	54	2280	2	zigs
zins	13	57	3501	2	zins
zips	15	57	2380	2	zips
zits	13	60	3030	2	zits

Search took 3 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	450	2.046	14600.2
3	Display Results	450	450	0.110	4090.9
	(SQL Overall)	178691	450	2.436	73354.3