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

102 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
enactive133851(None) 
inactive1348201inactive
active11313742__active
coactive1598622coactive
eductive1476862eductive
ejective2037152ejective
elative10312452ela_tive
elective13311002elective
enacting11311362enacting
erective13311832erective
exaptive2045252exaptive
native9613012_na_tive
nonactive1448972nonactive
reactive13310472reactive
tractive13310042tractive
actives12311523__actives
adaptive1445133adaptive
amative12311733ama_tive
bioactive1644133bioactive
captive1438973_captive
conative131214623cona_tive
dative10311813_da_tive
decoctive1745863decoctive
deductive1645473deductive
defective1848003defective
denotive1238673den_otive
detective1548103detective
detractive1647373detractive
donative12139873dona_tive
educative15136553educative
effective2076193effective
egestive1246833egestive
ejectives2145443ejectives
elatives1139783ela_tives
electives1448923electives
emanative1447313emanative
emotive1239193e_motive
enact73525363enact___
enactable1338493enactable
enacted10310643enact_ed
enactor938033enact_or
enactors1038453enactors
enactory1346143enactory
enacts84012973enact__s
enamine91214313ena_mine
enate54428143ena_t__e
enatic8317563ena_ti_c
enation73419233ena_tion
enclave1257533en_clave
endive103310473en__dive
enhancive1752693enhancive
entice81316863en__tice
entire61617703en__tire
erectile1039513erectile
ergative1238973ergative
eruptive1345793eruptive
evacuative1843733evacuative
evasive1344663eva_sive
evocative1746293evocative
exacting1838523exacting
exaction1738953exaction
executive2164743executive
exertive1839083exertive
extractive2246603extractive
fictive1537023_fictive
genitive1247643gen_itive
impactive1845283impactive
inaction1039623inaction
inactivate1545693inactivate
inactively1845313inactively
inductive1547263inductive
infective17108973infective
injective2178023injective
invective1798043invective
lenitive1148493len_itive
locative1338683locative
naive85116213_na__ive
natives10310823_na_tives
negative1239083negative
olfactive1743463olfactive
orective1339353orective
overactive1847263overactive
placative1646223placative
practice1438733practice
practise12310143practise
proactive1648363proactive
reductive1547793reductive
refective1749113refective
refractive1846693refractive
rejective2148253rejective
relative11313143rela_tive
sanative11310473sanative
sedative1238853seda_tive
seductive1545613seductive
selective1449523selective
sensitive1246963sensitive
stative102612933sta_tive
tactile9310613_tactile
tentative1247813tentative
tractile10311073tractile
unitive10310563un_itive
vocative1637913vocative

Search took 7 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.1561145455.1
2DLD Change Limit1461621026.54622328.4
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.73226543.5
 
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.