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

205 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
tensive1026991(None) 
pensive122610391pensive
tensile72612731tensile
endive103310472_endive
ensile62616472_ensile
extensive1945722extensive
intensive1248402intensive
ostensive1244732ostensive
pensile92713542pensile
teniae64517352ten_iae
tense55225842tens__e
tensible1037242tensible
tensing84616652tensing
tension7311802tension
tensity1039102tensity
tentie62521182tenti_e
tussive1035302tussive
abusive1245283abusive
agentive1248043agentive
amusive1246253amusive
ascensive1444183ascensive
attentive1245853attentive
aversive1447443aversive
bedside1156843bedside
beehive1554033beehive
belive115415303be_live
benzine1839343benzine
beside95114613be_side
cense75121403cens__e
censing104215263censing
censure92310603censure
centile94217183centile
centime114513033centime
connive1238993connive
cursive1237833cursive
deceive1337813deceive
decisive1446633decisive
defensive1644993defensive
delusive1245843delusive
denotive1238673denotive
dense65923503dens__e
densify1435293densify
density1137583density
dentine83320243dentine
deprive1338303deprive
depside1138403depside
derisive1247503derisive
derive103817043de_rive
desire7415303de_sire
detersive1346343detersive
donsie7613643donsi_e
elusive1057003elusive
endite73817593_endite
endives113710693_endives
engine71114863_engine
enisle63412093_enisle
enliven1034903_enliven
ensign737523_ensign
ensiled82611433_ensiled
ensiles72714833_ensiles
enslave1036273_enslave
ensue54013833_ens_ue
ensure63416003_ensure
entice81316863_entice
entire61617703_entire
eosine64519413_eosine
erosive1039193erosive
evasive1344663evasive
expensive2145843expensive
extensile1645033extensile
felsite1039083felsite
festive1339773festive
genie66124923gen_i_e
genitive1247643genitive
genoise839423genoise
gentile83515293gentile
genuine838373genuine
henlike1448693henlike
hessite1038993hessite
inside7613453_inside
intensives1347393intensives
jussive1734293jussive
lenite6719983len_ite
lenitive1148493lenitive
lense54523433lens__e
lensing84015103lensing
massive12289773massive
mensae84114043mens_ae
mense75025633mens__e
mensing103915103mensing
missive122413143missive
naive85116213__naive
newsie9138213newsi_e
offensive1842773offensive
onside7511803_onside
passive12239593passive
penile82219603pen_ile
penlite9313243penlite
pennine93712953pennine
pensee8417313pens_ee
pensil83013333pensi_l
pensils92811593pensils
pension9412203pension
pensione1039773pensione
pensively1745913pensively
pepsine11310603pepsine
plosive1236673plosive
protensive1546203protensive
receive1239733receive
redrive112410563redrive
regive104814323re_give
reive85522943re__ive
relive95120783re_live
reside74224933re_side
resile64627673re_sile
resite64128453re_site
resize154117723re_size
restive10315933restive
retentive1249853retentive
revive124914823re_vive
seaside839693seaside
senile63420213sen_ile
sensate7311893sensate
sense55526823sens__e
sensible1037853sensible
sensing84116953sensing
sensitive1246963sensitive
sessile739523sessile
sonsie6614863sonsi_e
suasive1037853suasive
taeniae739083taen_iae
tansies74521243tansies
tantivy1335563tantivy
tardive1136893tardive
tassie66017023tassi_e
tealike111111083tealike
tease55428713teas__e
teasing83918513teasing
teatime9310083teatime
techie11511723techi_e
tectite9310583tectite
teensier835573teensier
tekkie934203tekki_e
tektite1136883tektite
tenable93214493tenable
tenace82715693ten_ace
tenail64516113tenai_l
tenaille846813tenaille
tenails73713923tenails
tending94419163tending
tenge65720443ten__ge
tenia55324483ten_i_a
tenias64720073ten_ias
tennies73017973tennies
tennis64015303tenni_s
tennises82810133tennises
tennist72813113tennist
tenorite8311993tenorite
tenpin8310583tenpi_n
tenpins9410073tenpins
tens45647413tens___
tensed74817833tens_ed
tensely1037363tensely
tenser64919433tens_er
tenses64722553tens_es
tensest72713313tensest
tensibly1345143tensibly
tensilely1244123tensilely
tensioned1045613tensioned
tensioner945913tensioner
tensions8310223tensions
tensities9311333tensities
tensor63812673tens_or
tensors72712373tensors
tentage81010643tentage
tentative1247813tentative
tentier73815923tentier
tenting84621153tenting
tentlike1236903tentlike
tenuis64213083tenui_s
tenuity1037453tenuity
tenure6311613ten_ure
teosinte845543teosinte
tergite8311003tergite
termite9313893termite
terrine72517573terrine
terse55026823ters__e
testae64216253te_stae
testee64323303te_stee
textile1437223textile
thrive125313223t_hrive
tinlike11248803tinlike
tonsil6311873tonsi_l
tonsils7310183tonsils
tonsure758783tonsure
tontine72316143tontine
topside1037733topside
unlive92712333_unlive
utensil7125213utensi_l
utensils8124963utensils
venine93718433ven_ine
venire93513693ven_ire
versine102515173versine
visive1257873_visive
website1235323website

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272056.81319672.2
3Display Results2052050.0603416.7
 (SQL Overall)1786912057.27924548.8
 
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.