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

145 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
tetrode83934(None) 
tetrodes939091tetrodes
bestrode1147142bestrode
detrude936082detrude
erode64520992_e_rode
outrode82313422outrode
strode75215972_strode
tetrad73612052tetrad_
tetrads82910192tetrads
tetroxide1744282tetroxide
trode65322852__trode
aerobe8412403ae_robe
astride8311973astride
bestride1138613bestride
betide95115973bet_ide
betroth1247543betroth
cathode1338993cathode
cestode1037963cestode
corrode101310573corrode
debride1138593debride
decode104414743de_code
degrade10229903degrade
demode104013463de_mode
deride84420033de_ride
dethrone1247563dethrone
detruded1134883detruded
detrudes1036203detrudes
dextrose1645363dextrose
electrode1247033electrode
encode9310443_encode
enrobe86610793_enrobe
epode85114093_e_pode
eroded84313583_e_roded
erodes74819883_e_rodes
erose55727273_e_rose
estrone7413953estrone
etude63612303_et_ude
extrude1545013extrude
geode7412593ge__ode
hagrode1236443hagrode
hotrod1048803hotrod_
hotrods1148283hotrods
intrude837403intrude
joyrode1853303joyrode
kathode1545733kathode
ketone105014533ket_one
ketose105711813ket_ose
leprose938543leprose
merde84320123me_r_de
method1239033method_
methods1338893methods
metope10611123met_ope
metre74821303metr__e
metred95315143metred_
metro74718803metro__
metros84217803metro_s
necrose939723necrose
neurone739433neurone
nitride82811243nitride
obtrude1044243obtrude
oestrone849973oestrone
outmode10199663outmode
outride82615683outride
outstrode1065413outstrode
overrode121810573overrode
pentode1039893pentode
petiole9311303petiole
petrale9312623petrale
petrol82714063petro_l
petrols92913083petrols
petronel1048143petronel
petrous92714423petrous
recode93618713re_code
redrove11249423redrove
refroze1956223refroze
regrade92612033regrade
reprobe112310133reprobe
reprove122911073reprove
rerose63320843re_rose
restrove1138963restrove
retore67630773ret_ore
retrace91417343retrace
retried84419153retried
retro55020953retro__
retrocede1245403retrocede
retrorse837623retrorse
retros63820193retro_s
rewrote1039123rewrote
rode55844303___rode
sarode75317513_sarode
setose65114773set_ose
stride75420963_stride
strobe84513813_strobe
stroke105116173_stroke
strove95014793_strove
tacnode1045093tacnode
teared75722153teared_
tearoom939063tearoom
telome8311923te_lome
terce75721843te_r_ce
teredo7310783te_redo
terete6319333te_rete
termed94816703te_rmed
terne56426153te_r_ne
terrace93311843terrace
terrae62915213te_rrae
terrane72814233terrane
terrene72411033terrene
terrine72517573terrine
terror63811733terro_r
terrors73112213terrors
terse55026823te_r_se
tetched133010773tetched
tetra53417953tetr__a
tetradic1145813tetradic
tetramer1046813tetramer
tetrapod1145123tetrapod_
tetrapods1244743tetrapods
tetras63017623tetr_as
tetri52716453tetr__i
tetris62816293tetr_is
tetroxid1646443tetroxid
tetroxides1844003tetroxides
tetroxids1744283tetroxids
tetryl935693tetr_yl
tetryls1034643tetryls
throe89321423t_hro_e
throne98517603t_hrone
throve128012393t_hrove
tirade7311693t_irade
titrate72215573titrate
titre54619393titr__e
torose64317693t_orose
towrope1245583towrope
trade65026043__trade
triode75311893t_riode
trod57627953__trod_
troke94821053__troke
trone55131863__trone
trope75725803__trope
trove85221923__trove
tutored837553tutored
untrod769853untrod_
vetoed10359823vet_oed
zeroed16409413ze_roed

Search took 7 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.390458182.1
2DLD Change Limit1340271456.48320673.6
3Display Results1451450.0632301.6
 (SQL Overall)1786911456.93625762.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.