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

229 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
peptone1131076(None) 
peptones12311031peptones
depone93616552dep_one
heptane1238362heptane
heptose1237492heptose
ketone105014532ke_tone
lepton82510802lepton_
leptons91910432leptons
pentane9415742pentane
pentene9313792pentene
pentode1039892pentode
pentose9311592pentose
pepsine11310602pepsine
peptide122910692peptide
peptize20279482peptize
peptonic1448832peptonic
peptonize2246562peptonize
acetone9310793acetone
atone56527983__atone
begone9512133be_gone
beton76022063be_ton_
betons84919553be_tons
betony114211583be_tony
capstone1237653capstone
centones10313663centones
cestode1037963cestode
cetane8315283ce_tane
copestone1397453copestone
dapsone1038463dapsone
debone93714783de_bone
dentine83320243dentine
deplane10311413deplane
deplore1039483deplore
deponed113712873dep_oned
depones103717093dep_ones
depose94215763dep_ose
destine83719953destine
duotone836893duotone
ecotone938583ecotone
epigone1057843epigone
epitome1157743epitome
epitope1147053epitope
epode85114093_ep_ode
estrone7413953_estrone
evzone1894683_evzone
eyestone1146533eyestone
felstone1146863felstone
gemstone1145843gemstone
geophone1447433geophone
haptene123810933haptene
heptanes1339003heptanes
heptoses1338373heptoses
hexone16289233he_xone
hipbone1445923hipbone
histone10312843histone
impone103011863imp_one
intone61115433_intone
isotone7239983isotone
jeton124815403je_ton_
jetons134512613je_tons
jetton1338033jetton_
jettons1437273jettons
ketene106613003ke_tene
ketones115014503ke_tones
ketose105711813ke_tose
keystone1545333keystone
lactone9311413lactone
leone55018823le__one
leprose938553leprose
leptin82512333leptin_
leptins92412693leptins
leptonic1247703leptonic
leptotene1143533leptotene
melton8311553melton_
meltons9410923meltons
metope10611123me_tope
nekton1036583nekton_
nektons1136393nektons
neurone739443neurone
newton936983newton_
newtons1036813newtons
oestrone849973oestrone
overtone111012573overtone
oxytone1744203oxytone
padrone102512073padrone
panettone1144343panettone
papoose1147513papoose
pappose1047413pappose
parton84720993parton_
partons94620513partons
patine85328123p_atine
pectase112410363pectase
pectate112214693pectate
pecten102711103pecten_
pectens11189203pectens
pectin102615533pectin_
pectines121914683pectines
pectins112315233pectins
pectize20259913pectize
peephole1545993peephole
pekoe114612363pe_ko_e
pelon74423213pe_lon_
peloton938743peloton_
pelotons1038913pelotons
peltate92013773peltate
pelting102917273pelting
penne75423853pe__nne
pennine93712953pennine
pennon8310643pennon_
pennoned1136313pennoned
pennons939713pennons
pensione1039773pensione
pentanes10316083pentanes
pentenes10315633pentenes
pentodes11310363pentodes
pentoses10312893pentoses
peon65635243pe__on_
peones83821043pe__ones
peons75327183pe__ons
peony105717563pe__ony
peperoni1246273peperoni
pepino10310333pep_ino
pepinos1137693pepinos
peplos101211543peplo_s
peploses1269473peploses
pepo87622153pep_o__
pepos96620083pep_o_s
pepping113511623pepping
pepsin10310853pepsin_
pepsines1239883pepsines
pepsins11310433pepsins
peptalk1554823peptalk
peptic122113153pept_ic
peptics132610243peptics
peptid112712373pept_id
peptides132610273peptides
peptids12239333peptids
peptized22237523peptized
peptizer21236473peptizer
peptizes21269863peptizes
peptonized2455573peptonized
peptonizes2346413peptonizes
pereon83517453pereon_
pereons92815003pereons
peritonea1147303peritonea
perron83216623perron_
perrons93115483perrons
person83517873person_
persona92812453persona
personae102410553personae
persons93717013persons
pesthole1347553pesthole
pestle83215843pest_le
pesto75723723pesto__
pestos84719083pesto_s
petiole9311303petiole
petite84320653pe_tite
petronel1048143petronel
petting103720953petting
pettle84116053pe_ttle
petto76021043petto__
peyote1139853pe_yote
phone105621933__phone
photon1111514833photon_
photons123814433photons
phytane1545443phytane
phyton143610253phyton_
phytons15319063phytons
pinbone1138183pinbone
pipestone1345503pipestone
pistole92414313pistole
piston83515923piston_
pistons93016373pistons
piton76121583p_iton_
pitons85319043p_itons
platane93112303platane
pluton838853pluton_
plutons938343plutons
pone65747533__p_one
pontine92419053pontine
ponton83217643ponton_
pontons93315553pontons
postpone1248693postpone
potstone1039423potstone
poutine93316823poutine
prestore104217353prestore
prone75332623__prone
propone112716303propone
proton84318893proton_
protons93118003protons
puton73617913p_uton_
putons83515153p_utons
pyrone112714473p_yrone
redbone1037973redbone
redone74820053re_done
repine85627813rep_ine
repose84121413rep_ose
reprobe112310133reprobe
reprove122911073reprove
reptant92817073reptant
reptile93914083reptile
reshone102414163reshone
restoke116113903restoke
restore75822983restore
retene69224273re_tene
retine66237333re_tine
retore67630773re_tore
retune69121953re_tune
rezone153814783re_zone
semitone1048973semitone
septage1078403septage
septate9511873septate
septime1138803septime
sestine73017923sestine
seton55223543se_ton_
setons64620173se_tons
setose65114773se_tose
sexton133610793sexton_
sextons143710413sextons
stone55431183__stone
subtone9310343subtone
teston6313303teston_
testons7313563testons
tiptoe838283tipto_e
tone46953743___tone
topstone1046883topstone
tritone73613883tritone
uptore8279453_uptore
zeppole2043493zeppole

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 Limit1340272297.23318529.9
3Display Results2292290.0962385.4
 (SQL Overall)1786912297.73523101.6
 
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.