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

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

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.

70 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
refixed	18	36	1115	(None)
prefixed	21	35	769	1	prefixed
refiled	11	43	1865	1	refiled
refined	11	47	2000	1	refined
refired	11	51	1699	1	refired
refixes	17	48	1317	1	refixes
remixed	17	35	1074	1	remixed
affixed	21	3	412	2	affixed
bemixed	19	33	705	2	bemixed
defied	11	50	1638	2	defi_ed
defiled	12	40	1310	2	defiled
defined	12	38	1382	2	defined
fixed	16	54	1695	2	__fixed
infixed	18	20	656	2	infixed
prefiled	14	33	1057	2	prefiled
prefired	14	43	1075	2	prefired
prefixes	20	38	923	2	prefixes
premixed	20	33	800	2	premixed
reaffixed	23	4	229	2	reaffixed
recited	10	43	1910	2	recited
refaced	13	37	1357	2	refaced
refed	9	39	2192	2	ref__ed
refeed	10	47	1762	2	ref_eed
reffed	13	47	1251	2	ref_fed
refile	9	51	2237	2	refile_
refiles	10	41	2242	2	refiles
refilled	12	27	867	2	refilled
refilmed	14	23	581	2	refilmed
refind	10	47	1707	2	refi_nd
refine	9	52	2569	2	refine_
refiner	10	53	1691	2	refiner
refines	10	54	2634	2	refines
refire	9	54	1947	2	refire_
refires	10	48	2031	2	refires
refitted	12	30	941	2	refitted
refix	15	52	1248	2	refix__
reflexed	19	7	524	2	reflexed
refluxed	19	5	434	2	refluxed
refried	11	35	1387	2	refried
refuged	12	54	1087	2	refuged
refused	11	51	1444	2	refused
refuted	11	43	1380	2	refuted
rehired	11	50	1315	2	rehired
reified	11	29	1378	2	reified
reined	7	44	2552	2	re_ined
reived	10	45	1813	2	re_ived
relaxed	15	33	1252	2	relaxed
relied	7	49	2623	2	reli_ed
relined	8	53	2193	2	relined
relived	11	51	1468	2	relived
remised	10	35	1684	2	remised
remixes	16	43	1387	2	remixes
reoiled	8	43	1685	2	reoiled
repined	10	49	1877	2	repined
resided	9	52	1770	2	resided
resiled	8	46	2198	2	resiled
resined	8	45	2265	2	resined
resited	8	51	2242	2	resited
resized	17	46	1490	2	resized
retaxed	15	35	1223	2	retaxed
retied	7	59	2498	2	reti_ed
retiled	8	44	2051	2	retiled
retimed	10	47	1465	2	retimed
retired	8	46	2014	2	retired
reviled	11	44	1792	2	reviled
revised	11	38	1548	2	revised
revived	14	42	1165	2	revived
rewaxed	18	40	934	2	rewaxed
rewired	11	54	1328	2	rewired
unfixed	18	21	856	2	unfixed

Search took 4 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	70	3.033	35499.8
3	Display Results	70	70	0.016	4375.0
	(SQL Overall)	178691	70	3.189	56033.6