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

186 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
procure113857(None) 
precure11312551precure
procured1336601procured
procurer1235831procurer
procures1239211procures
brochure1544352brochure
precured1339992precured
precures12312902precures
procarp1346822procarp
procedure1443382procedure
procural1246922procural
procurers1345032procurers
procuress1344092procuress
produce1267512produce
profuse1237152profuse
armure8710133ar_mure
arouse65019983aro_use
bordure1035783bordure
bravure1254393bravure
brocade1238533brocade
broche133612103broc_he
brochures1644413brochures
brogue94211033brogu_e
closure9278483closure
cloture9238453cloture
colure8314163_colure
crocine11314153crocine
crocus104813173crocu_s
crocuses1239023crocuses
crore74922873cro__re
croupe105114433cro_upe
crouse84619363cro_use
croute84617273cro_ute
cure66149123___cure
drogue8938333drogu_e
epicure1136823epicure
erasure736943erasure
fracture13147133fracture
frore86218803fro__re
gravure1134953gravure
grocer94212143grocer_
grocers103511253grocers
grocery13336763grocery
grouse74315023gro_use
kronur10415313kronur_
locule83412033_locule
obscure1145333obscure
ochre103411593__ochre
ordure756813or_dure
parure8312523p_arure
pasture9311463pasture
pedicure1345183pedicure
perdure10379623perdure
perjure16327963perjure
phocine1438833phocine
picture1158613picture
pirogue1045413pirogu_e
piroque1844353piroqu_e
porcine11312843porcine
pore66451263p_o__re
posture9313253posture
pour611527473p_o_ur_
poured95116743p_o_ured
pourer84516043p_o_urer
pours74623183p_o_urs
precede1239653precede
precipe133012123precipe
precise113518173precise
preclude1344903preclude
precode12311853precode
precut102016533precu_t
precuts111710473precuts
prefire124012813prefire
prelude1038013prelude
premune1138933premune
prepare111913623prepare
prepuce1337833prepuce
prescore124812373prescore
pressure1039773pressure
presume11310303presume
prevue1179163prevu_e
prewire124311143prewire
price93725413pric__e
pricer103918293pricer_
pricers113915063pricers
pricier113313113pricier
pricker154013413pricker
prickle153611013prickle
prisere9310943prisere
probate11414483probate
probe94320813pro__be
prober104516073prober_
probers113514583probers
procaine12312273procaine
procarps1445973procarps
procedures1543373procedures
proceed12310553proceed
process11310403process
prochurch2151913prochurch
proctor11310433proctor
proctored1446413proctored
proctors12311513proctors
procurable1644863procurable
procurals1355283procurals
procuring1437993procuring
prodder1147953prodder
prodrug1142953prodrug
produced1456073produced
producer1355843producer
produces1347903produces
product1279233product
proette9312363proette
profane122111863profane
proffer15126933proffer
profile123211153profile
progger11319373progger
progun968783progu_n
prolate9419793prolate
prole74527793pro__le
proline92321593proline
promine112819443promine
promise113415843promise
promote11313143promote
promulge1343043promulge
pronate9418873pronate
prone75332623pro__ne
proofer12149103proofer
propane112716153propane
propene112716043propene
proper104319953proper_
properer1259203properer
propers113619033propers
propine113020213propine
propone112716303propone
propose112714843propose
prorate9418733prorate
prose75835123pro__se
prosecute1345953prosecute
proser84223463proser_
prosers94219643prosers
prosier93817483prosier
prosper114012193prosper
prossie91812953prossie
prostie91617743prostie
protege1059153protege
protrude1144703protrude
protyle12229453protyle
proud84615483pro_u_d
prouder10310383pro_uder
prove104823193pro__ve
prover113819723prover_
proverb14378213proverb
provers123817793provers
provide1339853provide
provoke1676123provoke
prowar114110943prowar_
prower114218123prower_
prowler123310013prowler
prude84615973pr__ude
prune75119633pr__une
puncture1245053puncture
pure65543333p___ure
purpure1195993purpure
rasure6311423_rasure
recur74116843_recur_
recurs83315803_recurs
recurve1237403_recurve
recuse85519163_recuse
rocker124319573_rocker
rogue66417533_rogu_e
rondure837313_rondure
roque144812133_roqu_e
rouche114714313_rouche
roue45941743_ro_u_e
rouge65423443_ro_uge
rouse56634703_ro_use
route55132073_ro_ute
secure8513533_secure
stoure64814943sto_ure
torture738593torture
trocar848773trocar_
trocars959043trocars
troche113112513troc_he
trochee122613883trochee
troupe84812433tro_upe
uprouse937223upro_use

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.406440125.6
2DLD Change Limit1340271866.42020876.5
3Display Results1861860.0632952.4
 (SQL Overall)1786911866.88925938.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.