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 “noncreative” 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.

119 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
noncreative164823(None) 
nonreactive1645952non_reactive
nonrelative1456832non_relative
uncreative1547532_uncreative
anticreative1755043anticreative
conceptive1949513conc_eptive
concretize23166713concre_tize
creative132812803___creative
noncoercive1854393noncoercive
noncombative2154443noncombative
noncreativity2162713noncreativity
nondirective1854683nondirective
nonelective1666853nonelective
nonnarrative1553833nonnarrative
nonnative1248343non__native
nonnegative1555173nonnegative
nonnormative1754863nonnormative
nonoperative1756283nonoperative
nonrelatives1564203non_relatives
normative1448893no__rmative
nuncupative1853103nuncupative
procreative1846313procreative
recreative1549023_recreative
accretive1645094_accre_tive
cocreate122611814co_creat__e
cocreating15310294co_creating
conative131214624con___ative
conceive1539234conc_e__ive
concertize23169354conc_ertize
concessive1745824conc_essive
conciliative1954164conciliative
concoctive1646804conc_octive
concrete12411084concre_t__e
concreting1539874concre_ting
concretion1449294concre_tion
concretism1655454concre_tism
concretist1448194concre_tist
concretized25174674concre_tized
concretizes24166004concre_tizes
confutative1955444confutative
congestive1647614con_gestive
connective1749254con_nective
connotative1665384connotative
consecrative1957314consecr_ative
conservative20106994conservative
constative15410104con_stative
contractive1849524contractive
contrastive1647294contrastive
convective2049114con_vective
cooperative1847054cooperative
corrective1747444co_rrective
correlative1645544co_rrelative
creatine103417414___creatine
creatives14279694___creatives
cunctative1744504cunc_tative
decretive1547494_decre_tive
donative12139874don___ative
excretive2145144_excre_tive
execrative2246044execr_ative
exonerative2155394exoner_ative
formative1747964fo__rmative
generative1458574gener_ative
hortative1546434ho__rtative
incentive1489604_inc_entive
inceptive1677844_inc_eptive
inchoative1854044_inchoative
increate10312204_increat__e
incubative1745584_incubative
inoculative1655254ino_culative
inoperative1646754inoper_ative
lacerative1556284_lacerative
locative1338684lo_c__ative
lucrative1445864_lucr_ative
narrative1247374__narrative
nociceptive2052204nociceptive
nominative1597684no_minative
nonabrasive1652574nonabrasive
nonactive1448974non__active
nonadaptive1753104nonadaptive
nonadditive1683534nonadditive
nonassertive1553464nonassertive
nonbreathing1852104nonbreathing
noncognitive1863764noncognitive
noncooperative21113474noncooperative
noncorrosive1762774noncorrosive
noncreativities2082764noncreativities
noncredit1265574noncre_di_t
noncrime12116604noncr___ime
noncumulative2062544noncumulative
nondeceptive2053734nondeceptive
nonderivative2063514nonderivative
noneffective2363584noneffective
nonexecutive2452874nonexecutive
nonimitative1784544nonimitative
noninfective2054584noninfective
noninvasive1772454noninvasive
nonnatives1345644non__natives
nonobjective2663544nonobjective
nonpunitive1654774nonpunitive
nonreading1246884non_reading
nonroutine1066014non_routine
nonselective1755414nonselective
nonvolatile1453174nonvolatile
ocreate93711744_o_creat__e
operative141110554_oper_ative
orective1339354_o__rective
pancreatic1653974pancreati_c
pancreatin1454234pancreati_n
pancreatins1553844pancreatins
portative1449374po__rtative
secretive1446934_secre_tive
syncopative2163134syncopative
syncretise1554384syncre_tise
syncretize2454144syncre_tize
tolerative1346254toler_ative
ulcerative1545174_ulcerative
uncreate10311354_uncreat__e
uncreating13310474_uncreating
vocative1637914vo_c__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.423422437.4
2DLD Change Limit1488191199.21616147.9
3Display Results1191190.0631888.9
 (SQL Overall)1786911199.70218418.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.