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

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

182 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
shives	12	49	2141	(None)
chives	14	43	1759	1	chives
hives	11	69	2551	1	_hives
shaves	12	52	2493	1	shaves
shies	8	61	3655	1	shi_es
shines	9	50	2891	1	shines
shires	9	52	2557	1	shires
shivas	12	45	1241	1	shivas
shive	11	44	2342	1	shive_
shiver	12	45	1737	1	shiver
shivers	13	37	1483	1	shivers
shivs	11	50	1880	1	shiv_s
shoves	12	49	1942	1	shoves
shrives	13	44	1617	1	shrives
skives	13	41	1394	1	skives
swives	12	39	1518	1	swives
chides	12	46	2047	2	chides
chiles	11	54	2530	2	chiles
chimes	13	49	2257	2	chimes
chines	11	50	2917	2	chines
chive	13	51	1762	2	chive_
chivies	15	34	1285	2	chivies
dives	9	58	3240	2	_dives
drives	10	51	1711	2	drives
fives	11	60	2736	2	_fives
gives	9	53	2487	2	_gives
haves	11	60	3487	2	_haves
hides	9	51	2942	2	_hides
hies	7	48	4283	2	_hi_es
hikes	12	54	2698	2	_hikes
hires	8	61	3434	2	_hires
hive	10	60	2967	2	_hive_
hived	12	52	1791	2	_hived
jives	15	48	2081	2	_jives
knives	13	45	855	2	knives
lives	8	61	3319	2	_lives
naives	9	49	1422	2	naives
ogives	10	36	791	2	ogives
olives	9	43	1395	2	olives
phizes	20	38	913	2	phizes
reives	9	57	2304	2	reives
rives	8	53	3600	2	_rives
saices	8	42	2180	2	saices
salves	9	42	2176	2	salves
saves	8	58	3863	2	s_aves
scrives	12	44	1427	2	scrives
seines	6	50	2990	2	seines
seises	6	40	2671	2	seises
seizes	15	43	1753	2	seizes
selves	9	41	1961	2	selves
serves	9	44	2365	2	serves
shades	10	59	2453	2	shades
shakes	13	50	2459	2	shakes
shales	9	47	3125	2	shales
shames	11	47	2622	2	shames
shapes	11	51	2494	2	shapes
shares	9	52	3641	2	shares
shave	11	44	2589	2	shave_
shaved	13	51	1838	2	shaved
shaven	12	42	1330	2	shaven
shaver	12	37	1891	2	shaver
shavers	13	41	1509	2	shavers
shavies	13	42	1320	2	shavies
sheaves	13	44	1297	2	sheaves
sheeves	13	39	1195	2	sheeves
shelves	13	41	1209	2	shelves
shes	7	57	3435	2	sh__es
shied	9	61	2549	2	shi_ed
shiel	8	110	2377	2	shi_el
shiels	9	54	1892	2	shiels
shier	8	54	2894	2	shi_er
shiers	9	49	2175	2	shiers
shiest	9	58	2152	2	shi_est
shifts	12	44	1294	2	shifts
shikse	13	8	607	2	shikse
shikses	14	11	657	2	shikses
shills	9	45	1961	2	shills
shims	10	44	2255	2	shi_ms
shine	8	55	3309	2	shine_
shined	10	46	2078	2	shined
shiner	9	38	2087	2	shiner
shiners	10	40	1594	2	shiners
shins	8	51	3104	2	shi_ns
ships	10	51	2377	2	shi_ps
shire	8	47	2713	2	shire_
shirks	13	48	1412	2	shirks
shirrs	9	44	1317	2	shirrs
shirts	9	49	1834	2	shirts
shists	9	65	1511	2	shists
shits	8	47	3117	2	shi_ts
shiv	10	57	2117	2	shiv__
shiva	11	59	1500	2	shiv_a
shivah	15	48	854	2	shivah
shivahs	16	37	572	2	shivahs
shivery	16	31	702	2	shivery
shmoes	11	46	1210	2	shmoes
shoes	8	54	2966	2	sh_oes
shores	9	48	3041	2	shores
shotes	9	53	2191	2	shotes
shove	11	44	2104	2	shove_
shoved	13	42	1428	2	shoved
shovel	12	46	1132	2	shovel
shovels	13	37	839	2	shovels
shover	12	45	1599	2	shover
shovers	13	46	1300	2	shovers
shrieves	14	29	709	2	shrieves
shrikes	14	44	1239	2	shrikes
shrines	10	46	1869	2	shrines
shrive	12	52	1695	2	shrive_
shrived	14	47	1218	2	shrived
shrivel	13	47	940	2	shrivel
shrivels	14	37	644	2	shrivels
shriven	13	37	965	2	shriven
shriver	13	47	1219	2	shriver
shrivers	14	41	910	2	shrivers
shutes	9	35	1822	2	shutes
sices	7	56	3727	2	s_ices
sides	6	58	3836	2	s_ides
sieves	9	32	1600	2	sieves
sikes	9	62	3608	2	s_ikes
sines	5	59	5482	2	s_ines
sipes	7	60	3695	2	s_ipes
sires	5	59	4537	2	s_ires
sises	5	52	3383	2	s_ises
sites	5	60	4543	2	s_ites
siver	8	57	2861	2	s_iver
sivers	9	53	2415	2	s_ivers
sixes	12	45	2636	2	s_ixes
sizes	14	67	2776	2	s_izes
skies	9	50	2683	2	ski_es
skites	10	44	1804	2	skites
skive	12	46	1411	2	skive_
skived	14	42	989	2	skived
skiver	13	46	1210	2	skiver
skivers	14	40	970	2	skivers
slaves	9	50	2302	2	slaves
slices	8	40	2285	2	slices
slides	7	39	2218	2	slides
slieves	10	37	896	2	slieves
slimes	8	47	2204	2	slimes
slipes	8	49	2141	2	slipes
sliver	9	41	1659	2	sliver
slivers	10	41	1525	2	slivers
smiles	8	45	2229	2	smiles
smites	8	39	2192	2	smites
snipes	8	39	1739	2	snipes
snivel	9	36	885	2	snivel
snivels	10	33	690	2	snivels
soaves	9	42	1867	2	soaves
solves	9	50	1822	2	solves
spices	10	43	2603	2	spices
spies	7	60	3762	2	spi_es
spikes	12	45	2071	2	spikes
spiles	8	42	2791	2	spiles
spines	8	51	3203	2	spines
spires	8	46	2811	2	spires
spites	8	41	2733	2	spites
spivs	10	51	1424	2	spiv_s
staves	9	45	2519	2	staves
sties	5	51	3298	2	sti_es
stiles	6	43	2877	2	stiles
stimes	8	59	2057	2	stimes
stipes	8	45	2405	2	stipes
stiver	9	39	1573	2	stiver
stivers	10	36	1354	2	stivers
stoves	9	38	1892	2	stoves
strives	10	41	1937	2	strives
suites	6	37	2740	2	suites
swipes	11	41	1433	2	swipes
swive	11	53	1619	2	swive_
swived	13	36	1063	2	swived
swivel	12	36	932	2	swivel
swivels	13	39	677	2	swivels
swivet	12	36	1547	2	swivet
swivets	13	43	696	2	swivets
thieves	13	4	690	2	thieves
thrives	13	46	1171	2	thrives
waives	12	37	1418	2	waives
whiles	12	44	1801	2	whiles
whines	12	51	2010	2	whines
whites	12	39	1988	2	whites
wives	11	53	2892	2	_wives

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.343	520965.0
2	DLD Change Limit	82551	182	2.580	31996.5
3	Display Results	182	182	0.046	3956.5
	(SQL Overall)	178691	182	2.969	60185.6