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

262 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
provide133985(None) 
provided1536841provided
provider1436701provider
provides1439881provides
bromide12269582bromide
oroide7311702oro_ide
peroxide1848182peroxide
preside10715612preside
previse123713792previse
pride84724732pr__ide
profile123211152profile
proline92321592proline
promine112819442promine
promise113415842promise
propine113020212propine
proteide11239722proteide
prove104823192prov__e
proved125016032proved_
provident1546222provident
providers1535592providers
province1546922province
proving134214072proving
proviso1237312proviso
provoke1676122provoke
aroid65428343aro_id_
aroids75118223aro_ids
biocide1237323biocide
bolide9515563_bolide
boride9415903_boride
bovid111011623_bovid_
bovids1287973_bovids
bovine11712433_bovine
bride86425533br__ide
brocade1238533brocade
broider103912973bro_ider
bromid112612893bromid_
bromides13219363bromides
bromids12278603bromids
bromine112915243bromine
bromize20238823bromize
chromide1648053chromide
corvid12310473corvid_
corvids1337683corvids
corvine122113643corvine
crevice1436153crevice
crocine11314153crocine
crowdie1335913crowdie
dioxide1656303dioxide
divide113410893_divide
droid74218543dro_id_
droids84712583dro_ids
drove95518063drov__e
droved114611643droved_
droving12379683droving
ecocide1246733ecocide
epoxide1745343epoxide
erode64520993ero__de
erosive1039193erosive
erotize16311663erotize
gravid113710983gravid_
gravida12366563gravida
gravidae13324793gravidae
gride75223583gr__ide
grove95219333grov__e
groved114413703groved_
improvise1674853improvise
iodide84812933_iodide
ironize16610373ironize
ironside945853ironside
jarovize2743763jarovize
movie105319133_movi_e
novice1138433_novice
oreide7311673or_eide
oroides8311973oro_ides
ovine86316643__ovine
oxide131210953__oxide
ozonide1754963ozonide
parodied1238333parodied
parotid102915513parotid_
parotids112610413parotids
parvise124211693parvise
pavid115717003p_avid_
pavise114714803p_avise
peptide122910683peptide
peroxid17310273peroxid_
peroxided2045073peroxided
peroxides1947493peroxides
peroxids1837453peroxids
pervade1337023pervade
phocine1438833phocine
phonied133710563phonied
ploidy1237483plo_idy
plosive1236673plosive
podite93315353p_odite
poise75127893p_o_ise
police102918563p_olice
polite83625073p_olite
pomade113611333p_omade
ponied94920703p_onied
poolside1145043poolside
poove104514303poov__e
porcine11312843porcine
porridge1243763porridge
portside1138163portside
praise84419413pr_aise
praline93019743praline
prebade12310283prebade
prebid113512843prebid_
prebids12399883prebids
precede1239653precede
precipe133012123precipe
precise113518173precise
precode12311853precode
predive13511083predive
prefade1339013prefade
prefile123413183prefile
prefire124012813prefire
preguide1255423preguide
prelife1279943prelife
prelude1038013prelude
premade12311443premade
premie103617993premi_e
premise113818553premise
presided12410553presided
presider11410423presider
presides11414913presides
preview1536473preview
prevised143611073prevised
previses133814283previses
prevue1179163prev_ue
prevued1337143prevued
prewire124311143prewire
price93725413pr__ice
prided103618033pr__ided
prides94324183pr__ides
pried84426863pr__ied
prime96525603pr__ime
primine113214823primine
prise74632613pr__ise
private121513263private
privier122910453privier
privies122414263privies
privily15207623privily
privity15268313privity
prize164718943pr__ize
probate11414483probate
probe94320813pro__be
probed114114823probed_
probing123314443probing
probit103218353probi_t
probits112712573probits
probity14299683probity
procaine12312273procaine
proceed12310553proceed
procure1138573procure
prod76129503pro__d_
prodded1257733pro_dded
prodder1147953pro_dder
prodigy1435573prodigy
prods85523553pro__ds
produce1267513produce
proette9312363proette
profane122111863profane
profiled14338523profiled
profiler13287643profiler
profiles133211233profiles
profit113016273profi_t
profited14279973profited
profiter132710203profiter
profits122911243profits
profuse1237153profuse
progged12409803progged
prograde1247183prograde
prolate9419793prolate
prole74527793pro__le
prolines102619693prolines
prolix1538683proli_x
promines123018803promines
promised133010873promised
promisee122711333promisee
promiser122510673promiser
promises122916763promises
promoed12310083promoed
promote11313143promote
pronate9418873pronate
prone75332623pro__ne
pronged113912393pronged
proofed13138723proofed
propane112716153propane
propene112716043propene
propined133111503propined
propines122618933propines
propone112716303propone
propose112714843propose
propped113311953propped
prorate9418733prorate
prose75835123pro__se
prosed94921093prosed_
prosier93817483prosier
prosily12611633prosily
prosing103319383prosing
prosit85124593prosi_t
prosody1336433prosody
prossie91812953prossie
prostie91617743prostie
protege1059153protege
proteid103513673proteid_
proteides12238783proteides
proteids11259943proteids
protist9320223protist
protium11312293protium
protoxide1946823protoxide
protrade1148213protrade
protrude1144703protrude
protyle12229453protyle
proud84615483pro_ud_
prouder10310383pro_uder
provable1539093provable
proven114314773prov_en
provender1544893provender
prover113819723prov_er
proverb14378213proverb
provers123817793provers
proves114322253prov_es
providence1854093providence
providing1637963providing
provinces1646853provinces
proviral1346493proviral
provirus1345453provirus
provisoes1446653provisoes
provisos1336913provisos
provoked1875053provoked
provoker1784913provoker
provokes1776603provokes
provost1238573provost
prowled13309913prowled
proxies163014933proxies
proximo1845143proximo
prude84615973pr__ude
psocid1137253psocid_
psocids1234863psocids
pyoid11513763pyo_id_
pyrolize2248133pyrolize
pyronine1349513pyronine
ravine95522223_ravine
reside74224933_reside
revile94921613_revile
revise94019743_revise
revive124914823_revive
ride55945133_r__ide
roadie72813813_roadie
rode55844303_ro__de
rove75136983_rov__e
roved95323553_roved_
roving103618743_roving
trioxide1644793trioxide
trode65322853tro__de
tropine93116653tropine
trove85221923trov__e
uranide82212093uranide
ureide7310363ur_eide
vide85432763___vide

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.403443402.0
2DLD Change Limit1340272626.31321230.3
3Display Results2622620.0962729.2
 (SQL Overall)1786912626.81226231.8
 
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.