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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

80 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
shipway	18	4	421	(None)
shipways	19	4	407	1	shipways
slipway	15	4	387	1	slipway
shiplap	14	4	451	2	shiplap
shipman	14	24	713	2	shipman
skidway	18	4	308	2	skidway
slipways	16	4	346	2	slipways
whipray	18	4	340	2	whipray
airway	12	3	769	3	_airway
chinwag	16	4	355	3	chinwag
chippy	18	43	761	3	chip_py
fairway	16	4	433	3	fairway
highway	20	4	426	3	_highway
hiply	13	41	1361	3	_hip_ly
hippy	15	51	1279	3	_hip_py
midway	15	32	715	3	_midway
oilway	12	3	574	3	_oilway
railway	13	4	531	3	railway
sahiwal	13	4	444	3	sahi_wal
seaway	12	30	999	3	s_eaway
shapely	15	3	689	3	shapely
shay	10	71	3334	3	sh___ay
shibah	14	38	747	3	shi_bah
shifty	15	40	926	3	shi_fty
shikar	13	3	680	3	shi_kar
shiksa	13	9	465	3	shiksa_
shiksas	14	8	464	3	shiksas
shily	11	52	2201	3	shi__ly
shimmy	16	30	641	3	shi_mmy
shindy	13	44	932	3	shi_ndy
shingly	14	32	1081	3	shingly
shinily	13	26	893	3	shinily
shinney	13	36	829	3	shinney
shinny	12	48	1078	3	shi_nny
shiny	11	51	2214	3	shi__ny
ship	9	52	2824	3	ship___
shiplaps	15	4	436	3	shiplaps
shipload	14	6	434	3	shipload
shipmate	15	4	615	3	shipmate
shipmen	14	31	728	3	shipmen
shipped	15	33	1210	3	shipped
shippen	14	29	886	3	shippen
shipper	14	35	1404	3	shipper
shippon	14	28	580	3	shippon
ships	10	51	2377	3	ship__s
shipworm	18	4	379	3	shipworm
shipyard	17	4	334	3	shipyard
shirty	12	43	1256	3	shi_rty
shittah	13	8	515	3	shittah
shitty	12	41	1006	3	shi_tty
shiva	11	59	1500	3	shi_va_
shivah	15	48	854	3	shi_vah
shivas	12	45	1241	3	shi_vas
shivery	16	31	702	3	shivery
shopboy	17	4	380	3	shopboy
shophar	15	5	546	3	shophar
shopman	14	24	726	3	shopman
showy	14	57	1401	3	sh_ow_y
shwa	10	60	1496	3	sh__wa_
shwas	11	64	1510	3	sh__was
sideway	14	4	567	3	sideway
skidways	19	4	282	3	skidways
skyway	19	3	334	3	s_kyway
slideway	15	4	316	3	slideway
slippy	13	7	584	3	slip_py
slipware	13	4	454	3	slipware
snippy	13	7	484	3	snip_py
someway	15	4	561	3	someway
spay	9	66	3166	3	s__p_ay
spillway	16	4	276	3	spillway
splay	10	58	1604	3	s__play
spray	10	67	2006	3	s__pray
stairway	14	6	292	3	stairway
subway	14	4	707	3	s_ubway
sway	10	71	2823	3	s___way
thisaway	17	4	275	3	thisaway
thruway	16	4	316	3	thruway
whippy	19	38	584	3	whip_py
whiprays	19	4	250	3	whiprays
whipsaw	18	4	272	3	whipsaw

Search took 7 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	134027	0.390	458182.1
2	DLD Change Limit	134027	80	6.390	20974.5
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	6.813	26227.9