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

202 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
pentode103989(None) 
pentodes11310361pentodes
pentose9311591pentose
cestode1037962cestode
encode9310442_encode
pentad9313762pentad_
pentads1039522pentads
pentane9415742pentane
pentene9313792pentene
pentoses10312892pentoses
pentoside1255372pentoside
pentoxide1944182pentoxide
peptide122910682peptide
peptone11310762peptone
acnode938203acn_ode
anode65021043_an_ode
bento75922953bento__
bentos86218303bento_s
benzole1837133benzole
bestrode1147133bestrode
betide95115973be_tide
cenote83715843cen_ote
centare93113703centare
centile94217183centile
centime114513033centime
cento76625173cento__
centones10313663centones
centos85920463cento_s
centre84316643cent_re
centred103411683centred
cestodes1138203cestodes
decode104414743de_code
demode104013463de_mode
denote74118043den_ote
denoted93512763denoted
dentate8315153dentate
dented84120513dented_
dentine83320243dentine
dentoid9310663dentoid
denture8311893denture
denude8169353den_ude
dynode1135023dyn_ode
encoded1139033_encoded
encoder1038633_encoder
encodes10310643_encodes
encore8314773_encore
enrobe86610793_enrobe
entice81316863_entice
entire61617703_entire
entoderm1175343_entoderm
entoil6912493_entoil
entomb1037363_entomb
entree61817883_entree
episode1056303episode
epitome1157743epitome
epitope1147053epitope
epode85114093_e_pode
erode64520993_e_rode
etude63612303_e_tude
eventide1246853eventide
fantod102010033fantod_
fantods11177623fantods
genome94312193gen_ome
gentile83515293gentile
gentle74014513gent_le
gentled9389093gentled
gentoo7311313gento_o
gentoos838633gentoos
geode7412593ge__ode
hented104218753hented_
heptose1237493heptose
intone61115433_intone
kente95821073kent__e
ketone105014533ke_tone
ketose105711813ke_tose
lento57223393lento__
lentoid8310683lentoid
lentoids947443lentoids
lentos65317403lento_s
mentee84121293ment_ee
mentor8414363mento_r
mentored1138003mentored
mentors9314993mentors
metope10611123me_tope
nematode1155163nematode
node513036883__n_ode
pandore10411853pandore
panted95024823panted_
pantie84326473pant_ie
pantile93918483pantile
panto76129413panto__
pantofle1364553pantofle
pantos85222743panto_s
pantoum1138703pantoum
pectase112410363pectase
pectate112214693pectate
pectize20259913pectize
pekoe114612363pe_ko_e
peltate92013773peltate
pelted94617763pelted_
penance11313443penance
pence94924453pen__ce
pend75934533pen__d_
pended103819013pen__ded
pends85527193pen__ds
pengo84317593pengo__
pengos94612413pengo_s
penholder1544413penholder
penile82219603pen_ile
penlite9313243penlite
pennae84314033pen_nae
penname11328553penname
pennate93314033pennate
penne75423853pen__ne
penned94217613penned_
pennine93712953pennine
pennon8310643penno_n
pennoned1136313pennoned
pennons939713pennons
penoche1447043penoche
pensee8417313pen_see
pensile92713543pensile
pensione1039773pensione
pensive122610393pensive
penstock1644073penstock
pent66559073pent___
pentacle1239383pentacle
pentanes10316083pentanes
pentenes10315633pentenes
penthouse1446263penthouse
pentomic1448143pentomic
pentosan1045733pentosan
pentosides1365043pentosides
pentoxides2073973pentoxides
pentyl1138813pent_yl
pentyls1236523pentyls
penuche1435943penuche
peptid112712373peptid_
peptides132610263peptides
peptids12239323peptids
peptize20279483peptize
peptones12311033peptones
period9314983period_
periods10312243periods
pernod9310453pernod_
pernods1038483pernods
pervade1337023pervade
pesade9311103pe_sade
pesthole1347553pesthole
pestle83215843pest_le
pestled102711443pestled
pesto75723723pesto__
pestos84719083pesto_s
petiole9311303petiole
petite84320653pe_tite
petted94121523petted_
pettle84116053pe_ttle
pettled103611513pettled
petto76021043petto__
peyote1139853pe_yote
phenetole1444073phenetole
photoed1338913photoed
pinbone1138183pinbone
pinhole122010433pinhole
pinole83218783pin_ole
pintada1096083pintada
pintado1096573pintado
pintle83818263pint_le
pinto75625753pinto__
pintoes95117713pintoes
pintos86021293pinto_s
pistole92414313pistole
plenitude1243103plenitude
pontine92419053pontine
ponton83217643ponto_n
pontons93315553pontons
pontoon93010703pontoon
postcode1346323postcode
precode12311853precode
prentice121012353prentice
prestore104217353prestore
punted94618713punted_
punto75121323punto__
puntos85915793punto_s
recode93618713re_code
rente54733783rent__e
rented74426593rented_
restoke116113903restoke
restore75822983restore
retore67630773re_tore
sente56432883sent__e
setose65114773se_tose
tentage81010643tentage
tented74221003tented_
tentie62521183tent_ie
tetrode839343tetrode
venose9310843ven_ose
ventage11109623ventage
vented104617923vented_
venture10311173venture
vetoed10359823ve_toed
yente86220043yent__e

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.403443402.0
2DLD Change Limit1340272026.42320866.7
3Display Results2022020.0762657.9
 (SQL Overall)1786912026.90225889.7
 
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.