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

196 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
terpene9231086(None) 
terpenes102111571terpenes
terrene72411031terrene
perpend12259352perpend
perpent112318812perpent
serene63522352ser_ene
serpent92916282serpent
teepee8314362teepe_e
tenpence1246402tenpence
tepee74724212te_pe_e
terebene1045362terebene
terete6319332ter_ete
terne56426152ter__ne
terpenic1247212terpenic
terrane72814232terrane
terreen7257572terreen
terrenes82212602terrenes
terrine72517572terrine
terylene1144152terylene
triene64316382t_riene
arene55329413_ar_ene
arpen74418043_arpen_
arpens84814823_arpens
arpent84822093_arpent
benzene1836343benzene
bergere1068913bergere
berline93716853berline
cervine122610803cervine
deepen9339193deepen_
deepened1235663deepened
deepener1145183deepener
deepens10307813deepens
depend103510923de_pend
depone93616553de_pone
eocene8311613_eocene
epee64628503_e_pe_e
ermine8416923_ermine
erne46727433_er__ne
eterne6311723eter__ne
ethene93312923_ethene
expend16247503_expend
expense16127873_expense
ferine96422583fer_ine
ferment12315573ferment
fervent13310063fervent
gerent73223103ger_ent
germane1049663germane
germen9612313germen_
germens1078633germens
gyrene10227243gyr_ene
hempen1338963hempen_
heroine103517483heroine
herpes115517323herpe_s
intervene12912253intervene
keppen14346573keppen_
kerne94718223ker__ne
kerosene1254823kerosene
ketene106613003ke_tene
mergee94018143merge_e
mergence13137943mergence
mermen10813813mermen_
neogene847553neogene
neoprene1045173neoprene
nervine102510633nervine
orpine83914483_orpine
pentene9313793pentene
percent113520603percent
perpended1546083perpended
perpends13227753perpends
perpents122312043perpents
prepense12238943prepense
propene112716043propene
pyrene113210733pyr_ene
reopen8311573reopen_
reopened1138513reopened
reopens939373reopens
repent84728873re_pent
repine85627813re_pine
rerent63832453rer_ent
retene69224273re_tene
serener73415763ser_ener
serenes73222903ser_enes
serine65432673ser_ine
serpents102410373serpents
steepen9348653steepen_
steepened1244073steepened
steepens10277113steepens
stelene7310253ste_lene
styrene10116693styr_ene
tarpan82814293tarpan_
tarpans92513533tarpans
tarpon82812803tarpon_
tarpons92612213tarpons
teen45938203te__en_
teener64717503te__ener
teens56227483te__ens
teeny85417883te__eny
teepees939263teepees
tegmen988403tegmen_
temped113912893tempe_d
tempeh13357463tempe_h
tempehs14325153tempehs
temper103914093tempe_r
tempera11329043tempera
tempered13248223tempered
temperer12227723temperer
tempers113513013tempers
tempest1139223tempest
temping122710693temping
temple102811333temp_le
tendence1148523tendence
tenpences1346543tenpences
tenpenny1342343tenpenny
tenpin8310583tenpin_
tenpins9410073tenpins
teopan839353teopan_
teopans939203teopans
tepees84215243te_pees
tepefy1434803te_pefy
terce75721843ter__ce
tercel83612993terce_l
tercelet1049883tercelet
tercels94110363tercels
terces83921413terce_s
tercet83624913terce_t
tercets93512443tercets
terebenes1146063terebenes
teredo7310783ter_edo
tergite8311003tergite
termed94816703terme_d
termer85717253terme_r
termers95414503termers
terming104016003terming
termini93410813termini
termite9313893termite
tern46134803ter__n_
ternate7415483ternate
ternes65422903terne_s
terns55226873ter__ns
terpenoid1244603terpenoid
terpineol1142173terpineol
terpinol1044073terpinol
terrace93311843terrace
terrae62915213ter_rae
terranes82514433terranes
terreens8246533terreens
terrenely1243853terrenely
terret63425623terre_t
terrets72913583terrets
terrines82117553terrines
terse55026823ter__se
tersely1038113tersely
terseness948403terseness
terser67317823terse_r
tersest71713993tersest
terylenes1244933terylenes
testee64323303teste_e
three87526913thr_e_e
throne98517603thr_one
toluene736463toluene
topee76029953t_ope_e
torment9316173torment
torpedo1035053torpedo
torrent7313413torrent
torten65314353torten_
toupee8316133toupe_e
trapeze1836253trapeze
tree47745813t_r_e_e
treen55622753t_reen_
treens65317873t_reens
trend64817453t_r_end
trepan82511673trepan_
trepang10257293trepang
trepans92311593trepans
trephine1338933trephine
trienes74118413t_rienes
triens65417543t_riens
trine54734603t_r_ine
triune64210183t_riune
trone55131863t_r_one
tropine93116653tropine
tuppence1444413tuppence
turbine9310303turbine
turdine8310283turdine
tureen63312723tureen_
tureens7289873tureens
turgent8712393turgent
turpeth1284813turpeth
twopence1542953twopence
uterine7315193uter_ine
veepee11311483veepe_e
venene92912523ve_nene
verbena1235373verbena
vergence14128273vergence
versine102515173versine
vespine1237903vespine

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 Filter1786911340270.436409841.7
2DLD Change Limit1340271967.53317792.0
3Display Results1961960.0762578.9
 (SQL Overall)1786911968.04522211.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.