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

182 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
procures123921(None) 
precures12312901precures
procure1138571procure_
procured1336601procured
procurer1235831procurer
procurers1345031procurers
procuress1344091procuress
brochures1644412brochures
crocuses1239022crocuses
precure11312552precure_
precured1339992precured
procarps1445972procarps
procedures1543372procedures
procural1246922procural
procurals1355282procurals
produces1347902produces
arcuses94814693ar_cuses
armures9510273ar_mures
arouses74921293aro_uses
bordures1136173bordures
brocades1358713brocades
brochure1544353brochure_
brogues10719823brogu_es
closures10228953closures
clotures10299023clotures
colures9315143_colures
crocus104813173crocu__s
crores86121163cro__res
crouches153711293crouches
croupes114613103cro_upes
croutes94815653cro_utes
cures75645433___cures
drogues9398393drogu_es
epicures1246513epicures
erasures837213erasures
focuses12159653_focuses
fractures14147233fractures
gravures1234903gravures
groceries1249503groceries
grocers103511253grocer_s
grouches14328213grouches
grouses84616543gro_uses
hocuses121710423_hocuses
locules92812603_locules
obscures1245513obscures
ochres113510833__ochres
ordures856473or_dures
parures9512693p_arures
pastures10311963pastures
pedicures1445263pedicures
perdures11289683perdures
perjures17268083perjures
pictures1249343pictures
pirogues1135473pirogu_es
piroques1944353piroqu_es
pooches143214163pooc_hes
porches143815673porc_hes
pores75849033p_o__res
postures10313783postures
pouches144116743p_ouches
poured95116743p_o_ured
pourer84516043p_o_urer
pourers93513673p_o_urers
pours74623183p_o_ur_s
precedes13310713precedes
precipes143212213precipes
precises123218333precises
precludes1445053precludes
precodes13711573precodes
precuts111710473precu_ts
prefires134313283prefires
prefocuses1744243prefocuses
preludes1137833preludes
prepares122014163prepares
prepubes1436053prepubes
prepuces1438583prepuces
prescores133912173prescores
pressures1149063pressures
presumes1239843presumes
prevues1239263prevu_es
prewires133811013prewires
pricers113915063pricer_s
prices104524543pric__es
prickers163710673prickers
prickles162511093prickles
primuses1237083primuses
priseres10310823priseres
probates12414283probates
probers113514583prober_s
probes104119453pro__bes
procaines13311523procaines
procarp1346823procar_p
procedure1443383procedure_
proceed12310553proc_eed
proceeds1335983proceeds
process11310403proc_ess
processes13310233processes
prochurch2151913prochurch
proclises1339543proclises
proctored1446413proctored
proctors12311513proctors
procuresses1543813procuresses
procuring1437993procuring
prodders1237463prodders
prodrugs1242483prodrugs
produce1267513produce_
produced1456073produced
producer1355843producer
producers1454883producers
products1376513products
proettes10312763proettes
profanes132311573profanes
proffers16126593proffers
profiles133211233profiles
profuse1237153profuse_
proggers12258163proggers
progress1137023pro_gress
proles84627203pro__les
prolines102619693prolines
promines123018803promines
promises122916763promises
promotes12314123promotes
promulges1443383promulges
pronates10418373pronates
proofers13118363proofers
propanes122415823propanes
propenes122816513propenes
properer1259203properer
properest1349663properest
propers113619033proper_s
propines122618933propines
propones122516963propones
proposes122515973proposes
prorates10418073prorates
prosecutes1445663prosecutes
prosers94219643proser_s
proses84733473pro__ses
prospers123012263prospers
prosses94019513pro_sses
prossies101515223prossies
prosties101421193prosties
protases102115033protases
proteges1149923proteges
proteuses11238993proteuses
protrudes1245173protrudes
protyles13249833protyles
prouder10310383pro_uder
proudest1138943pro_udest
proverbs15315583proverbs
provers123817793prover_s
proves114322253pro__ves
provides1439883provides
provirus1345453provirus
provokes1776603provokes
prowlers13328933prowlers
proxies163014933pro_xies
prudes94215443pr__udes
prunes83419063pr__unes
prunuses1035123prunuses
punctures1345343punctures
purpures1276143purpures
rasures7312013_rasures
recurs83315803_recur_s
recurves1337403_recurves
recuses94619463_recuses
rockers133916553_rockers
rogues74617673_rogu_es
rondures937713_rondures
roques154912563_roqu_es
rouches124217893_rouches
roues56039353_ro_u_es
rouges76022383_ro_uges
rouses65436283_ro_uses
routes66129313_ro_utes
secures9613163_secures
stoures74614163sto_ures
tortures838913tortures
trocars959043trocar_s
trochees132510183trochees
troches123715343troc_hes
troupes94112853tro_upes
uprouses1037553upro_uses

Search took 9 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.406440125.6
2DLD Change Limit1461621828.47017256.4
3Display Results1821820.0762394.7
 (SQL Overall)1786911828.95219961.0
 
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.