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

248 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
provides143988(None) 
provide1339851provide_
provided1536841provided
provider1436701provider
providers1535591providers
bromides13219362bromides
oroides8311972oro_ides
peroxides1947492peroxides
presides11414912presides
previses133814282previses
prides94324182pr__ides
privies122414262privi_es
profiles133211232profiles
prolines102619692prolines
promines123018802promines
promises122916762promises
propines122618932propines
proteides12238782proteides
proves114322252prov__es
provident1546222provident
provinces1646852provinces
provirus1345452provirus
provisoes1446652provisoes
provisos1336912provisos
provokes1776602provokes
proxies163014932proxi_es
aroids75118223aro_id_s
biocides1336933biocides
bolides10515073_bolides
borides10515153_borides
bovids1287973_bovid_s
bovines12412663_bovines
brides94423513br__ides
brocades1358713brocades
broider103912973bro_ider
broiders114211193bro_iders
bromide12269583bromide_
bromids12278603bromid_s
bromines122514253bromines
bromizes21258333bromizes
chromides1747603chromides
corvids1337683corvid_s
crevices1536713crevices
cronies9622503croni_es
crowdies1437553crowdies
dioxides1756203dioxides
divides123211453_divides
droids84712583dro_id_s
droves105116673drov__es
ecocides1346583ecocides
epoxides1844863epoxides
erodes74819883ero__des
erotizes17311213erotizes
gravidas13285803gravidas
gravies11314093gravi_es
grides84422363gr__ides
groves104318103grov__es
improvises1784593improvises
iodides93811613_iodides
irides74519123ir__ides
ironies7517423ironi_es
ironizes17510373ironizes
ironsides1045293ironsides
jarovizes2843993jarovizes
movies115118453_movi_es
novices1238223_novices
oreides8312023or_eides
oroide7311703oro_ide_
ovines94614343__ovines
oxides14109693__oxides
ozonides1854293ozonides
parodies11313693parodi_es
parotids112610413parotid_s
parvises133911913parvises
pavises125315493p_avises
peavies122213403peavi_es
pelvises1337273pelvises
peonies93620153peoni_es
peptides132610263peptides
peroxide1848183peroxide_
peroxided2045073peroxided
peroxids1837453peroxid_s
pervades1437353pervades
phonies123717513phoni_es
pirogies1139423pirogi_es
ploidies1138173plo_idies
plosives1335893plosives
podites103014733p_odites
pogies94123543p_ogi_es
poises84226543p_o_ises
pokies125921333p_oki_es
polices113118053p_olices
polies84034583p_oli_es
pomades123711733p_omades
ponies84833463p_oni_es
poolsides1254553poolsides
pooves113914713poov__es
porgies103017003porgi_es
porkies133416493porki_es
porridges1343913porridges
posies84431433p_osi_es
praises94121103pr_aises
pralines102217723pralines
praxises1739063praxises
prebids12399883prebid_s
precedes13310713precedes
precipes143212213precipes
precises123218333precises
precodes13711573precodes
prefades1439533prefades
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
preguides1344863preguides
prelives13310383prelives
preludes1137833preludes
premies113823063premi_es
premises123018273premises
premixes193110083premixes
preside10715613preside_
presided12410553presided
presider11410423presider
presiders1248213presiders
preview1536473previ_ew
previews1634513previews
previous1337823previous
previse123713793previse_
prevised143611073prevised
prevues1239263prev_ues
prewires133811013prewires
prexies163415003prexi_es
prices104524543pr__ices
pride84724733pr__ide_
prided103618033pr__ided
pries74339533pr__i_es
primes104225263pr__imes
primines123013703primines
priories10312453priori_es
prises84133173pr__ises
privates131812373privates
privier122910453privi_er
priviest132310313privi_est
privities14312043privities
prizes173819813pr__izes
probates12414283probates
probes104119453pro__bes
probities13312653probities
probits112712573probi_ts
procaines13311523procaines
proceeds1335983proceeds
proclises1339543proclises
procures1239213procures
prodded1257733pro_dded
prodder1147953pro_dder
prodders1237463pro_dders
prodigies1346953prodigies
prods85523553pro__d_s
produces1347903produces
proettes10312763proettes
profanes132311573profanes
profile123211153profile_
profiled14338523profiled
profiler13287643profiler
profilers14236293profilers
profited14279973profited
profiter132710203profiter
profiters14228313profiters
profits122911243profi_ts
proles84627203pro__les
proline92321593proline_
promine112819443promine_
promise113415843promise_
promised133010873promised
promisee122711333promisee
promisees13246863promisees
promiser122510673promiser
promisers13268203promisers
promotes12314123promotes
pronates10418373pronates
propanes122415823propanes
propenes122816513propenes
propine113020213propine_
propined133111503propined
propones122516963propones
proposes122515973proposes
prorates10418073prorates
proses84733473pro__ses
prosier93817483prosi_er
prosiest10416523prosi_est
prosiness11311683prosiness
prosodies1249733prosodies
prosses94019513pro_sses
prossies101515223prossies
prosties101421193prosties
protases102115033protases
proteges1149923proteges
proteide11239723proteide_
proteids11259943proteid_s
protists10313363protists
protiums1238553protiums
protoxides2046283protoxides
protrudes1245173protrudes
protyles13249833protyles
prouder10310383pro_uder
proudest1138943pro_udest
prove104823193prov__e_
proved125016033prov__ed
proven114314773prov__en
provender1544893provender
provenders1644273provenders
prover113819723prov__er
proverbs15315583proverbs
provers123817793prov_ers
providence1854093providence
providences1953823providences
providing1637963providing
province1546923province
proving134214073provi_ng
proviral1346493proviral
proviruses1554513proviruses
proviso1237313provi_so
provoke1676123provoke_
provoked1875053provoked
provoker1784913provoker
provokers1894203provokers
provosts1336083provosts
prudes94215443pr__udes
psocids1234863psocid_s
pyrolizes2347233pyrolizes
pyronines1458323pyronines
pyrosises1457583pyrosises
pyxides2034423p_yxides
ravines104220233_ravines
resides84523283_resides
reviles104421353_reviles
revises104220533_revises
revives134715543_revives
rides66140813_r__ides
roadies83317443_roadies
rodes614039083_ro__des
roves84834483_rov__es
rovings11439493_rovings
rowdies113112693_rowdies
trioxides1744483trioxides
tropines102214923tropines
troves94719113trov__es
uranides92211283uranides
ureides8311103ur_eides

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622486.68621860.9
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.20224811.3
 
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.