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

257 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
propanes12241582(None) 
profanes132311571profanes
propane112716151propane_
propenes122816511propenes
propines122618931propines
propones122516961propones
prepares122014162prepares
prepaves15189192prepaves
probands13228382probands
probangs13256202probangs
probates12414262probates
procaines13311512procaines
profane122111862profane_
profaned14207972profaned
profaner13197942profaner
profaners14256202profaners
prolans9314272prolan_s
prolines102619692prolines
promines123018802promines
pronates10418372pronates
propends13249172propends
propene112716042propene_
propense122410102propense
prophages1749762prophages
prophases16411062prophases
propine113020212propine_
propined133111502propined
propone112716302propone_
proponed132412032proponed
proposes122515972proposes
prorates10418062prorates
protases102115032protases
tropines102214922tropines
aeroplanes1246883aeroplanes
atropines1148883atropines
boranes93720403_boranes
brocades1358703brocades
brogans1049663brogan_s
brokages1536253brokages
bromates12413133bromates
bromines122514253bromines
chopines152711733chopines
cranes84330753cr__anes
crones84729243cro__nes
croplands1445373croplands
croppies143111133croppies
dioxanes1645373dioxanes
dopants1038433_dopants
drones75023433dro__nes
dropsies1138693dropsies
fromages1437073fromages
frypans1544053frypan_s
groaned9259973gro_aned
groaner82510133gro_aner
groaners9248493gro_aners
groans74815063gro_an_s
gropes95220403grop__es
groynes1137823gro_ynes
gyroplanes1644293gyroplanes
irones64724013iro__nes
nopales93812523_nopales
opines84820703__opines
orpines94414793or_pines
palpates122613063palpates
panes76148693___panes
paravanes1448293paravanes
pavanes123612653p_avanes
pentanes10316073pentanes
peonages1138473peonages
peones83821043peo__nes
peoples11312213peop_les
perorates11417013perorates
phonates13410643phonates
phones114121213pho__nes
phorates13413043phorates
phytanes1645753phytanes
pipages1289423p_ipages
planes85028083p__lanes
platanes102711883platanes
pomaces132712123p_omaces
pomades123711733p_omades
pompanos1445243pompanos
pones74547043p_o__nes
popes95933813p_op__es
poppies102816193p_oppies
popples103011873p_opples
popsies112816463p_opsies
portages112613223portages
portances1349833portances
potages102416423p_otages
pralines102217723pralines
prances113618773pr__ances
prangs94816233pr__angs
pranks124814723pr__anks
prases84429023pr__ases
prates84633163pr__ates
praxes156215183pr__axes
prebakes1639003prebakes
predates11615803predates
prefaces15311063prefaces
prefades1439533prefades
pregames1339003pregames
prelates10418563prelates
prenames12311633prenames
prepacks1836583prepacks
prepare111913623prepare_
prepared132210863prepared
preparer12169643preparer
preparers13197673preparers
prepastes13128823prepastes
prepave14228873prepave_
prepaved16177223prepaved
prepays1437483prepa_ys
prepense12238933prepense
preplaces1578743preplaces
preplans1249613preplan_s
preppies1149673preppies
prepubes1436053prepubes
prepuces1438583prepuces
presages11312203presages
presales10315263presales
pretapes122811533pretapes
primages13159273primages
primates121515933primates
primines123013703primines
priorates11410753priorates
pristanes11410423pristanes
privates131812373privates
proas75028803pro_a__s
probables1545423probables
proband122710243proban_d
probang12278383proban_g
probate11414483probate_
probated13410863probated
probes104119453pro__bes
procaine12312273procaine_
procarps1445973procarps
procures1239213procures
produces1347903produces
proettes10312763proettes
profanely1743743profanely
profiles133211233profiles
progenies12314123progenies
prolamines14159333prolamines
prolan8414693prolan__
prolapse12134913prolapse
prolapses13145573prolapses
prolate9419793prolate_
proles84627203pro__les
proline92321593proline_
prolonges12337923prolonges
prolongs11347613prolongs
promine112819443promine_
promises122916763promises
promotes12314123promotes
promptness1643293promptness
pronate9418873pronate_
pronated11414053pronated
prone75332623pro__ne_
proneness11310443proneness
prongs94314483pro__ngs
propagates1556143propagates
propagules1543393propagules
propel103714063prop__el
propels113412843prop_els
propend123311273propen_d
propended1546163propended
propenol1246473propenol
propenols1346343propenols
propenyl1544583propenyl
proper104319953prop__er
properer1259203properer
properest1349663properest
properness1445923properness
propers113619033prop_ers
prophage1649433prophage_
prophase15410233prophase_
prophesy1844453prop_hesy
prophet14316033prop_het
prophets1539503prophets
propjet1839913prop_jet
propjets1935493propjets
propman1339063propman__
propmen1338763prop_men
propolis12311403propolis
proponent1349443proponent
proponents1445803proponents
propose112714843propose_
proposed132011073proposed
proposer121810633proposer
proposers13228523proposers
propounds1444963propounds
propped113311953prop_ped
props95726883prop___s
proptoses1349873proptoses
propylenes1744373propylenes
propyls14308193prop_yls
prorate9418733prorate_
prorated11513713prorated
proses84733473pro__ses
prosiness11311673prosiness
prosses94019513pro_sses
prossies101515223prossies
prostates11314423prostates
prosties101421193prosties
protamines14149783protamines
protasis102411973protasis
proteans102811543protean_s
proteases112110823proteases
proteges1149923proteges
protends113010353protends
protons93118003proton_s
protyles13249833protyles
proudness1246683proudness
proves114322253pro__ves
provides1439883provides
provinces1646853provinces
provokes1776603provokes
proxies163014933pro_xies
prunes83419063pr__unes
ptomaines1345523ptomaines
pupates113311433p_upates
purslanes1145523purslanes
pyrones123113303pyro__nes
pyronines1458323pyronines
pyropes142210193pyrop__es
pyroxenes2145453pyroxenes
rapines95120863_rapines
recanes93222263_recanes
repanel939963_repanel
repanels1036783_repanels
repaves123513653_repaves
repines94927383_repines
roans54926443_ro_an_s
robands10219853_robands
romaines10512513_romaines
romances12310793_romances
romanos94311473_romanos
romans84620243_roman_s
ropes75940063_rop__es
ropiness102311073_ropiness
rotates72819773_rotates
rowans95715343_rowan_s
teopans939203teopan_s
tolanes74216303_tolanes
topazes1857313_topazes
trapans92812463trapan_s
trepangs11205403trepangs
trepans92311593trepan_s
triplanes1148803triplanes
triptanes1147463triptanes
trolands936413trolands
trones65629283tro__nes
tropes84824353trop__es
trophies13413673trophies
tropine93116653tropine_
tropins93116303tropin_s

Search took 10 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.1731032896.0
2DLD Change Limit1461622579.09316074.1
3Display Results2572570.1102336.4
 (SQL Overall)1786912579.37619058.3
 
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.