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

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

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.

90 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
compromises	19	5	418	(None)
compromise	18	5	417	1	compromise_
compromised	20	5	277	1	compromised
compromiser	19	5	262	1	compromiser
compromisers	20	5	195	1	compromisers
comprises	15	5	1094	2	compr__ises
composes	14	50	1711	3	comp_o__ses
composites	16	4	890	3	comp_osites
compresses	16	4	777	3	compr_esses
comprise	14	3	1081	3	compr__ise_
comprised	16	4	805	3	compr__ised
comprizes	24	6	894	3	compr__izes
compromising	21	5	292	3	compromising
coprolites	14	4	822	3	co_prolites
improvises	17	8	459	3	_improvises
outpromises	15	5	225	3	outpromises
promises	12	29	1676	3	___promises
camomiles	15	15	563	4	cam__omiles
chromides	17	4	760	4	c__hromides
chromites	16	3	1096	4	c__hromites
chromizes	25	4	760	4	c__hromizes
colonises	11	28	1401	4	co__lonises
colotomies	14	4	706	4	colotomi_es
colpitises	14	4	574	4	colp_itises
commies	13	37	1845	4	com___mi_es
commixes	21	7	735	4	com___mixes
communises	16	4	656	4	com_munises
companies	15	3	1180	4	comp_ani_es
comparatists	18	5	373	4	comparatists
comparatives	21	16	485	4	comparatives
compasses	15	4	739	4	comp__asses
compiles	14	3	1198	4	comp___iles
complices	17	3	925	4	comp__lices
complies	14	3	1452	4	comp__li_es
complines	15	3	1283	4	comp__lines
compose	13	57	1666	4	comp_o__se_
composed	15	46	1206	4	comp_o__sed
composer	14	50	1295	4	comp_o__ser
composers	15	39	1062	4	comp_o__sers
composite	15	4	1015	4	comp_osite_
composited	17	5	600	4	comp_osited
composts	14	42	1091	4	comp_o__sts
composures	16	4	513	4	comp_osures
compotes	14	47	1651	4	comp_o__tes
compradores	18	5	260	4	compradores
compress	14	3	905	4	compr__es_s
compressed	17	4	584	4	compr_essed
comprisal	15	4	451	4	compr__isal
comprisals	16	4	370	4	compr__isals
comprize	23	6	873	4	compr__ize_
comprized	25	6	722	4	compr__ized
computerises	18	22	497	4	computerises
computists	16	4	469	4	comp_utists
conformisms	20	5	300	4	conformisms
conformists	18	5	418	4	conformists
copremias	15	4	513	4	co_premi_as
coproduces	17	6	372	4	co_produces
coprolite	13	4	862	4	co_prolite_
copromoter	16	4	457	4	co_promoter
copromoters	17	5	398	4	co_promoters
corodies	11	3	1369	4	co__rodi_es
corrodies	12	4	790	4	co_rrodi_es
corrosives	15	4	447	4	co_rrosives
cosmopolises	18	7	284	4	cosmopolises
customises	14	4	480	4	c_ustomises
economises	14	4	656	4	eco__nomises
emprises	12	3	1100	4	_empr__ises
gomphoses	17	4	583	4	gompho__ses
improvise	16	7	485	4	_improvise_
improvised	18	7	356	4	_improvised
improviser	17	7	331	4	_improviser
improvisers	18	9	277	4	_improvisers
lobotomises	15	5	314	4	lobotomises
nonprosses	12	4	464	4	nonpro_sses
optimises	13	4	608	4	_o_ptimises
outpromise	14	4	266	4	outpromise_
outpromised	16	5	198	4	outpromised
overpromises	19	5	424	4	overpromises
pogromists	15	4	361	4	po_gromists
porpoises	13	4	843	4	porp_o_ises
premises	12	30	1827	4	___premises
promines	12	30	1880	4	___promines
promise	11	34	1584	4	___promise_
promised	13	30	1087	4	___promised
promisee	12	27	1133	4	___promisee
promisees	13	24	686	4	___promisees
promiser	12	25	1067	4	___promiser
promisers	13	26	820	4	___promisers
sorosises	9	4	730	4	so__rosises
temporises	14	4	724	4	temp_orises

Search took 10 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	148819	0.156	1145455.1
2	DLD Change Limit	148819	90	9.406	15821.7
3	Display Results	90	90	0.046	1956.5
	(SQL Overall)	178691	90	9.608	18598.1