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

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

209 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
liking	11	43	1958	(None)
biking	13	50	1817	1	biking
diking	12	43	2024	1	diking
hiking	14	36	1710	1	hiking
laking	11	50	2704	1	laking
licking	14	41	1828	1	licking
likings	12	53	941	1	likings
liming	9	40	2124	1	liming
lining	7	45	2680	1	lining
linking	12	38	1825	1	linking
living	10	43	1832	1	living
miking	13	42	1846	1	miking
piking	13	37	1964	1	piking
viking	14	34	1461	1	viking
aiding	8	44	2361	2	aiding
ailing	7	43	3101	2	ailing
aiming	9	43	2084	2	aiming
airing	7	49	2750	2	airing
alining	8	19	1704	2	alining
asking	11	60	1723	2	asking
baking	13	56	2662	2	baking
biding	10	47	2079	2	biding
bikini	12	41	891	2	bikini
bilking	14	44	1355	2	bilking
biting	9	53	2182	2	biting
blinking	15	35	1062	2	blinking
caking	13	46	2467	2	caking
citing	9	42	2018	2	citing
clicking	17	36	1098	2	clicking
clinking	15	36	1166	2	clinking
coking	13	45	2388	2	coking
deking	12	56	1455	2	deking
dicing	10	57	1876	2	dicing
dicking	15	36	1761	2	dicking
dieing	8	40	1865	2	dieing
dining	8	45	2513	2	dining
dinking	13	36	1828	2	dinking
dirking	13	38	1260	2	dirking
disking	13	46	1549	2	disking
diving	11	37	1795	2	diving
duking	12	47	1513	2	duking
dyking	15	45	801	2	dyking
eking	10	66	1498	2	_eking
eliding	9	34	1434	2	eliding
faking	14	55	2098	2	faking
fifing	13	42	1234	2	fifing
filing	10	38	2376	2	filing
fining	10	42	2321	2	fining
finking	15	40	1660	2	finking
firing	10	40	2172	2	firing
fixing	17	48	1378	2	fixing
flaking	15	41	1449	2	flaking
flicking	18	41	1004	2	flicking
fliting	11	35	1461	2	fliting
fluking	15	44	1051	2	fluking
gibing	10	37	1235	2	gibing
gieing	8	36	1485	2	gieing
giving	11	43	1388	2	giving
gliding	10	39	1184	2	gliding
gliming	11	33	1013	2	gliming
hiding	11	43	1933	2	hiding
hieing	10	42	1662	2	hieing
hiring	10	44	2160	2	hiring
hiving	13	41	1552	2	hiving
hoking	14	44	1951	2	hoking
icing	8	60	1775	2	_icing
inking	11	51	1905	2	inking
iring	6	60	2542	2	_iring
irking	11	46	1175	2	irking
jibing	16	37	962	2	jibing
jinking	19	36	1354	2	jinking
jiving	17	37	1160	2	jiving
joking	18	41	1302	2	joking
juking	18	38	1047	2	juking
kicking	13	33	1402	2	kicking
king	9	59	3365	2	__king
kinking	11	36	1515	2	kinking
kiting	11	41	1709	2	kiting
lacing	9	46	2623	2	lacing
lacking	14	38	2154	2	lacking
lading	8	42	2712	2	lading
lairing	8	37	1534	2	lairing
lakings	12	47	1351	2	lakings
laming	9	45	2836	2	laming
larking	12	37	1825	2	larking
lasing	7	47	2798	2	lasing
laving	10	46	2357	2	laving
lawing	10	46	2528	2	lawing
laying	10	45	2570	2	laying
lazing	16	48	2147	2	lazing
leaking	12	36	1697	2	leaking
lekking	11	30	650	2	lekking
liang	6	49	1441	2	li_ang
lickings	15	29	814	2	lickings
lidding	10	36	1143	2	lidding
lifting	11	33	1327	2	lifting
liken	9	118	1884	2	liken_
likening	13	24	689	2	likening
likens	10	56	1370	2	likens
lilting	8	35	1538	2	lilting
limbing	12	34	1042	2	limbing
limina	8	35	1450	2	limina
limning	10	37	1032	2	limning
limping	12	46	1411	2	limping
ling	5	74	4796	2	l__ing
linin	5	80	2552	2	linin_
linings	8	43	1307	2	linings
linins	6	59	2214	2	linins
linting	8	38	2098	2	linting
lipin	7	55	1889	2	lipin_
lipins	8	50	1688	2	lipins
lipping	12	30	1607	2	lipping
lisping	10	34	1275	2	lisping
listing	8	40	2059	2	listing
livings	11	40	892	2	livings
locking	14	37	1815	2	locking
loiding	9	33	1340	2	loiding
looing	7	36	2104	2	looing
looking	12	34	1504	2	looking
loping	9	39	2141	2	loping
losing	7	40	2287	2	losing
loving	10	44	1672	2	loving
lowing	10	46	2327	2	lowing
loxing	14	36	1527	2	loxing
lubing	9	41	1404	2	lubing
lucking	14	36	1583	2	lucking
luging	8	39	1529	2	luging
luring	7	38	2075	2	luring
lurking	12	37	1085	2	lurking
luting	7	52	2175	2	luting
lying	9	57	1745	2	l_ying
lysing	10	47	1044	2	lysing
making	13	48	2385	2	making
milking	14	37	1276	2	milking
miming	11	43	1726	2	miming
mining	9	42	2545	2	mining
miring	9	37	2380	2	miring
mixing	16	47	1394	2	mixing
nicking	14	35	1632	2	nicking
niding	8	32	1798	2	niding
nixing	14	33	1149	2	nixing
nuking	11	34	1125	2	nuking
oiling	7	49	2531	2	oiling
oinking	12	37	1471	2	oinking
paiking	14	38	1481	2	paiking
picking	16	34	1833	2	picking
pieing	9	39	1765	2	pieing
piing	8	52	1883	2	pi_ing
piling	9	50	2559	2	piling
pining	9	37	2653	2	pining
pinking	14	39	1894	2	pinking
piping	11	40	1745	2	piping
plinking	15	36	1124	2	plinking
poking	13	38	1930	2	poking
puking	13	39	1306	2	puking
raking	11	47	2842	2	raking
ricing	9	48	2276	2	ricing
ricking	14	39	2023	2	ricking
riding	8	43	2596	2	riding
riling	7	42	2797	2	riling
riming	9	33	2222	2	riming
riping	9	38	2161	2	riping
rising	7	40	2588	2	rising
risking	12	39	1424	2	risking
riving	10	45	2142	2	riving
ryking	14	34	811	2	ryking
sicking	14	37	2017	2	sicking
siding	8	38	2213	2	siding
silking	12	37	1559	2	silking
sinking	12	33	2054	2	sinking
siping	9	42	2063	2	siping
siring	7	51	2831	2	siring
siting	7	41	2662	2	siting
sizing	16	36	1644	2	sizing
skiing	11	36	1019	2	skiing
slaking	12	37	1747	2	slaking
slicing	10	35	1464	2	slicing
slicking	15	37	1259	2	slicking
sliding	9	31	1455	2	sliding
sliming	10	29	1395	2	sliming
slinking	13	34	1298	2	slinking
sliping	10	33	1441	2	sliping
spiking	14	43	1288	2	spiking
taking	11	47	2595	2	taking
ticking	14	32	1875	2	ticking
tiding	8	35	2009	2	tiding
tieing	7	35	1876	2	tieing
tiling	7	34	2655	2	tiling
timing	9	36	1930	2	timing
tining	7	49	2754	2	tining
tiring	7	40	2309	2	tiring
toking	11	44	2072	2	toking
tsking	11	42	1042	2	tsking
vicing	12	40	1424	2	vicing
vikings	15	38	662	2	vikings
vining	10	46	1946	2	vining
vising	10	39	1587	2	vising
waking	14	48	2138	2	waking
wicking	17	34	1477	2	wicking
wifing	13	35	1339	2	wifing
wiling	10	30	2429	2	wiling
wining	10	36	2505	2	wining
winking	15	33	1796	2	winking
wiping	12	39	1671	2	wiping
wiring	10	45	2102	2	wiring
wising	10	33	1822	2	wising
witing	10	35	2282	2	witing
wiving	13	33	1660	2	wiving
yoking	14	39	1228	2	yoking

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	82551	0.126	1418182.5
2	DLD Change Limit	82551	209	2.470	33421.5
3	Display Results	209	209	0.060	3483.3
	(SQL Overall)	178691	209	2.656	67278.2