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

60 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
tentative124781(None) 
tentatives1345481tentatives
denotative1456722denotative
gestative1347302gestative
tentatively1754342tentatively
agitative1346873agitative
annotative1345033annotative
conative131214623con_ative
constative15410103constative
cunctative1744503cunctative
denotive1238673den_otive
dentate8315153dentat__e
dentation10315243dentation
deviative1647723deviative
donative12139873don_ative
elative10312453_e_lative
enactive1338513_enactive
enstatite946193_enstatite
ergative1238973_ergative
generative1458563generative
genitive1247643gen_itive
gustative1345683gustative
hortative1546433hortative
imitative1446333imitative
iterative12410713ite_rative
lenitive1148493len_itive
mediative1548123mediative
meditative1646283meditative
mentation11313983mentation
mutative1348283_mutative
native9613013__n_ative
negative1239083ne_gative
nonnative1248343nonnative
optative1347653_optative
penetrative1646113penetrative
portative1449373portative
putative1348373_putative
recitative1548183recitative
relative11313143re_lative
renovative1645433renovative
rotative11310343_rotative
sanative11310473san_ative
sedative1238853se_dative
sensitive1246963sensitive
stative102612933__stative
sustentative15133103sustentative
talkative1644303talkative
tantalise91210823tantalise
tantalite91010863tantalite
tantalize181010573tantalize
teatime9310083te__atime
tensive10269913ten__sive
tentacle1037693tenta_cle
tentage81010643tenta__ge
tentie62521183ten__ti_e
tentlike1236903tent_like
testate73916233testat__e
tetanise8610203te_tanise
tetanize17109953te_tanize
vegetative1744573vegetative

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 Filter1786911486410.420425454.8
2DLD Change Limit148641607.37620152.0
3Display Results60600.0302000.0
 (SQL Overall)178691607.82622833.0
 
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.