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

156 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
heptane123836(None) 
heptanes1339001heptanes
cetane8315282ce_tane
deplane10311412deplane
haptene123810932haptene
hectare1238462hectare
hektare1435502hektare
henbane1237352henbane
heptad1237272hepta_d
heptads1335872heptads
heptose1237492heptose
hexane16379532he_xane
pentane9415742pentane
peptone11310762peptone
reptant92817072reptant
septage1078402septage
septate9511872septate
betaine9413783be_taine
betake124512703be_take
biplane1139033biplane
butane8313653_butane
captan101613343captan_
captans111612053captans
centare93113703centare
cetanes9315133ce_tanes
decane93818873de_cane
dentate8315153dentate
dentine83320243dentine
deplaned1238663deplaned
deplanes11311213deplanes
depone93616553dep_one
deprave1337073deprave
destine83719953destine
emplane11410013emplane
enplane939723enplane
estate64719763_estate
etape74413703_e_tape
ethane94613243_ethane
extant132714753_extant
germane1049663germane
gestate83614073gestate
hapten115312983hapten_
haptenes133810823haptenes
haptens124511343haptens
hastate10313913hastate
heatable131612043heatable
heathen133410893heathen
heating114024323heating
heave114521813he__ave
hebetate1347053hebetate
hectares1338853hectares
hefting144510913hefting
hektares1535813hektares
helotage1245713helotage
helpmate1545603helpmate
hematine131614673hematine
hemline12311073hemline
henbanes1336573henbanes
henting113719653henting
hepatic141712773hepatic
hepatize2248233hepatize
hepcat13611823hepca_t
hepcats1436473hepcats
heptagon1443573heptagon
heptagons1543453heptagons
heptarch1843563heptarch
heptoses1338373heptoses
herbage1337003herbage
heritage1246533heritage
hermae115314473herma_e
heroine103517483heroine
hesitance1445553hesitance
hesitant1149083hesitant
hesitate1169973hesitate
hetman112510603hetman_
hetmans12187593hetmans
hexade17438903he_xade
hexanes17319463he_xanes
hexone16289233he_xone
hipbone1445923hipbone
hipline12311423hipline
histone10312843histone
hogmane1336343hogmane
hostage113111233hostage
humane112812173h_umane
hyphae1746433hypha_e
ketene106613003ke_tene
ketone105014533ke_tone
lepta75714393lepta__
leptin82512333leptin_
leptins92412693leptins
lepton82510803lepton_
leptons91910433leptons
meltage1037953meltage
metage93114453me_tage
metate82720533me_tate
methane123211793methane
montane91313623montane
octane81411633_octane
pane64950293__p_ane
pectase112410363pectase
pectate112214693pectate
peltate92013773peltate
pentanes10316083pentanes
pentene9313793pentene
pepsine11310603pepsine
peptalk1554823peptalk
peptide122910683peptide
peptize20279483peptize
peptones12311033peptones
phytane1545443phytane
plane74929143__plane
platane93112303platane
recane83022873re_cane
repand95316063rep_and
repanel939963rep_anel
repave114813873rep_ave
repine85627813rep_ine
replace113214283replace
replan83215823replan_
replans92814943replans
replant93318533replant
replate93420053replate
reptile93914083reptile
restage83316193restage
restate73824883restate
retake104718533re_take
retape83917683re_tape
retene69224273re_tene
retine66237333re_tine
retune69121953re_tune
reuptake1443463reuptake
seaplane1049163seaplane
seitan62613233seitan_
seitans73312303seitans
septa75518083septa__
septages1168263septages
septal84513383septa_l
septime1138803septime
sestine73017923sestine
setae56026223se_ta_e
sextan13389643sextan_
sextans14349263sextans
sextant142911963sextant
sheitan1036573sheitan_
sheitans1155603sheitans
soutane7312063soutane
stane55933003__stane
tentage81010643tentage
terrane72814233terrane
testae64216253testa_e
testate73916233testate
tetany959843te_tany
triptane1047563triptane
uptake1236963_uptake
ventage11109623ventage

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.420425454.8
2DLD Change Limit1340271566.81319672.2
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.29624491.6
 
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.