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 “providet” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
provide1339851provide_
provided1536841provided
provident1546221provident
provider1436701provider
provides1439881provides
providers1535592providers
broider103912973bro_ider
bromide12269583bromide_
bromides13219363bromides
improvident1952833improvident
oroide7311703oro_ide_
oroides8311973oro_ides
peroxide1848183peroxide_
peroxided2045073peroxided
peroxides1947493peroxides
preside10715613preside_
presided12410553presided
president12410993president
presider11410423presider
presides11414913presides
preview1536473previ_ew
previse123713793previse_
prevised143611073prevised
previses133814283previses
previsit13410073previsit
pride84724733pr__ide_
prided103618033pr__ided
prides94324183pr__ides
privet113821343pr__ivet
privier122910453privi_er
privies122414263privi_es
priviest132310313priviest
probit103218353probi__t
prodded1257733pro_dded
prodder1147953pro_dder
profile123211153profile_
profiled14338523profiled
profiler13287643profiler
profiles133211233profiles
profit113016273profi__t
profited14279973profited
profiter132710203profiter
prohibit1547193prohibit
projet15315183pro__jet
proline92321593proline_
prolines102619693prolines
promine112819443promine_
prominent1349573prominent
promines123018803promines
promise113415843promise_
promised133010873promised
promisee122711333promisee
promiser122510673promiser
promises122916763promises
prophet14316033pro_phet
propine113020213propine_
propined133111503propined
propines122618933propines
propjet1839913pro_pjet
prosier93817483prosi_er
prosiest10416523prosiest
prosit85124593prosi__t
proteide11239723proteide_
proteides12238783proteides
protist9320223proti_st
prouder10310383pro_uder
proudest1138943pro_udest
prove104823193prov__e_
proved125016033prov__ed
proven114314773prov__en
provender1544893provender
prover113819723prov__er
proves114322253prov__es
providence1854093providence
providently2053193providently
providing1637963providing
province1546923province
provinces1646853provinces
proving134214073provi_ng
proviral1346493proviral
provirus1345453provirus
proviso1237313provi_so
provisoes1446653provisoes
provisos1336913provisos
provoke1676123provoke_
provoked1875053provoked
provoker1784913provoker
provokes1776603provokes
provost1238573prov_ost
proxies163014933proxi_es
soviet9720153_sovi_et

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.420425454.8
2DLD Change Limit146162918.33017546.5
3Display Results91910.0461978.3
 (SQL Overall)178691918.79620315.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.