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

Here are the results of your fuzzy-string dictionary search for “kinema” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

254 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
kinema	12	3	602	(None)
cinema	10	4	765	1	cinema
kinemas	13	3	689	1	kinemas
cinemas	11	3	804	2	cinemas
enema	7	6	1274	2	_enema
kina	8	56	3199	2	kin__a
kinara	10	3	1037	2	kinara
kine	8	56	4342	2	kine__
kines	9	50	3913	2	kine_s
kinsman	13	3	596	2	kinsman
lineman	9	3	912	2	lineman
minima	10	55	1265	2	minima
nema	6	55	2252	2	__nema
pineta	8	58	1556	2	pineta
tinea	5	49	2316	2	tine_a
adnexa	14	3	367	3	adnexa
akinesia	12	8	407	3	akinesia
anemia	8	26	1357	3	_anemia
anima	7	46	2007	3	_anima
apnea	7	34	1341	3	apne_a
bema	8	58	2525	3	__bema
bima	8	67	2383	3	bi__ma
bine	6	66	5086	3	bine__
biner	7	59	3069	3	bine_r
biners	8	50	2363	3	biners
bines	7	69	4679	3	bine_s
bireme	10	3	1014	3	bireme
cine	6	62	4294	3	cine__
cineol	8	10	820	3	cineol
cines	7	52	3968	3	cine_s
dilemma	12	4	306	3	dilemma
dine	5	55	5533	3	dine__
dined	7	64	3199	3	dine_d
diner	6	56	3290	3	dine_r
dinero	7	56	1264	3	dinero
diners	7	55	2595	3	diners
dines	6	64	4915	3	dine_s
eczema	19	7	307	3	eczema
edema	8	6	1055	3	_edema
enemas	8	8	1200	3	_enemas
enemy	10	5	999	3	_enemy
enigma	9	3	564	3	enigma
fanega	10	5	578	3	fanega
finca	10	47	1450	3	fin_ca
fine	7	51	4795	3	fine__
fined	9	49	3050	3	fine_d
finely	12	30	1156	3	finely
finer	8	54	3156	3	fine_r
finery	12	45	1289	3	finery
fines	8	66	4426	3	fine_s
finest	9	43	2173	3	finest
fireman	12	4	933	3	fireman
genera	7	12	1171	3	genera
geneva	10	8	585	3	geneva
guinea	7	3	761	3	guine_a
hiemal	11	33	950	3	hi_emal
iceman	10	3	785	3	_iceman
idea	5	91	2277	3	_ide_a
idem	7	61	2106	3	_idem_
ilea	4	59	3146	3	_ile_a
inept	7	36	2215	3	_inept
inert	5	32	3437	3	_inert
infra	8	3	864	3	_infra
inia	4	50	2470	3	_in_ia
inseam	8	32	999	3	_inseam
intima	8	19	1003	3	_intima
item	6	56	2038	3	_item_
items	7	49	961	3	_items
jicama	17	3	488	3	jicama
kana	8	59	2852	3	kan__a
kanaka	9	35	752	3	kanaka
kane	8	51	3396	3	kane__
kanes	9	55	2937	3	kane_s
karma	11	34	1500	3	k_arma
kea	7	65	4091	3	k__e_a
kemp	12	64	1876	3	k__emp
kheda	13	4	653	3	k_heda
kibe	10	65	2344	3	kibe__
kibei	11	43	1153	3	kibe_i
kibeis	12	46	980	3	kibeis
kibes	11	55	2111	3	kibe_s
kibla	11	3	983	3	ki_bla
kidney	14	3	475	3	kidne_y
kidneys	15	3	342	3	kidneys
kief	11	71	2840	3	ki_e_f
kiefs	12	61	1220	3	ki_efs
kier	8	65	2680	3	ki_e_r
kiers	9	53	2009	3	ki_ers
kike	7	65	2478	3	kike__
kikes	8	51	2255	3	kike_s
kilim	11	7	1188	3	kilim_
kilims	12	7	790	3	kilims
kilned	11	36	839	3	kilne_d
kin	7	63	5396	3	kin___
kinaras	11	5	912	3	kinaras
kinas	9	56	2691	3	kin_as
kinase	10	42	1065	3	kinase
kind	9	61	2855	3	kin__d
kinder	11	37	1684	3	kinder
kindest	12	3	1150	3	kindest
kindle	11	44	1423	3	kindle
kindly	14	35	884	3	kindly
kinds	10	62	2181	3	kin_ds
kinematic	17	4	491	3	kinema~~tic~~
kineses	11	31	1125	3	kineses
kinesic	13	25	702	3	kinesic
kinesis	11	25	959	3	kinesis
kinetic	13	20	917	3	kinetic
kinetin	11	24	826	3	kinetin
king	9	59	3365	3	kin__g
kinged	12	42	1528	3	kinged
kingly	14	35	1130	3	kingly
kings	10	58	2556	3	kin_gs
kinin	9	49	1732	3	kin_in
kinins	10	40	1458	3	kinins
kink	7	60	3439	3	kin__k
kinked	10	40	1475	3	kinked
kinks	8	49	2608	3	kin_ks
kinky	11	58	1638	3	kin_ky
kinless	11	33	1027	3	kinless
kino	8	62	3361	3	kin__o
kinos	9	66	2614	3	kin_os
kins	8	57	4790	3	kin__s
kinsmen	13	3	565	3	kinsmen
kirkman	12	4	377	3	kirkman
kirned	11	40	862	3	kirne_d
kishka	12	3	296	3	kishka
kismat	12	30	1167	3	ki_smat
kismet	12	34	1462	3	kismet
kite	8	53	3823	3	kite__
kited	10	51	2009	3	kite_d
kiter	9	55	2321	3	kite_r
kiters	10	52	1859	3	kiters
kites	9	54	3254	3	kite_s
kiva	11	65	1640	3	ki__va
knead	10	42	966	3	k_nead
knee	8	53	2360	3	k_ne_e
kneed	10	46	1205	3	k_need
kneel	9	50	1203	3	k_neel
knees	9	51	1487	3	k_nees
knell	9	42	1092	3	k_nell
knelt	9	46	1768	3	k_nelt
knew	11	59	1212	3	k_ne_w
koine	9	5	1648	3	koine__
koines	10	4	1573	3	koine_s
korma	11	59	1307	3	k_orma
kuna	8	51	2070	3	kun__a
kune	8	54	2457	3	kune__
lima	6	57	3413	3	li__ma
line	4	69	6557	3	line__
lineal	6	56	1602	3	lineal
linear	6	51	1334	3	linear
lined	6	49	3464	3	line_d
linemen	9	3	863	3	linemen
linen	5	57	2872	3	line_n
linens	6	48	1839	3	linens
lineny	9	40	1144	3	lineny
liner	5	59	3892	3	line_r
liners	6	54	2885	3	liners
lines	5	70	5457	3	line_s
linesman	10	4	625	3	linesman
lineup	8	3	598	3	lineup
liney	8	70	2963	3	line_y
linga	6	68	2082	3	lin_ga
lingam	9	51	1235	3	lingam
lingua	7	50	991	3	lingua
linkman	13	3	539	3	linkman
linum	7	3	1382	3	linum_
linums	8	3	828	3	linums
lipoma	10	4	675	3	lipoma
miasma	10	9	756	3	miasma
mina	6	51	3691	3	min__a
mine	6	72	5616	3	mine__
mined	8	53	3335	3	mine_d
miner	7	69	3354	3	mine_r
mineral	9	3	1273	3	mineral
miners	8	41	2663	3	miners
mines	7	56	5195	3	mine_s
minim	9	73	2160	3	minim_
minimal	11	40	1060	3	minimal
minimax	18	37	601	3	minimax
minims	10	45	1481	3	minims
nemas	7	53	2157	3	__nemas
nine	4	58	4217	3	nine__
nines	5	59	3734	3	nine_s
ninety	9	5	1096	3	ninety
ninja	12	5	809	3	nin_ja
noma	6	75	2946	3	__noma
oedema	9	3	657	3	oedema
panama	10	42	1335	3	panama
pieta	7	54	2175	3	pi_eta
pikeman	15	3	552	3	pikeman
pilea	7	51	2395	3	pile_a
pima	8	54	2865	3	pi__ma
pina	6	58	4263	3	pin__a
pinata	8	38	1722	3	pinata
pine	6	77	5571	3	pine__
pineal	8	48	1768	3	pineal
pined	8	59	3532	3	pine_d
pinene	8	29	1564	3	pinene
pinery	11	52	1429	3	pinery
pines	7	60	4886	3	pine_s
pinesap	11	6	472	3	pinesap
piney	10	57	2750	3	pine_y
pinna	7	53	2018	3	pin_na
pinta	7	57	2705	3	pin_ta
pneuma	10	3	526	3	_pneuma
quinela	16	3	520	3	quinela
schema	13	8	837	3	schema
seneca	8	3	979	3	seneca
senega	7	3	817	3	senega
sideman	10	3	797	3	sideman
sienna	6	4	719	3	sienna
sigma	8	45	1383	3	si_gma
sima	6	47	3078	3	si__ma
sine	4	65	6062	3	sine__
sines	5	59	5482	3	sine_s
sinew	8	47	1892	3	sine_w
sinews	9	42	1062	3	sinews
sinewy	12	66	751	3	sinewy
tine	4	58	5513	3	tine__
tineal	6	62	1616	3	tineal
tineas	6	46	1648	3	tineas
tined	6	54	3453	3	tine_d
tineid	7	44	1202	3	tineid
tines	5	48	4842	3	tine_s
tinman	8	24	1114	3	tin_man
tinmen	8	23	1040	3	tinmen
toneme	8	3	1210	3	toneme
ulema	7	10	971	3	_ulema
urinemia	10	4	395	3	urinemia
usnea	5	3	939	3	usne_a
vina	7	63	3180	3	vin__a
vinca	10	53	1516	3	vin_ca
vine	7	56	4368	3	vine__
vineal	9	48	1474	3	vineal
vined	9	56	2615	3	vine_d
vinegar	11	3	461	3	vinegar
vinery	12	49	1260	3	vinery
vines	8	51	3764	3	vine_s
viremia	12	4	608	3	viremia
wine	7	49	5342	3	wine__
wined	9	44	3418	3	wine_d
winery	12	50	1428	3	winery
wines	8	55	4686	3	wine_s
winesap	12	6	444	3	winesap
winey	11	53	2543	3	wine_y
wingman	13	3	638	3	wingman
wireman	12	3	784	3	wireman
zine	13	70	3615	3	zine__
zineb	16	56	1414	3	zine_b
zinebs	17	60	680	3	zinebs
zines	14	52	3265	3	zine_s
zinnia	15	3	601	3	zinnia

Search took 6 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	254	5.110	22057.9
3	Display Results	254	254	0.080	3175.0
	(SQL Overall)	178691	254	5.330	33525.5