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

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

158 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
diving	11	37	1795	(None)
dicing	10	57	1876	1	dicing
dieing	8	40	1865	1	dieing
diking	12	43	2024	1	diking
dining	8	45	2513	1	dining
divine	10	35	1446	1	divine
driving	12	39	1071	1	driving
giving	11	43	1388	1	giving
hiving	13	41	1552	1	hiving
jiving	17	37	1160	1	jiving
living	10	43	1832	1	living
riving	10	45	2142	1	riving
wiving	13	33	1660	1	wiving
aiding	8	44	2361	2	aiding
ailing	7	43	3101	2	ailing
aiming	9	43	2084	2	aiming
airing	7	49	2750	2	airing
biding	10	47	2079	2	biding
biking	13	50	1817	2	biking
biting	9	53	2182	2	biting
caving	12	48	2261	2	caving
citing	9	42	2018	2	citing
coving	12	43	2152	2	coving
daring	8	49	2868	2	daring
dating	8	53	2648	2	dating
dawing	11	48	1982	2	dawing
dazing	17	55	1651	2	dazing
deaving	12	38	1475	2	deaving
deicing	11	3	1219	2	deicing
deking	12	56	1455	2	deking
delving	12	37	1157	2	delving
deriving	13	25	1074	2	deriving
dewing	11	41	1570	2	dewing
dialing	9	43	1817	2	dialing
dibbing	13	31	1089	2	dibbing
dicking	15	36	1761	2	dicking
dieting	9	36	1683	2	dieting
digging	11	35	1370	2	digging
dimming	13	33	959	2	dimming
ding	6	69	4095	2	d__ing
dinging	10	36	1861	2	dinging
dinking	13	36	1828	2	dinking
dinning	9	34	1655	2	dinning
dinting	9	35	2055	2	dinting
dipping	13	40	1483	2	dipping
dirking	13	38	1260	2	dirking
dirling	9	33	1607	2	dirling
discing	11	39	1459	2	discing
dishing	12	40	1710	2	dishing
disking	13	46	1549	2	disking
dissing	9	45	1768	2	dissing
divan	9	61	1484	2	divan_
divans	10	46	1239	2	divans
divide	11	34	1089	2	divide
dividing	14	3	718	2	dividing
divined	12	32	969	2	divined
diviner	11	36	988	2	diviner
divines	11	35	1472	2	divines
divining	13	3	841	2	divining
divvying	19	3	277	2	divvying
doing	7	49	2358	2	d_oing
doling	8	49	2313	2	doling
doming	10	42	1839	2	doming
doping	10	39	1946	2	doping
dosing	8	39	2027	2	dosing
doting	8	48	2191	2	doting
dowing	11	42	2151	2	dowing
dozing	17	42	1419	2	dozing
drivings	13	26	576	2	drivings
droving	12	37	968	2	droving
drying	11	34	1160	2	drying
duding	9	39	1332	2	duding
duking	12	47	1513	2	duking
duping	10	41	1363	2	duping
during	8	44	1940	2	during
dwining	12	26	929	2	dwining
dyeing	11	42	821	2	dyeing
dying	10	53	1603	2	d_ying
dyking	15	45	801	2	dyking
editing	9	3	1313	2	editing
fifing	13	42	1234	2	fifing
filing	10	38	2376	2	filing
fining	10	42	2321	2	fining
firing	10	40	2172	2	firing
fixing	17	48	1378	2	fixing
gibing	10	37	1235	2	gibing
gieing	8	36	1485	2	gieing
gyving	14	41	571	2	gyving
having	13	42	2037	2	having
hiding	11	43	1933	2	hiding
hieing	10	42	1662	2	hieing
hiking	14	36	1710	2	hiking
hiring	10	44	2160	2	hiring
icing	8	60	1775	2	_icing
idling	8	9	1288	2	idling
iring	6	60	2542	2	_iring
jibing	16	37	962	2	jibing
kiting	11	41	1709	2	kiting
laving	10	46	2357	2	laving
liking	11	43	1958	2	liking
liming	9	40	2124	2	liming
lining	7	45	2680	2	lining
livings	11	40	892	2	livings
loving	10	44	1672	2	loving
miking	13	42	1846	2	miking
miming	11	43	1726	2	miming
mining	9	42	2545	2	mining
miring	9	37	2380	2	miring
mixing	16	47	1394	2	mixing
moving	12	39	1328	2	moving
niding	8	32	1797	2	niding
nixing	14	33	1149	2	nixing
oiling	7	49	2531	2	oiling
paving	12	45	1974	2	paving
pieing	9	39	1765	2	pieing
piing	8	52	1883	2	pi_ing
piking	13	37	1964	2	piking
piling	9	50	2559	2	piling
pining	9	37	2653	2	pining
piping	11	40	1745	2	piping
raving	10	51	2885	2	raving
reiving	11	33	1684	2	reiving
ricing	9	48	2276	2	ricing
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
roving	10	36	1874	2	roving
saving	10	47	2451	2	saving
siding	8	38	2213	2	siding
sieving	11	23	1123	2	sieving
siping	9	42	2063	2	siping
siring	7	51	2831	2	siring
siting	7	41	2662	2	siting
sizing	16	36	1644	2	sizing
skiving	15	29	837	2	skiving
swiving	14	35	895	2	swiving
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
updiving	15	3	422	2	updiving
vicing	12	40	1424	2	vicing
viking	14	34	1461	2	viking
vining	10	46	1946	2	vining
vising	10	39	1587	2	vising
waiving	14	32	963	2	waiving
waving	13	40	1820	2	waving
wifing	13	35	1339	2	wifing
wiling	10	30	2429	2	wiling
wining	10	36	2505	2	wining
wiping	12	39	1671	2	wiping
wiring	10	45	2102	2	wiring
wising	10	33	1822	2	wising
witing	10	35	2282	2	witing

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	82551	0.313	570897.8
2	DLD Change Limit	82551	158	4.530	18223.2
3	Display Results	158	158	0.110	1436.4
	(SQL Overall)	178691	158	4.953	36077.3