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

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

147 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
fixing	17	48	1378	(None)
faxing	17	51	1705	1	faxing
fifing	13	42	1234	1	fifing
filing	10	38	2376	1	filing
fining	10	42	2321	1	fining
firing	10	40	2172	1	firing
fixings	18	34	744	1	fixings
foxing	17	50	1243	1	foxing
mixing	16	47	1394	1	mixing
nixing	14	33	1149	1	nixing
affixing	22	6	433	2	affixing
aiding	8	44	2361	2	aiding
ailing	7	43	3101	2	ailing
aiming	9	43	2084	2	aiming
airing	7	49	2750	2	airing
axing	13	85	2137	2	_axing
biding	10	47	2079	2	biding
biking	13	50	1817	2	biking
biting	9	53	2182	2	biting
boxing	16	39	1515	2	boxing
citing	9	42	2018	2	citing
coxing	16	42	1886	2	coxing
dicing	10	57	1876	2	dicing
dieing	8	40	1865	2	dieing
diking	12	43	2024	2	diking
dining	8	45	2513	2	dining
diving	11	37	1795	2	diving
exing	13	60	1681	2	_exing
facing	12	53	2157	2	facing
fading	11	48	2111	2	fading
failing	11	35	2133	2	failing
fairing	11	36	1401	2	fairing
faking	14	55	2098	2	faking
faming	12	49	2297	2	faming
faring	10	52	3128	2	faring
fating	10	53	2867	2	fating
faying	13	45	2107	2	faying
fazing	19	44	1864	2	fazing
feeing	10	44	1650	2	feeing
feting	10	44	1779	2	feting
feuing	10	44	1227	2	feuing
fibbing	15	33	946	2	fibbing
ficin	10	35	1672	2	ficin_
ficins	11	35	1398	2	ficins
fidging	13	39	1050	2	fidging
figging	13	33	1356	2	figging
filings	11	52	1307	2	filings
filling	11	35	2080	2	filling
filming	13	32	1035	2	filming
finding	12	41	1654	2	finding
finings	11	43	1177	2	finings
finking	15	40	1660	2	finking
finning	11	36	1511	2	finning
firings	11	41	1233	2	firings
firming	13	28	1122	2	firming
fishing	14	39	1386	2	fishing
fisting	11	38	1812	2	fisting
fitting	11	35	1656	2	fitting
fixating	19	3	618	2	fixating
fixit	15	48	1930	2	fixi_t
fixity	19	42	780	2	fixity
fizzing	19	27	640	2	fizzing
flexing	18	35	899	2	flexing
fling	9	70	2351	2	f_ling
fliting	11	35	1461	2	fliting
fluxing	18	39	892	2	fluxing
flying	13	46	1215	2	flying
foiling	11	33	1765	2	foiling
foining	11	30	1345	2	foining
foxings	18	44	696	2	foxings
frizing	20	33	1087	2	frizing
frying	13	45	1140	2	frying
fuming	12	40	1329	2	fuming
fusing	10	44	1595	2	fusing
fuzing	19	41	1064	2	fuzing
gibing	10	37	1235	2	gibing
gieing	8	36	1485	2	gieing
giving	11	43	1388	2	giving
hexing	17	42	1051	2	hexing
hiding	11	43	1933	2	hiding
hieing	10	42	1662	2	hieing
hiking	14	36	1710	2	hiking
hiring	10	44	2160	2	hiring
hiving	13	41	1552	2	hiving
icing	8	60	1775	2	_icing
infixing	19	3	610	2	infixing
iring	6	60	2542	2	_iring
jibing	16	37	962	2	jibing
jinxing	22	30	650	2	jinxing
jiving	17	37	1160	2	jiving
kiting	11	41	1709	2	kiting
liking	11	43	1958	2	liking
liming	9	40	2124	2	liming
lining	7	45	2680	2	lining
living	10	43	1832	2	living
loxing	14	36	1527	2	loxing
maxing	16	48	1707	2	maxing
miking	13	42	1846	2	miking
miming	11	43	1726	2	miming
mining	9	42	2545	2	mining
miring	9	37	2380	2	miring
niding	8	32	1798	2	niding
oiling	7	49	2531	2	oiling
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
poxing	16	37	1494	2	poxing
raxing	14	43	2102	2	raxing
refixing	19	32	979	2	refixing
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
riving	10	45	2142	2	riving
sexing	14	43	1389	2	sexing
siding	8	38	2213	2	siding
siping	9	42	2063	2	siping
siring	7	51	2831	2	siring
siting	7	41	2662	2	siting
sizing	16	36	1644	2	sizing
taxing	14	38	1671	2	taxing
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
unfixing	19	3	568	2	unfixing
vexing	17	47	917	2	vexing
vicing	12	40	1424	2	vicing
viking	14	34	1461	2	viking
vining	10	46	1946	2	vining
vising	10	39	1587	2	vising
waxing	17	42	1528	2	waxing
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
wiving	13	33	1660	2	wiving

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.326	548131.9
2	DLD Change Limit	82551	147	2.483	33246.5
3	Display Results	147	147	0.046	3195.7
	(SQL Overall)	178691	147	2.855	62588.8