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 “creative” with Change Limit: [1] [2] [3]

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

176 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
creative13281280(None) 
creatine103417411creatine
creatives14279691creatives
conative131214622conative
create85126382creat__e
creatin93618132creati_n
creatines112814432creatines
creating113921952creating
creatins103617512creatins
creation102816512creation
creatively1846672creatively
creature1038742creature
crescive1545282crescive
curative13310402curative
erective13311832erective
ergative1238972ergative
ideative1238572ideative
orective1339352orective
precative16312572precative
reactive13310472_reactive
recreative1549022recreative
relative11313142_relative
restive10315932_restive
treatise8311102treatise
uncreative1547532uncreative
ablative1348243ablative
acceptive1845073acceptive
accretive1645093accre_tive
agentive1248043agentive
amative12311733_amative
arrestive1246753arrestive
breathe123711843breat_he
calmative1647033calmative
captive1438973c_aptive
caressive1445823caressive
causative1445833causative
cavatine13310323cavatine
centile94217183c_entile
centime114513033c_entime
ceramide1347973ceramide
cerate84829463cerat__e
ceratin93020163cerati_n
ceratins102818733ceratins
cheapie1437563cheapi_e
cheating144014523cheating
cleating113518143cleating
cleave114212513clea__ve
coactive1598623coactive
coercive1545873coercive
combative1847213combative
corrasive1445063corrasive
corrective1747443corrective
correlative1645543correlative
costive12312843c_ostive
crate76537403cr_at__e
crating103725203cr_ating
crave105626313cr_a__ve
creakier14328333creakier
creakily1735393creakily
creaking153414123creaking
creamier12319063creamier
creamily1536363creamily
creaming133413143creaming
crease85519573crea__se
creasier103210203creasier
creasing113314443creasing
creatable1339563creatable
created104323453creat_ed
creates95225203creat_es
creatinine1245073creatinine
creations112614543creations
creativity1845173creativity
creator93714443creat_or
creators102814413creators
creatures1138423creatures
creepie1137483creepi_e
cremate113816183cremat__e
cremating14312203cremating
cremation13511643cremation
crenate93317113crenat__e
crenation11412923crenation
crenature1145763crenature
creolise1037863creolise
creolize1947183creolize
cresting114017043cresting
cretic102816283cre_ti_c
cretics112911653cre_tics
cretin82917913cre_ti_n
cretins93216423cre_tins
crevice1436153cre_vice
curatives1437823curatives
dative10311813__dative
decretive1547493decre_tive
dilative1239523dilative
directive1557773directive
donative12139873donative
dreamtime1442343dreamtime
durative1239073durative
egestive1246833egestive
ejective2037153ejective
elative10312453_elative
elective13311003elective
erectile1039513erectile
ergatives1346443ergatives
eruptive1345793eruptive
excretive2145143excre_tive
exertive1839083exertive
festive1339773_festive
fixative2145083fixative
formative1747963formative
fricative1746743fricative
gratine84719193gr_atine
greave104611493grea__ve
hortative1546433hortative
illative1147183illative
irrelative1344783irrelative
iterative12410713iterative
lacerative1556283lacerative
laxative1845093laxative
ligative1258803ligative
locative1338683locative
lucrative1445863lucr_ative
mutative1348283mutative
narrative1247373narrative
native9613013__native
negative1239083negative
noncreative1648233noncreative
normative1448893normative
ocreate93711743ocreat__e
operative141110553operative
optative1347653optative
permeative1748523permeative
portative1449373portative
predive13511083pre_dive
prentice121012353prentice
prestige11310733prestige
privative17188293privative
proactive1648363proactive
probative1649173probative
procreative1846313procreative
purgative1545283purgative
putative1348373putative
ratine65131823_r_atine
ratite65022423_r_atite
realise73021813_realise
realize162717083_realize
reave84528023_rea__ve
receive1239733_receive
redrive112410563_redrive
regive104814323_re_give
reive85522943_re__ive
relatives1239963_relatives
relive95120783_re_live
reptile93914083_reptile
restrive11310923_restrive
retie55735303_re_ti_e
retile65929673_re_tile
retime85321803_re_time
retine66237333_re_tine
retire64927013_re_tire
revive124914823_re_vive
rotative11310343rotative
sanative11310473sanative
secretive1446933secre_tive
sedative1238853sedative
stative102612933_stative
steatite8310583steatite
teatime9310083_teatime
tractive13310043tractive
treaties8316983treaties
treating92519613treating
treatises9310373treatises
ulcerative1545173ulcerative
urinative1247653urinative
vocative1637913vocative
wreathe13339053wreat_he

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621767.72018932.9
3Display Results1761760.0762315.8
 (SQL Overall)1786911768.20221786.3
 
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.