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

207 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
terrene7241103(None) 
terpene92310861terpene
terrane72814231terrane
terreen7257571terreen
terrenes82212601terrenes
terrine72517571terrine
serene63522352se_rene
terebene1045362terebene
terete6319332te_rete
terne56426152te_r_ne
terpenes102111572terpenes
terrace93311842terrace
terrae62915212terr_ae
terranes82514432terranes
terreens8246532terreens
terrenely1243852terrenely
terret63425622terre_t
terrets72913582terrets
terrines82117552terrines
terylene1144152terylene
torrent7313412torrent
triene64316382t_riene
arene55329413__arene
barren85317623barren_
barrener1038343barrener
barrens94414323barrens
benzene1836343benzene
bergere1068913bergere
berline93716853berline
cervine122610803cervine
current9313693current
decree93117783decre_e
degree82814853degre_e
derriere936043derriere
deterrence1345623deterrence
deterrent10128943deterrent
eocene8311613_eocene
ermine8416923_ermine
erne46727433_e_r_ne
errand758793_errand
errant6618733_errant
erred65915673_erre_d
errhine1036593_errhine
erring73816483_erring
eterne6311723eter_ne
ethene93312923_ethene
ferine96422583fe_rine
ferment12315573ferment
ferrate103014043ferrate
ferrel92810203ferre_l
ferreled1234843ferreled
ferrels10248623ferrels
ferret93021173ferre_t
ferreted1236333ferreted
ferreter1136543ferreter
ferrets103111393ferrets
ferrety13287013ferrety
ferrite103312753ferrite
ferrocene1443383ferrocene
ferrule1035863ferrule
fervent13310063fervent
gerent73223103ge_rent
germane1049663germane
germen9612313germen_
germens1078633germens
gyrene10227243_gyrene
heroine103517493heroine
herring113615883herring
horrent10313553horrent
intervene12912253intervene
jerreed1535213jerreed
kerne94718223ke_r_ne
kerosene1254823kerosene
ketene106613003ke_tene
mergee94018143merge_e
mergence13137943mergence
mermen10813813mermen_
murrine9411483murrine
neogene847553neogene
neoprene1045173neoprene
nervine102510633nervine
neurine7311683neurine
neurone739443neurone
pentene9313793pentene
percent113520603percent
perpend12259353perpend
perpent112318813perpent
perron83216623perron_
perrons93115483perrons
pyrene113210733_pyrene
regreen8309043regreen
rerent63832453re_rent
retene69224273re_tene
secrete9311073secrete
serener73415763se_rener
serenes73222903se_renes
serine65432673se_rine
serpent92916283serpent
serrano768463serrano
serrate73017543serrate
sirree64017343sirre_e
stearine8311903stearine
stelene7310253ste_lene
styrene10116693styrene
tacrine9311293tacrine
tarre55825633tarr__e
tarred74720283tarre_d
tarres64723043tarre_s
tarring83318303tarring
taurine7311363taurine
teared75722153teare_d
tearer64822903teare_r
tearers75218233tearers
tearing84021493tearing
teen45938203te__en_
teener64717503te__ener
teens56227483te__ens
teeny85417883te__eny
teepee8314363teepe_e
tegmen988403tegmen_
tendence1148523tendence
tenpence1246403tenpence
tenrec837513tenre_c
tenrecs936033tenrecs
tepee74724213te_pe_e
terce75721843te_r_ce
tercel83612993terce_l
tercelet1049883tercelet
tercels94110363tercels
terces83921413terce_s
tercet83624913terce_t
tercets93512443tercets
terebenes1146063terebenes
teredo7310783te_redo
tergite8311003tergite
termed94816703terme_d
termer85717253terme_r
termers95414503termers
terming104016003terming
termini93410813termini
termite9313893termite
tern46134803te_r_n_
ternate7415483ternate
ternes65422903terne_s
terns55226873te_r_ns
terpenic1247213terpenic
terra54419673terr__a
terraced11318133terraced
terraces102712253terraces
terrain7410853terrain
terrains8410323terrains
terras63516973terr_as
terrases82111483terrases
terrella844703terrella
terrible1046643terrible
terrier73414963terrier
terriers84210823terriers
terries73425633terries
terrify1336353terrify
territ63421383terr_it
territs72714503territs
terror63811733terr_or
terrors73112213terrors
terry84721873terr__y
terse55026823te_r_se
tersely1038113tersely
terseness948403terseness
terser67317823terse_r
tersest71713993tersest
terylenes1244933terylenes
testee64323303teste_e
tetrode839343tetrode
three87526913t_hre_e
throne98517603t_hrone
toluene736463toluene
torment9316173torment
torrefy1353353torrefy
torrents838143torrents
torten65314353torten_
tree47745813t__re_e
treen55622753t_reen_
treens65317873t_reens
trend64817453t__rend
trienes74118413t_rienes
triens65417543t_riens
trine54734603t__rine
trireme935263trireme
triune64210183t_riune
trone55131863t__rone
turbine9310303turbine
turdine8310283turdine
tureen63312723tureen_
tureens7289873tureens
turgent8712393turgent
turret63121853turre_t
turreted935373turreted
turrets73010673turrets
uterine7315193ute_rine
venene92912523ve_nene
verbena1235373verbena
vergence14128273vergence
versine102515173versine
warren95012863warren_
warrener1136923warrener
warrens103810893warrens
yearend11285703yearend
zebrine1836463zebrine

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.486367677.0
2DLD Change Limit1340272077.53017799.1
3Display Results2072070.0802587.5
 (SQL Overall)1786912078.09622071.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.