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

115 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
sanative1131047(None) 
amative12311732_amative
conative131214622conative
donative12139872donative
emanative1447312emanative
laxative1845092laxative
native9613012__native
sanitise81511812sanitise
sanitize171410082sanitize
saxatile1544952saxatile
sedative1238852sedative
sonatine8313322sonatine
stative102612932s_tative
ablative1348243ablative
active11313743_a_ctive
adaptive1445133_adaptive
agatize1739833_agatize
anatase738943_anatase
anytime1246043_anytime
apatite9312963_apatite
astatine8313533astatine
banalize191010933banalize
calmative1647033calmative
canalise10816213canalise
canalize19914493canalize
captive1438973ca_ptive
causative1445833causative
cavatine13310323cavatine
creative132812803creative
curative13310403curative
dative10311813__dative
denotive1238673denotive
dilative1239523dilative
donatives13146903donatives
durative1239073durative
elative10312453_elative
enactive1338513enactive
ergative1238973ergative
fanatic12610693fanati_c
fanatics1367183fanatics
fixative2145083fixative
genitive1247643genitive
ideative1238573ideative
illative1147183illative
inactive1348203inactive
lanate6421263lanat__e
laudative1344753laudative
laxatives1943353laxatives
lenitive1148493lenitive
ligative1258803ligative
locative1338683locative
manatee9317663manat_ee
monitive1349993monitive
mutative1348283mutative
naive85116213__na_ive
narrative1247373narrative
natives10310823__natives
negative1239083negative
nonactive1448973nonactive
nonnative1248343nonnative
optative1347653optative
palatine10316063palatine
pantie84326473pan_ti_e
pantile93918483pan_tile
placative1646223placative
punitive1346833punitive
putative1348373putative
radiative1348173radiative
relative11313143relative
rotative11310343rotative
saltie63422433sa_lti_e
saltine75018563sa_ltine
saltire73113033sa_ltire
sanctify1644493sanctify
sanction1049533sanction
sanctity1345593sanctity
sandlike1339713sandlike
sandpile1146773sandpile
sanguine947633sanguine
sanidine939853sanidine
sanitate8612043sanitate
sanities81219773sanities
sanitised10147353sanitised
sanitises91111743sanitises
sanitized19138173sanitized
sanitizer18126733sanitizer
sanitizes181210133sanitizes
santimi938793san_timi
santims9312603san_tims
santimu938563san_timu
santir6315253san_ti_r
santirs7312963san_tirs
satire63218003s__atire
savate9313783savat__e
sedatives1346153sedatives
senate63725173senat__e
sensitive1246963sensitive
separative1546973separative
siccative1645103siccative
snathe94415113s_nat_he
sonatina849073sonatina
sorptive1346473sorptive
sportive1348333sportive
statice92614033s_tatice
statives112710793s_tatives
steatite8310583steatite
suasive1037853s_uasive
summative1646203summative
talkative1644303talkative
tantivy1335563tan_tivy
tentative1247813tentative
unitive10310563_unitive
urinative1247653urinative
vocative1637913vocative
zaratite1747793zaratite

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.420425454.8
2DLD Change Limit1461621158.04618165.8
3Display Results1151150.0502300.0
 (SQL Overall)1786911158.51620983.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.