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

337 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
pentanes1031607(None) 
pentane9415741pentane_
pentenes10315631pentenes
centares102913892centares
centones10313662centones
cetanes9315132ce_tanes
dentines93418392dentines
entases72816272_entases
henbanes1336562henbanes
heptanes1339002heptanes
montanes101114522montanes
pectases122411182pectases
pectates122213932pectates
pectines121914672pectines
penances12312442pen_ances
penangs10268372pen_angs
penates93321592pen_ates
pendants1139092pendants
pennames12287782pennames
pennants1037062pennants
pennines103112032pennines
pentacles1338762pentacles
pentads1039522penta_ds
pentangles1344812pentangles
pentanol1046172pentanol
pentanols1146112pentanols
pentene9313792pentene_
pentodes11310362pentodes
pentoses10312892pentoses
peptones12311032peptones
phytanes1645752phytanes
pintanos10107552pintanos
platanes102711882platanes
tentages91011042tentages
ventages12119762ventages
benames112814603ben_ames
bennes86019013ben__nes
benzenes1946853benzenes
benzines1938213benzines
betaines10313293be_taines
betakes134212523be_takes
butanes9312743_butanes
centals94317053centa_ls
centare93113703centare_
centas85020703centa__s
centaurs1035723centaurs
centavos1344783centavos
centeses1079443centeses
centiares1167653centiares
centiles103615813centiles
centimes124012613centimes
centner946853cent_ner
centners1057243cent_ners
centres93817123cent_res
cetane8315283ce_tane_
decanes103118913de_canes
dentals83915393denta_ls
dentate8315153dentate_
dentated10411703dentated
dentine83320243dentine_
dentins83419223dentin_s
dentures9312453dentures
deplanes11311203deplanes
destines93619663destines
ectases92911673_ectases
edentates1046943edentates
enates64026423_en_ates
encages103313783_encages
encases93116053_encases
enfaces122110913_enfaces
engages92912493_engages
engines81114463_engines
enhances1339293_enhances
enlaces92313393_enlaces
enplanes1039463_enplanes
enrages83114853_enrages
entails7912823_entails
entangles1075553_entangles
entasis73012573_entasis
ententes8312763_ententes
entices91616333_entices
entires71517783_entires
entrances11310953_entrances
entrants8311753_entrants
entrees71813773_entrees
entries71523163_entries
entwines1148753_entwines
epitases1038933epitases
estates74520173_estates
etapes85415293_e_tapes
ethanes103713503_ethanes
fenlands1245183fenlands
fentanyl1442533fentanyl
fentanyls1541953fentanyls
fontanel1145553fontanel
fontanels1244063fontanels
gentes75324163gent__es
gentians937563gentian_s
gentiles93713523gentiles
gentles83714343gent_les
gentries91315263gentries
geotaxes1644743geotaxes
gestates93213723gestates
hectares1338853hectares
hektares1535813hektares
henbane1237353henbane_
heptane1238363heptane_
hexanes17319463he_xanes
inanes62519803_in_anes
intakes11310943_intakes
intines7921113_intines
intones7816533_intones
kentes105118643kent__es
ketenes114813503ke_tenes
ketones115014503ke_tones
lantanas838263lantanas
lentando943603lentando
lindanes939163lindanes
meltages1148243meltages
menaces112715523men_aces
menages103615393men_ages
mentalese1146323mentalese
mentees93214503ment_ees
menthenes1447703menthenes
metages102714973me_tages
metates92720003me_tates
methanes133812163methanes
mintages111110513mintages
montages111412183montages
montane91313623montane_
nontaxes1537853nontaxes
octanes91111393_octanes
pancakes1637073pancakes
pandanus1136433pandanus
panes76148693p___anes
pangenes112612823pangenes
pannes85522853pan__nes
pantalet10415903pantalet
pantalets1147673pantalets
pantalones1246723pantalones
panties94230933pant_ies
pantiles103617153pantiles
pantries101817393pantries
parentages1345483parentages
partakes1449923partakes
partans94418283partan_s
patines95225763p_atines
pavanes123612653p_avanes
peaces106324083pe__aces
peages94321843pe__ages
peans75437643pe__an_s
peasants1038263peasants
peases85229473pe__ases
pecans101515833pe_can_s
pechans14810503pechan_s
pectase112410363pectase_
pectate112214693pectate_
pectens11189203pecten_s
pectins112315233pectin_s
pectizes21229773pectizes
pedants10310113pe_dants
peerages1189883peerages
pekans121710553pe_kan_s
pelages10714613pe_lages
peltasts1035703peltasts
peltate92013773peltate_
peltries10313023peltries
penance11313443pen_ance
penanced1338163pen_anced
penang92511113pen_an_g
penchants1646193penchants
pendant10314853pendan_t
pendents1139413pendents
peneplanes1444313peneplanes
penes75839223pe___nes
penetrances1544803penetrances
penetrants1245273penetrants
penetrates1248713penetrates
penises9318193pen_ises
penitences1447973penitences
penitents1147703penitents
penlites10312263penlites
penman10312323penman__
pennae84314033penna_e_
penname11328553penname_
pennant9312493pennan_t
pennate93314033pennate_
pennated11299543pennated
penne75423853pen__ne_
penned94217613pen__ned
penner84616663pen__ner
penners93414183pen__ners
pennies94218813pen_nies
pennine93712953pennine_
pennis84315743pen__nis
pennoned1136313pennoned
pennons939713pennon_s
penoches1538923penoches
pensees9311203pen_sees
pensiones11410003pensiones
pentacle1239383pentacle
pentad9313763penta__d
pentagon1146323pentagon
pentagons1246153pentagons
pentamery1644023pentamery
pentangle1244993pentangle
pentarch1544943pentarch
pentarchs1643933pentarchs
pentode1039893pentode_
pentosans1145173pentosan_s
pentose9311593pentose_
pentyls1236523pent_yls
penuches1536943penuches
penuries10311663penuries
peonages1138473peonages
peones83821043pe__ones
pepsines1239883pepsines
peptalks1653843peptalks
peptides132610253peptides
peptizes21269853peptizes
peptone11310763peptone_
percales12313783percales
perniones1148593perniones
pertained1238493pertained
pertains102113413pertains
pertness10310093pert_ness
pervades1437343pervades
pesades10310893pe_sades
pestles93217693pest_les
petaled103614143pe_taled
petals84719813pe_ta_ls
petards104311153pe_tards
petasos948603pe_tasos
petasus946363pe_tasus
petites93820203pe_tites
petnaper1243913petnaper
petnapers1343823petnapers
petnaps1145033petna_ps
petrales10312953petrales
pettiness1178703pettiness
pettings11349703pettings
pettles93916483pe_ttles
phenates13611563phen_ates
phytane1545443phytane_
pinangs10267793pin_angs
pinbones1238133pinbones
pinenes93416673pin_enes
pinnaces12268863pinnaces
pinones94717063pin_ones
pintadas11105063pintadas
pintadoes1295243pintadoes
pintados11105993pintados
pintails10310163pintails
pintano998993pintan_o
pintas85021393pinta__s
pintles94118723pint_les
pintoes95117713pint_oes
pinwales1367963pinwales
pittances1345703pittances
planes85028083p__lanes
platane93112303platane_
platans93413123platan_s
plenties10314693plent_ies
pontes83627853pont__es
pontine92419053pontine_
pontons93315543ponton_s
poontangs1242753poontangs
portages112613223portages
portances1349833portances
postages112815323postages
potages102416423p_otages
potentates12106323potentates
pottages112910453pottages
poutines102415103poutines
prenames12311633pren_ames
prentices131111903prentices
pretapes122811533pretapes
pristanes11410423pristanes
profanes132311573profanes
propanes122415823propanes
protases102115033protases
punties94520783punt_ies
recanes93222263re_canes
renames92418053ren_ames
rennases848983rennases
rentals74017473renta_ls
rentes65431193rent__es
repentances1556113repentances
restages92815763restages
restates83423413restates
retakes113718863re_takes
retapes93917423re_tapes
retaxes143615093re_taxes
retenes76324623re_tenes
retines75134673re_tines
retunes76918403re_tunes
seitans73312303seitan_s
senates73322583sen_ates
sensates8511133sensates
sentences11610303sentences
sentinel838703sentinel
sentinels947423sentinels
sentries81318053sentries
septages1168263septages
sestines82717243sestines
sextans14349263sextan_s
sextants15287383sextants
soutanes8312933soutanes
spectates13228813spectates
stanes64933403__stanes
suntans72111733suntan_s
syntaxes1843633syntaxes
tenaces92814513ten_aces
tenants7311013ten_ants
tendances1247573tendances
teniases838623teniases
tentacles1146713tentacles
tentage81010643tentage_
terranes82514393terranes
testates83615443testates
tetanies8513543te_tanies
tetanus737933te_tanus
tontines82114733tontines
untunes72211253_untunes
vantages12119023vantages
vendaces1457183vendaces
venenes102712133ven_enes
venines103516613ven_ines
ventage11109623ventage_
ventails1139823ventails
ventures11311483ventures
vintages12118273vintages
wantages12109023wantages
wapentakes1952253wapentakes
yentas94614213yenta__s
yentes95517603yent__es
zenanas16286233zen_anas

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461623377.45319611.2
3Display Results3373370.1562160.3
 (SQL Overall)1786913377.77922970.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.