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

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

275 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
kris	8	64	2361	(None)
bris	6	55	3961	1	bris
cris	6	62	3343	1	cris
iris	4	57	3255	1	iris
khis	11	70	1799	1	khis
kirs	8	58	3175	1	kirs
kis	7	80	5149	1	k_is
kois	8	51	2941	1	kois
sris	4	54	3415	1	sris
abris	7	57	2261	2	abris
ahis	7	61	3538	2	ahis
airs	4	64	4743	2	airs
ais	3	90	8358	2	_ais
amis	6	64	4532	2	amis
anis	4	57	4647	2	anis
arbs	6	68	3473	2	arbs
arcs	6	78	3478	2	arcs
ares	4	58	7102	2	ares
arfs	7	60	2996	2	arfs
aria	4	62	4543	2	aria
arias	5	54	3804	2	arias
arid	5	76	4272	2	arid
aril	4	58	4302	2	aril
arils	5	87	3220	2	arils
arise	5	64	3643	2	arise
arks	8	59	3687	2	arks
arms	6	61	3750	2	arms
arris	5	68	2468	2	arris
ars	3	76	7093	2	ar_s
arsis	5	57	2242	2	arsis
arts	4	96	5026	2	arts
auris	5	53	3153	2	auris
axis	11	61	2791	2	axis
bis	5	68	6067	2	_bis
bras	6	57	4645	2	bras
brie	6	58	3790	2	brie
bries	7	49	4215	2	bries
brig	7	65	2803	2	brig
brigs	8	58	2322	2	brigs
brim	8	56	2937	2	brim
brims	9	47	2162	2	brims
brin	6	70	3819	2	brin
brins	7	55	3397	2	brins
brio	6	54	3249	2	brio
brios	7	47	2573	2	brios
brisk	11	56	1598	2	brisk
briss	7	58	2427	2	briss
brit	6	63	5015	2	brit
brits	7	64	3309	2	brits
bros	6	56	3566	2	bros
chis	9	59	3331	2	chis
cis	5	77	4804	2	_cis
crib	8	63	2358	2	crib
cribs	9	45	1675	2	cribs
cries	7	54	3840	2	cries
crisp	9	50	1462	2	crisp
crit	6	57	4371	2	crit
crits	7	55	2757	2	crits
crus	6	58	2848	2	crus
dais	5	70	4070	2	dais
dis	4	64	5990	2	_dis
drib	7	68	2326	2	drib
dribs	8	51	1506	2	dribs
dries	6	47	3367	2	dries
drip	7	62	2395	2	drip
drips	8	54	1723	2	drips
drys	8	63	1480	2	drys
egis	5	65	2065	2	egis
eras	4	54	4150	2	eras
ergs	5	55	2381	2	ergs
erns	4	54	2823	2	erns
eros	4	52	3845	2	eros
errs	4	56	2253	2	errs
ers	3	60	4628	2	er_s
firs	7	66	3772	2	firs
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
ghis	8	50	2016	2	ghis
grid	6	58	2962	2	grid
grids	7	53	2140	2	grids
grig	6	54	2477	2	grig
grigs	7	53	1819	2	grigs
grim	7	69	2942	2	grim
grin	5	57	3372	2	grin
grins	6	54	2722	2	grins
grip	7	61	2702	2	grip
grips	8	55	2013	2	grips
grist	6	55	2987	2	grist
grit	5	52	4724	2	grit
grits	6	55	2958	2	grits
his	6	63	5951	2	_his
ibis	6	65	1958	2	ibis
ires	4	56	3928	2	ires
irid	5	59	2718	2	irid
irids	6	64	1778	2	irids
irks	8	62	2013	2	irks
is	2	70	4822	2	__is
iwis	7	71	1701	2	iwis
kaas	8	65	3186	2	kaas
kabs	10	71	3085	2	kabs
kadis	10	59	2107	2	kadis
kaes	8	57	3407	2	kaes
kafs	11	64	2375	2	kafs
kaif	11	69	3394	2	kaif
kaifs	12	57	1565	2	kaifs
kail	8	51	3150	2	kail
kails	9	55	2522	2	kails
kain	8	53	3430	2	kain
kains	9	61	2565	2	kains
kakis	8	61	1684	2	kakis
karns	9	66	2415	2	karns
karts	9	76	3012	2	karts
kas	7	70	5859	2	k_as
kats	8	59	4434	2	kats
kauris	10	36	1153	2	kauris
kays	11	60	3220	2	kays
keas	8	63	3710	2	keas
kefs	11	59	2275	2	kefs
kegs	9	58	2403	2	kegs
keir	8	62	1788	2	keir
keirs	9	53	1368	2	keirs
kens	8	54	3525	2	kens
kepis	11	53	1336	2	kepis
keps	10	60	2731	2	keps
kerbs	11	50	1367	2	kerbs
kerfs	12	54	1357	2	kerfs
kermis	12	40	1240	2	kermis
kerns	9	47	1956	2	kerns
keys	11	63	2217	2	keys
khi	10	63	1831	2	khi_
ki	6	75	3797	2	k_i_
kid	8	65	4063	2	k_id
kids	9	60	2965	2	kids
kif	10	59	4120	2	k_if
kifs	11	60	2352	2	kifs
kin	7	63	5398	2	k_in
kins	8	57	4792	2	kins
kip	9	70	4215	2	k_ip
kips	10	64	3053	2	kips
kir	7	65	3569	2	k_ir
kirk	7	62	2158	2	kirk
kirks	8	49	1527	2	kirks
kirn	8	71	2345	2	kirn
kirns	9	53	1546	2	kirns
kiss	8	52	2741	2	kiss
kist	8	65	4081	2	k_ist
kit	7	85	5989	2	k_it
kits	8	64	4178	2	kits
kiwis	12	32	859	2	kiwis
klik	7	44	1266	2	klik
kliks	8	39	883	2	kliks
knish	12	3	862	2	knish
knit	8	57	2815	2	knit
knits	9	39	1475	2	knits
koas	8	56	3510	2	koas
kobs	10	58	3109	2	kobs
koi	7	75	3476	2	koi_
kojis	16	46	844	2	kojis
kops	10	70	3130	2	kops
koras	9	59	2712	2	koras
kors	8	59	3302	2	kors
kos	7	69	4483	2	k_os
koss	8	52	2482	2	koss
krait	9	47	2677	2	krait
kraits	10	49	1220	2	kraits
krill	9	42	1365	2	krill
krills	10	42	1128	2	krills
krises	10	50	1608	2	krises
krubis	12	3	500	2	krubis
kues	8	64	2678	2	kues
kufis	12	4	925	2	kufis
kukris	9	3	445	2	kukris
kurus	9	80	1563	2	kurus
kvas	11	70	1595	2	kvas
kyes	11	51	2494	2	kyes
kyrie	12	37	1290	2	kyrie
kyries	13	34	1137	2	kyries
laris	5	47	3746	2	laris
leis	4	57	3960	2	leis
lis	3	71	6228	2	_lis
loris	5	53	2915	2	loris
mirs	6	69	4058	2	mirs
mis	5	81	6263	2	_mis
naris	5	57	3529	2	naris
noris	5	49	2827	2	noris
obis	6	62	2684	2	obis
okras	9	44	1097	2	okras
orbs	6	66	2625	2	orbs
orcs	6	70	2543	2	orcs
ores	4	60	5668	2	ores
ornis	5	46	1677	2	ornis
orris	5	45	1655	2	orris
ors	3	57	5011	2	or_s
orts	4	65	3833	2	orts
paris	7	51	4594	2	paris
peris	7	55	3707	2	peris
phis	9	57	2490	2	phis
pis	5	63	6204	2	_pis
pois	6	65	3904	2	pois
pries	7	43	3953	2	pries
prig	7	59	2487	2	prig
prigs	8	52	1970	2	prigs
prim	8	51	3220	2	prim
prims	9	54	2593	2	prims
prise	7	46	3261	2	prise
prism	9	48	2026	2	prism
priss	7	46	2389	2	priss
pros	6	57	4278	2	pros
psis	6	81	2034	2	psis
puris	7	53	3202	2	puris
qis	12	69	3439	2	_qis
rais	4	52	5262	2	rais
ras	3	75	7539	2	_ras
reis	4	53	4323	2	reis
res	3	55	6504	2	_res
ria	3	67	4551	2	_ria
rias	4	55	4060	2	_rias
rib	5	68	4804	2	_rib
ribs	6	58	3303	2	_ribs
rid	4	67	5464	2	_rid
rids	5	65	3956	2	_rids
rif	6	59	5157	2	_rif
rifs	7	49	2901	2	_rifs
rig	4	67	4813	2	_rig
rigs	5	51	3760	2	_rigs
rim	5	60	5228	2	_rim
rims	6	59	3631	2	_rims
rin	3	66	6319	2	_rin
rins	4	61	5320	2	_rins
rip	5	68	5131	2	_rip
rips	6	62	3744	2	_rips
rise	4	59	4524	2	_rise
risk	8	57	2411	2	_risk
saris	5	45	4495	2	saris
seis	4	55	4239	2	seis
shris	8	42	2145	2	shris
sirs	4	43	3834	2	sirs
sis	3	73	6055	2	_sis
skis	8	48	2530	2	skis
sri	3	56	3400	2	sri_
this	7	60	2738	2	this
tis	3	70	5665	2	_tis
tres	4	65	4290	2	tres
tries	5	57	4281	2	tries
trig	5	55	2816	2	trig
trigs	6	54	2306	2	trigs
trim	6	53	2952	2	trim
trims	7	50	2147	2	trims
trio	4	52	3334	2	trio
trios	5	55	2809	2	trios
trip	6	68	3039	2	trip
trips	7	49	2336	2	trips
trois	5	72	2609	2	trois
tuis	4	48	2964	2	tuis
urbs	6	59	2206	2	urbs
urds	5	59	2244	2	urds
uric	6	36	2494	2	uric
urns	4	63	2390	2	urns
urps	6	69	2048	2	urps
urus	4	64	2614	2	urus
vis	6	67	4762	2	_vis
wis	6	65	5234	2	_wis
wries	8	58	2774	2	wries
wrist	8	48	2756	2	wrist
writ	7	55	3791	2	writ
writs	8	66	2438	2	writs
xis	10	69	3534	2	_xis
ywis	10	53	1310	2	ywis
zoris	14	53	2001	2	zoris

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.360	496363.9
2	DLD Change Limit	29872	275	0.936	31914.5
3	Display Results	275	275	0.063	4365.1
	(SQL Overall)	178691	275	1.359	131487.1