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

170 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
provided153684(None) 
provide1339851provide_
provider1436701provider
provides1439881provides
peroxided2045072peroxided
presided12410552presided
prevised143611072prevised
prided103618032pr__ided
prodded1257732pro_dded
profiled14338522profiled
profited14279972profited
promised133010872promised
propined133111502propined
proved125016032prov__ed
provident1546222provident
providers1535592providers
provoked1875052provoked
avoided1235553avo_ided
braided114013213br_aided
brocaded1436353brocaded
broider103912973bro_ider
broiled103811423bro_iled
bromide12269583bromide_
bromides13219363bromides
bromized22215903bromized
brooded113510933bro_oded
creviced1634453creviced
crowded14418793cro_wded
divided13378593_divided
droved114611643drov__ed
drownded14334433drownded
eroded84313583ero__ded
erotized1838553erotized
fronded12388863fro_nded
grided95117043gr__ided
groined92710813gro_ined
grounded1136573grounded
groved114413703grov__ed
groveled13345453groveled
improvised1873563improvised
ironized1858203ironized
jarovized2943413jarovized
loided83414023_lo_ided
oroide7311703oro_ide_
oroides8311973oro_ides
parodied1238333parodi_ed
peroxide1848183peroxide_
peroxides1947493peroxides
pervaded1535373pervaded
phonied133710563phoni_ed
plaided11409643p_laided
plodded1265563plo_dded
podded115012713p_o_dded
poinded11358973p_oinded
poised94918473p_o_ised
policed123212233p_oliced
pomaded13377863p_omaded
ponded105218773p_o_nded
ponied94920703p_oni_ed
posited10511493p_osited
pounded114112793p_ounded
praised104214813pr_aised
preceded1438293preceded
precised133213413precised
precited133013813precited
precoded1438863precoded
prefaded1537823prefaded
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
preguided1443923preguided
preluded1236473preluded
premised133013193premised
premixed20338013premixed
preside10715613preside_
presider11410423presider
presides11414913presides
prevailed1536043prevailed
preview1536473previ_ew
previewed1843423previewed
previse123713793previse_
previses133814283previses
prevued1337143prev_ued
prewired14358473prewired
priced115018883pr__iced
pride84724733pr__ide_
prides94324183pr__ides
pried84426863pr__i_ed
primed115118913pr__imed
prised94322203pr__ised
privier122910453privi_er
privies122414263privi_es
prized184415393pr__ized
probated13410863probated
probed114114823pro__bed
proceed12310553pro_ceed
proceeded1544103proceeded
procured1336603procured
prodder1147953pro_dder
produced1456073produced
profaned14207973profaned
profile123211153profile_
profiler13287643profiler
profiles133211233profiles
profiter132710203profiter
progged12409803pro_gged
proline92321593proline_
prolines102619693prolines
prologed12189213prologed
promine112819443promine_
promines123018803promines
promise113415843promise_
promisee122711333promisee
promiser122510673promiser
promises122916763promises
promoed12310083pro_moed
promoted13310543promoted
prompted1536903prompted
pronated11414053pronated
pronged113912393pro_nged
proofed13138723pro_ofed
propended1546163propended
propine113020213propine_
propines122618933propines
proponed132412033proponed
proposed132011073proposed
propped113311953pro_pped
prorated11513713prorated
prosed94921093pro__sed
prosier93817483prosi_er
proteide11239723proteide_
proteides12238783proteides
protended1336803protended
protruded1343443protruded
prouder10310383pro_uder
prove104823193prov__e_
proven114314773prov__en
provender1544893provender
prover113819723prov__er
proverbed1743813proverbed
proves114322253prov__es
providence1854093providence
providing1637963providing
province1546923province
provinces1646853provinces
proving134214073provi_ng
proviral1346493proviral
provirus1345453provirus
proviso1237313provi_so
provisoes1446653provisoes
provisos1336913provisos
provoke1676123provoke_
provoker1784913provoker
provokes1776603provokes
prowled13309913pro_wled
proxies163014933proxi_es
pyramided1873833pyramided
pyrolized2446123pyrolized
raided85017703_r_aided
ravined115411823_ravined
resided95217703_resided
reviled114417923_reviled
revised113815483_revised
revived144211653_revived
rodded93713703_ro_dded
roiled74320053_ro_iled
rosined84911903_rosined
rounded93013503_rounded
roved95323553_rov__ed
voided114011133_vo_ided

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.420425454.8
2DLD Change Limit1461621706.98620922.1
3Display Results1701700.0762236.8
 (SQL Overall)1786911707.48223882.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.