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

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

65 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
explanative235310(None) 
explanation2045262explanation
explanatively2861822explanatively
explicative2554452explicative
explorative2354242explorative
emanative1447313e__manative
exhilarative2561743exhilarative
expansive2144393exp_an_sive
expectative2553583expectative
explanations2144623explanations
explanatory2352603explanatory
explantation2153973explantation
explanting2045223explan_ting
expletive2144443expl__etive
exploitative2452593exploitative
exploitive2253463expl_oitive
placative1646223__placative
aplanatic1344904_aplanati_c
applicative2074714applicative
declarative1754314declarative
duplicative1954174duplicative
eglantine1044974e_glan_tine
elative10312454e__l__ative
eliminative1654364eliminative
emulative1447454emul__ative
esplanade12111924esplana__de
euthanatize2352174euthanatize
evaluative1644234eval_uative
exaptive2045254ex__a_ptive
excitative2245024ex_citative
exclamation22104634exclamation
execrative2246044ex_ecrative
exfoliative2452484exfoliative
exhaustive2352344ex_haustive
exhortative2453054exhortative
exonerative2155394exonerative
expansile1843944exp_an_sile
expensive2145844exp_en_sive
explainable2252524explaina_ble
explanatorily2561054explanatorily
explant16310134explan_t___
explantations2253644explantations
explanted1944974explan_t_ed
explants1737024explan_t__s
expletives2243354expl__etives
explicate20117494explicat__e
explicating2356124explicating
explication2248454explication
explicatively30102564explicatively
exploration2066714exploration
exploratively2862424exploratively
explosive2144834expl__osive
expositive2254514exp_ositive
extinctive2253454ex_tinctive
extractive2246604extra_ctive
exudative2044894ex__udative
implicative2054664implicative
laxative1845094___laxative
plaintive1444624__plaintive
planate9314574__planat__e
planation11310124__planation
reparative1548174rep_arative
replicative1846084replicative
sanative11310474___sanative
separative1546974sep_arative

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 Limit148819658.68617133.2
3Display Results65650.0461413.0
 (SQL Overall)178691659.15519518.4
 
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.