Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
correlative164554(None) 
correlatives1753901correlatives
corrective1747442corre_ctive
correlate1149042correlat__e
correlating1487082correlating
correlation1358552correlation
correlatively2153212correlatively
irrelative1344782_irrelative
nonrelative1456832nonrelative
circulative1855563circulative
cooperative1847053cooperative
copulative1747293co_pulative
corelate10516013co_relat__e
corelating13511583co_relating
corporative1847153corporative
corrasive1445063corr__asive
correctives1845573corre_ctives
correlatable1652543correlatable
correlated1346683correlat_ed
correlates1248673correlat_es
correlations1447863correlations
correlator1245693correlat_or
correlators1345593correlators
corruptive1754393corr_uptive
creative132812803c__re_ative
nonrelatives1564203nonrelatives
relative11313143___relative
aggregative1753364aggregative
arrestive1246754_arre_stive
carminative1844894carminative
cocreate122611814cocre_at__e
cocreating15310294cocre_ating
cogitative1645934co_gitative
collective1747124colle_ctive
colligative1754354colligative
combative1847214co__mbative
combinative2055134combinative
commutative2055844commutative
comparative20176214comparative
compensative2154654compensative
competitive2074764competitive
completive1946234co_mpletive
conative131214624co___native
conceptive1949514conce_ptive
conciliative1954164conciliative
confutative1955444confutative
congelation14410344congelation
congestive1647614conge_stive
connective1749254conne_ctive
connotative1665384connotative
consecrative1957314consecrative
consecutive1855954consecutive
conservative20106994conservative
constative15410104co_nstative
consultative1754784consultative
consultive1546674consul_tive
contemplative22123704contemplative
convective2049114conve_ctive
cooperatives1965554cooperatives
coordinative1853084coordinative
copulatives1844874co_pulatives
corelated12411824co_relat_ed
corelates11314864co_relat_es
corollate1148124corollat__e
correctable1745234correctable
correcting15199304corre_cting
correction1448814corre_ction
correctively2254864corre_ctively
correlational15113674correlational
corroborative2062104corroborative
corrosive1445234corr__osive
corrugate1255484corrugat__e
corrugating1544264corrugating
corrugation1445994corrugation
corselette1253484corselet_te
creatine103417414c__re_atine
creatives14279694c__re_atives
cumulative1744564c_umulative
curative13310404c_ur__ative
elative10312454____elative
forgetive16124464forge__tive
formative1747964fo_r_mative
hortative1546434ho_r_tative
irrelatively1853904_irrelatively
irritative1345204_irritative
narrative1247374narr__ative
noncreative1648234noncre_ative
nonnegative1555174nonnegative
nonreactive1645954nonreactive
normative1448894no_r_mative
operative141110554_o_perative
orective1339354_o_re_ctive
permeative1748524perme_ative
portative1449374po_r_tative
precative16312574__precative
procreative1846314procre_ative
recreative1549024recre_ative
relatives1239964___relatives
segregative1654064segregative
sporulative1653744sporulative
superlative1648254superlative
tolerative1346254to_lerative
uncreative1547534uncre_ative

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.456391866.2
2DLD Change Limit1488191038.95016627.8
3Display Results1031030.0502060.0
 (SQL Overall)1786911039.45618897.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.