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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
putative134837(None) 
mutative1348281mutative
curative13310402curative
durative1239072durative
gustative1345682gustative
imputative1744482imputative
optative1347652optative
portative1449372portative
pulsative1455172pulsative
punitive1346832punitive
purgative1545282purgative
putatively1845062putatively
puttie84116302put_ti_e
rotative11310342rotative
stative102612932_stative
ablative1348243ablative
agitative1346873agitative
amative12311733_amative
astatine8313533astatine
auditive1247163auditive
causative1445833causative
conative131214623conative
copulative1747293copulative
creative132812803creative
cunctative1744503cunctative
curatives1437823curatives
dative10311813__dative
dilative1239523dilative
donative12139873donative
duratives1346223duratives
educative15136553educative
elative10312453_elative
emulative1447453emulative
ergative1238973ergative
exudative2044893exudative
fixative2145083fixative
fugitive1544173fugitive
furtive1337173fu_rtive
gestative1347303gestative
hortative1546433hortative
ideative1238573ideative
illative1147183illative
imitative1446333imitative
laudative1344753laudative
laxative1845093laxative
ligative1258803ligative
locative1338683locative
lucrative1445863lucrative
mutate83017483mutat__e
mutating112211753mutating
mutation101412883mutation
native9613013__native
negative1239083negative
nutate63017373nutat__e
nutating92411953nutating
nutation81513103nutation
nutritive1245333nutritive
operative141110553operative
optatives1445203optatives
outate62923403outat__e
outdrive1236893outdrive
outgive11199253out_give
outlive102513033out_live
outstrive1265083outstrive
palatine10316073palatine
partitive1447373partitive
patine85328123p__atine
pattie84020963pat_ti_e
petaline10314883petaline
placative1646223placative
positive1349993positive
potation101716783potation
precative16312573precative
privative17188293privative
proactive1648363proactive
probative1649173probative
pulsatile1173393pulsatile
pupate104213123pupat__e
pupating1337683pupating
pupation1269503pupation
purgatives1643743purgatives
putamina1244543putamina
puttee85919723put_t_ee
putti76018743put_ti__
puttied103811163put_tied
puttier93314503put_tier
putties94420023put_ties
putting103218573put_ting
relative11313143relative
sanative11310473sanative
sedative1238853sedative
statice92614033_statice
statives112710793_statives
suasive1037853su_asive
summative1646203summative
tentative1247813tentative
unitive10310563_unitive
vocative1637913vocative

Search took 8 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.436409841.7
2DLD Change Limit146162987.37619815.9
3Display Results98980.0462130.4
 (SQL Overall)178691987.85822740.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.