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

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

296 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
tears	5	54	3646	(None)
bears	7	57	3904	1	bears
dears	6	57	3688	1	dears
ears	4	63	5659	1	_ears
fears	8	48	2939	1	fears
gears	6	46	2869	1	gears
hears	8	67	3737	1	hears
lears	5	59	3873	1	lears
nears	5	55	2942	1	nears
pears	7	51	3861	1	pears
rears	5	47	3965	1	rears
sears	5	47	4491	1	sears
tars	4	67	6395	1	t_ars
teaks	9	42	2290	1	teaks
teals	5	62	3413	1	teals
teams	7	57	2651	1	teams
tear	4	52	4288	1	tear_
teary	8	51	2405	1	teary
teas	4	58	5149	1	tea_s
teats	5	56	3681	1	teats
tsars	5	67	1711	1	tsars
tzars	14	49	1427	1	tzars
wears	8	60	3030	1	wears
years	8	45	2767	1	years
afars	8	57	1651	2	afars
agars	6	61	2064	2	agars
anears	6	37	1718	2	anears
ars	3	76	7093	2	__ars
attars	6	45	1531	2	attars
bars	6	65	6409	2	_bars
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
beans	7	57	3469	2	beans
bear	6	68	4464	2	bear_
beard	8	60	2496	2	beard
beards	9	41	1667	2	beards
beats	7	60	4224	2	beats
beaus	7	51	2711	2	beaus
beers	7	56	2839	2	beers
blears	8	51	1645	2	blears
boars	7	52	2960	2	boars
cars	6	73	6476	2	_cars
cedars	9	33	1283	2	cedars
chars	10	59	3664	2	chars
clears	8	41	1656	2	clears
czars	16	48	1291	2	czars
deads	7	57	2691	2	deads
deairs	7	40	1378	2	deairs
deals	6	54	3534	2	deals
deans	6	61	3139	2	deans
dear	5	53	4360	2	dear_
deary	9	58	2684	2	deary
debars	9	42	1804	2	debars
deers	6	49	3052	2	deers
denars	7	46	2143	2	denars
dewars	10	51	1707	2	dewars
drears	7	46	1425	2	drears
ear	3	68	6788	2	_ear_
earl	4	58	3814	2	_earl
earls	5	61	2751	2	_earls
earn	4	67	3755	2	_earn
earns	5	59	2756	2	_earns
eats	4	70	5487	2	_eats
eras	4	54	4150	2	_eras
errs	4	56	2253	2	_errs
ers	3	60	4628	2	_e_rs
etas	4	64	3227	2	eta_s
fear	7	53	3779	2	fear_
feats	8	64	3275	2	feats
feuars	9	3	865	2	feuars
fiars	8	67	2083	2	fiars
gars	5	57	5074	2	_gars
gear	5	59	3497	2	gear_
gnars	6	67	1885	2	gnars
guars	6	50	2105	2	guars
haars	8	56	2047	2	haars
heads	9	51	2711	2	heads
heals	8	57	3345	2	heals
heaps	10	52	2322	2	heaps
hear	7	61	4388	2	hear_
heard	9	52	2275	2	heard
hearse	9	41	1427	2	hearse
heart	8	54	4074	2	heart
hearts	9	62	1894	2	hearts
heats	8	58	3840	2	heats
heirs	8	56	1856	2	heirs
hers	7	58	4487	2	he_rs
hoars	8	59	2555	2	hoars
izars	14	51	1293	2	izars
jars	11	73	3835	2	_jars
jeans	12	60	2211	2	jeans
jeers	12	48	1813	2	jeers
kbars	11	46	1260	2	kbars
keas	8	63	3709	2	kea_s
kebars	12	41	1249	2	kebars
keirs	9	53	1367	2	keirs
knars	9	44	1611	2	knars
kyars	12	48	1396	2	kyars
lars	4	69	5657	2	_lars
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lear	4	70	4595	2	lear_
learn	5	53	2266	2	learn
learns	6	55	1374	2	learns
leary	8	59	2738	2	leary
leas	4	59	5418	2	lea_s
leers	5	48	2898	2	leers
lehrs	8	61	1113	2	lehrs
liars	5	47	2316	2	liars
maars	7	46	2163	2	maars
mars	6	62	6187	2	_mars
meads	8	54	2532	2	meads
meals	7	59	3337	2	meals
means	7	58	3123	2	means
meats	7	50	3405	2	meats
neaps	7	56	1832	2	neaps
near	4	52	3650	2	near_
neats	5	59	3190	2	neats
oars	4	68	4603	2	_oars
ottars	6	41	1222	2	ottars
pars	6	75	6079	2	_pars
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
pear	6	97	4523	2	pear_
pearl	7	53	2446	2	pearl
pearls	8	47	1539	2	pearls
peart	7	64	4075	2	peart
peas	6	57	5506	2	pea_s
peats	7	61	4019	2	peats
peers	7	51	3027	2	peers
reads	6	48	3527	2	reads
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rear	4	56	4455	2	rear_
rearm	7	59	2357	2	rearm
rearms	8	51	1465	2	rearms
rebars	8	40	1983	2	rebars
retears	7	28	1492	2	retears
roars	5	56	2224	2	roars
scars	7	54	3353	2	scars
seals	5	48	3969	2	seals
seams	7	57	3166	2	seams
sear	4	73	5384	2	sear_
seas	4	57	5527	2	sea_s
seats	5	48	4434	2	seats
seers	5	51	3638	2	seers
sers	4	57	4665	2	se_rs
sewars	9	40	1863	2	sewars
shears	9	38	2090	2	shears
smears	8	47	1443	2	smears
soars	5	47	3251	2	soars
spars	7	54	3154	2	spars
spears	8	40	1947	2	spears
stars	5	58	3657	2	stars
steads	7	41	1622	2	steads
steaks	10	44	1585	2	steaks
steals	6	40	2006	2	steals
steams	8	49	1690	2	steams
steers	6	38	2098	2	steers
swears	9	41	1407	2	swears
tabs	6	68	4298	2	t_abs
tads	5	71	4394	2	t_ads
taels	5	68	2207	2	taels
tags	5	55	4523	2	t_ags
tahrs	8	54	1233	2	tahrs
talars	6	60	2168	2	talars
tams	6	72	4793	2	t_ams
tans	4	61	5482	2	t_ans
taos	4	55	4100	2	t_aos
taps	6	60	5067	2	t_aps
tar	3	75	7069	2	t_ar_
tare	4	59	5762	2	t_are
tares	5	74	5656	2	t_ares
tarn	4	68	4272	2	t_arn
tarns	5	64	3395	2	t_arns
taro	4	68	4691	2	t_aro
taros	5	56	4082	2	t_aros
tarp	6	69	3641	2	t_arp
tarps	7	65	2711	2	t_arps
tarsi	5	52	2217	2	t_arsi
tart	4	75	6618	2	t_art
tarts	5	72	4202	2	t_arts
tas	3	84	7710	2	t_a_s
tass	4	56	4057	2	t_ass
tatars	6	46	1979	2	tatars
tats	4	68	5813	2	t_ats
taus	4	63	4273	2	t_aus
tavs	7	56	3097	2	t_avs
taws	7	56	4159	2	t_aws
tea	3	73	5332	2	tea__
teach	10	52	2112	2	teach
teak	8	59	3084	2	tea_k
teal	4	55	4650	2	tea_l
team	6	62	3865	2	tea_m
teared	7	57	2215	2	teared
tearer	6	48	2290	2	tearer
tearers	7	52	1823	2	tearers
teargas	8	3	701	2	teargas
tease	5	54	2871	2	tease
teasers	7	53	1724	2	teasers
teases	6	54	2627	2	teases
teat	4	59	6363	2	tea_t
techs	10	69	1583	2	techs
teds	5	49	3257	2	te_ds
teels	5	57	2637	2	teels
teems	7	60	1978	2	teems
teens	5	62	2748	2	teens
tees	4	53	5358	2	te_es
teffs	11	51	1173	2	teffs
teggs	7	47	1074	2	teggs
tegs	5	60	3149	2	te_gs
teles	5	45	3600	2	teles
tells	5	58	2894	2	tells
telos	5	54	2452	2	telos
tels	4	68	4169	2	te_ls
temps	9	54	1713	2	temps
tends	6	54	2558	2	tends
tenors	6	32	1775	2	tenors
tens	4	56	4741	2	te_ns
tents	5	64	3421	2	tents
tepals	8	54	1504	2	tepals
tepas	7	65	2168	2	tepas
terai	5	35	2548	2	terai
terais	6	40	2351	2	terais
term	6	62	3315	2	te_rm
terms	7	55	2347	2	terms
tern	4	61	3480	2	te_rn
terns	5	52	2687	2	terns
terra	5	44	1966	2	terra
terras	6	35	1697	2	terras
terry	8	47	2187	2	terry
terse	5	50	2682	2	te_rse
tests	5	65	3019	2	tests
teths	8	54	1851	2	teths
tetra	5	34	1795	2	tetra
tetras	6	30	1762	2	tetras
tetri	5	27	1645	2	tetri
tetris	6	28	1629	2	tetris
tets	4	58	4746	2	te_ts
tews	7	64	3164	2	te_ws
texas	12	65	1493	2	texas
texts	12	55	1504	2	texts
tharm	10	59	1664	2	tharm
tharms	11	57	1224	2	tharms
thaws	11	65	1546	2	thaws
theirs	9	46	1035	2	theirs
thenars	10	24	852	2	thenars
tiara	5	3	1591	2	tiara
tiaras	6	3	1455	2	tiaras
tiers	5	55	2652	2	tiers
toads	6	56	2107	2	toads
toeas	5	57	2642	2	toea_s
tolars	6	48	1794	2	tolars
toras	5	55	4037	2	toras
torrs	5	39	2356	2	torrs
tors	4	61	5738	2	t_ors
tours	5	53	2589	2	tours
trams	7	53	2767	2	trams
trans	5	49	3304	2	trans
traps	7	57	2748	2	traps
trass	5	62	2647	2	trass
trays	8	56	2343	2	trays
treads	7	48	1792	2	treads
treats	6	48	2169	2	treats
tsar	4	78	1980	2	tsar_
twaes	8	65	1366	2	twaes
twas	7	68	2408	2	twa_s
twats	8	66	1660	2	twats
tweaks	13	3	596	2	tweaks
tyers	8	62	2005	2	tyers
tzar	13	63	1537	2	tzar_
uptears	9	10	645	2	uptears
vars	7	57	4207	2	_vars
veals	8	49	2619	2	veals
veers	8	45	2136	2	veers
velars	9	39	1372	2	velars
wars	7	86	5980	2	_wars
weals	8	54	2874	2	weals
weans	8	53	2674	2	weans
wear	7	58	3672	2	wear_
weary	11	56	2061	2	weary
weirs	8	43	1649	2	weirs
yeahs	11	52	1455	2	yeahs
yeans	8	66	2488	2	yeans
year	7	65	3425	2	year_
yearn	8	63	1643	2	yearn
yearns	9	50	954	2	yearns
yeas	7	86	3842	2	yea_s
zeals	14	53	2085	2	zeals

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	53800	0.313	570897.8
2	DLD Change Limit	53800	296	2.016	26686.5
3	Display Results	296	296	0.076	3894.7
	(SQL Overall)	178691	296	2.405	74299.8