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 “ternes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

150 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
ternes6542290(None) 
ernes55224811_ernes
kernes104717531kernes
terces83921411terces
terne56426151terne_
terns55226871tern_s
aeries64737782aeries
arenes64928392arenes
benes75536232be_nes
bennes86019012bennes
bermes106023002bermes
ceres75540012cer_es
certes84623082certes
denes65639722de_nes
erne46727432_erne_
erns45428232_ern_s
erses55826802_erses
esnes54817362_esnes
eterne6311722eterne_
externes1539832externes
feres86038182fer_es
ferns85220082fern_s
genes65133092ge_nes
genres75515622genres
heres86245902her_es
herns84825582hern_s
heroes94923822heroes
herpes115517322herpes
internes82721232internes
kermes124616132kermes
kerne94718222kerne_
kerned114112932kerned
kernel104010592kernel
kernels11417952kernels
kerns94719562kern_s
lenes54738522le_nes
leones64417722leones
liernes739622liernes
merces105720742merces
merdes94518602merdes
meres75143572mer_es
merges94122492merges
merles85322762merles
mesnes85216212mesnes
nenes55329672ne_nes
nerves94216192nerves
penes75839222pe_nes
peones83821042peones
peres76246642per_es
perses85428062perses
seines65029902seines
serenes73222902serenes
seres55448892ser_es
serges74225972serges
series64540972series
serines74229542serines
serves94423652serves
steres63929532ster_es
sterner7411912sterner
sternest8314432sternest
sterns64616762stern_s
tares57456562tar_es
targes74524592targes
tarns56433952tarn_s
tarres64723042tarres
teases65426272teases
teener64717502teener
teeners74415452teeners
teens56227482teen_s
tees45353582te__es
teinds738262teinds
teles54536002te_les
telnet6518832telnet
telnets738372telnets
tends65425582te_nds
tenet55542212te_net
tenets65518952te_nets
tenner64117102tenner
tenners74014922tenners
tennies73017972tennies
tennis64015302tennis
tenrec837512tenrec
tenrecs936032tenrecs
tens45647412te_n_s
tense55225842te_nse
tenses64722552tenses
tents56434212te_nts
tenues63816442tenues
tepees84215242tepees
terais64023512terais
terce75721842terce_
tercel83612992tercel
tercels94110362tercels
tercet83624912tercet
tercets93512442tercets
termed94816702termed
termer85717252termer
termers95414502termers
terms75523472ter_ms
tern46134802tern__
terpenes102111572terpenes
terranes82514432terranes
terras63516972terras
terrenes82212602terrenes
terret63425622terret
terrets72913582terrets
terries73425632terries
terrines82117552terrines
terse55026822terse_
terser67317822terser
tersest71713992tersest
testes65125822testes
thanes94918982thanes
theines104013232theines
theres96525472ther_es
thermes126214612thermes
threes97117322threes
throes97518672throes
thrones105715842thrones
tierces93710452tierces
tines54848422t_ines
tires55437492tir_es
tones56048662t_ones
tonnes65320852tonnes
tores55352672tor_es
tories65435882tories
torses64727952torses
tortes64826052tortes
treens65317872treens
trees55835762t_rees
trends75513542trends
tres46542902t_r_es
tries55742812t_ries
trines64132562trines
trones65629282trones
trues54925322t_rues
tunes55332192t_unes
turned73914472turned
turner63914612turner
turners73912892turners
turns55623242turn_s
turves94212692turves
twines94717272twines
tynes85920302t_ynes
tyres84725232tyr_es
verges104320182verges
vermes115019142vermes
verses94223762verses
verves124617882verves
zeroes154314342zeroes

Search took 3 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 Filter178691825510.330541487.9
2DLD Change Limit825511502.34335233.0
3Display Results1501500.0463260.9
 (SQL Overall)1786911502.71965719.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.