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

114 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
donative1213987(None) 
conative131214621conative
donatives13146901donatives
dative10311812d__ative
denotive1238672denotive
detonative1447132detonative
dilative1239522dilative
dominative1677392dominative
donate73619502donat__e
donating10311802donating
donation91513782donation
durative1239072durative
locative1338682locative
monitive1349992monitive
native9613012__native
nonactive1448972nonactive
nonnative1248342nonnative
rotative11310342rotative
sanative11310472sanative
sonatine8313322sonatine
vocative1637912vocative
ablative1348243ablative
adoptive1445503ado_ptive
advocative1943963advocative
amative12311733_amative
coactive1598623coactive
cognitive1545483cognitive
combative1847213combative
conation101420883conation
conceive1539233conceive
connive1238993con_nive
constative15410103constative
contrive13311353contrive
costive12312843co_stive
creative132812803creative
curative13310403curative
datives11310073d__atives
decorative1648923decorative
denature938073denature
denotative1456723denotative
dentine83320243den_tine
derogative1546983derogative
deviative1647733deviative
dilutive1255383dilutive
doating93816863do_ating
dogmatize2265763dogmatize
domaine10610503doma_ine
donated93513863donat_ed
donates83217223donat_es
donations101112353donations
donator8310263donat_or
donators9310403donators
donsie7613643don_si_e
dopamine1346173dopamine
dotation91412733dotation
downtime1444753downtime
duratives1346223duratives
dynamite1444813dynamite
educative15136553educative
elative10312453_elative
emanative1447313emanative
enactive1338513_enactive
ergative1238973ergative
evocative1746293evocative
fixative2145083fixative
formative1747963formative
genitive1247643genitive
hortative1546433hortative
ideative1238573ideative
illative1147183illative
inactive1348203_inactive
laxative1845093laxative
lenitive1148493lenitive
ligative1258803ligative
locatives1446563locatives
longtime1144363longtime
monazite1957083monazite
monetise10311473monetise
monetize1949983monetize
motive113112143mo__tive
mutative1348283mutative
naive85116213__na_ive
natives10310823__natives
negative1239083negative
nominative1597683nominative
nonnatives1345643nonnatives
normative1448893normative
odonate848403odonat__e
onetime937623_onetime
optative1347653optative
pontine92419053pon_tine
portative1449373portative
positive1349993positive
probative1649173probative
punitive1346833punitive
putative1348373putative
relative11313143relative
sedative1238853sedative
sonatina849073sonatina
sorptive1346473sorptive
stative102612933_stative
tentative1247813tentative
tontine72316143ton_tine
unitive10310563_unitive
urinative1247653urinative
violative1545113violative
vocatives1745883vocatives
volatile1146433volatile
volitive1446893volitive
vomitive1645853vomitive
votive12348933vo__tive
zonate154114923zonat__e
zonation171410723zonation
zonetime1944953zonetime

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.423422437.4
2DLD Change Limit1461621147.90618487.5
3Display Results1141140.0462478.3
 (SQL Overall)1786911148.37521336.2
 
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.