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

173 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
provider143670(None) 
provide1339851provide_
provided1536841provided
providers1535591providers
provides1439881provides
broider103912972bro_ider
presider11410422presider
privier122910452privi_er
prodder1147952pro_dder
profiler13287642profiler
profiter132710202profiter
promiser122510672promiser
prosier93817482prosi_er
prouder10310382pro_uder
provender1544892provender
prover113819722prov__er
provident1546222provident
provoker1784912provoker
arider74717743ar__ider
avoider1155813avo_ider
braider105112993br_aider
brevier1237763brevi_er
broader103412613bro_ader
broiders114211193bro_iders
broidery14356083bro_idery
broiler92911753bro_iler
bromide12269583bromide_
bromides13219363bromides
brooder103811623bro_oder
broodier1157433broodier
crosier94116573crosi_er
crowder13389863cro_wder
crozier18369933crozi_er
divider12278953_divider
drover104614593drov__er
grodier939673grodi_er
groovier1233793groovi_er
grounder1047613grounder
groveler12305843groveler
horrider1236533horrider
improviser1773313improviser
oroide7311703oro_ide_
oroides8311973oro_ides
paviser12489093p_aviser
peroxide1848183peroxide_
peroxided2045073peroxided
peroxides1947493peroxides
pervader1444863pervader
phonier122710633phoni_er
plodder1146003plo_dder
plover115312613plov__er
poiser84217243p_o_iser
pokier124914633p_oki_er
polder94019253p_o_lder
policer113112683p_olicer
politer92417073p_oliter
ponder94521693p_o_nder
porkier133712343porki_er
pornier93413133porni_er
pounder103314003p_ounder
powder123611903p_o_wder
poxier153812113p_oxi_er
praiser93413943pr_aiser
preciser123411663preciser
preluder1135733preluder
premier113515633premi_er
preorder1136463preorder
preside10715613preside_
presided12410553presided
presiders1248213presiders
presides11414913presides
prevailer1445153prevailer
preview1536473previ_ew
previewer1743023previewer
previse123713793previse_
prevised143611073prevised
previses133814283previses
previsor13116303previsor
pricer103918293pr__icer
pricier113313113prici_er
pride84724733pr__ide_
prided103618033pr__ided
prides94324183pr__ides
prier75027763pr__i_er
primer105118683pr__imer
privater13158533privater
privies122414263privi_es
prizer174714883pr__izer
prober104516073pro__ber
proceeder1444173proceeder
procurer1235833procurer
prodded1257733pro_dded
prodders1237463pro_dders
producer1355843producer
profaner13197943profaner
proffer15126933pro_ffer
profile123211153profile_
profiled14338523profiled
profilers14236293profilers
profiles133211233profiles
profited14279973profited
profiteer14274493profiteer
profiters14228313profiters
progger11319373pro_gger
proline92321593proline_
prolines102619693prolines
promine112819443promine_
promines123018803promines
promise113415843promise_
promised133010873promised
promisee122711333promisee
promisers13268203promisers
promises122916763promises
promisor12266183promisor
promodern1444133promodern
promoter12311453promoter
prompter1437983prompter
proofer12149103pro_ofer
proper104319953pro__per
properer1259203properer
propine113020213propine_
propined133111503propined
propines122618933propines
proposer121810633proposer
proser84223463pro__ser
prosper114012193pro_sper
proteide11239723proteide_
proteides12238783proteides
protoderm1445303protoderm
prove104823193prov__e_
proved125016033prov__ed
proven114314773prov__en
provenders1644273provenders
proverb14378213prov__erb
provers123817793prov__ers
proves114322253prov__es
providence1854093providence
providing1637963providing
province1546923province
provinces1646853provinces
proving134214073provi_ng
proviral1346493proviral
provirus1345453provirus
proviso1237313provi_so
provisoes1446653provisoes
provisory1744353provisory
provisos1336913provisos
provoke1676123provoke_
provoked1875053provoked
provokers1894203provokers
provokes1776603provokes
prower114218123pro__wer
prowler123310013pro_wler
proxies163014933proxi_es
raider74318743_r_aider
rapider1067903_rapider
resider84615803_resider
reviler104314973_reviler
reviser104114663_reviser
reviver134411373_reviver
rider65231303_r__ider
ropier84118803_ropi_er
rosier64221263_rosi_er
rotifer1036993_rotifer
rounder83514603_rounder
rover85527373_rov__er
rowdier11348593_rowdier
solider82912453_solider
stolider936603stolider
torrider936173torrider
trover95014663trov__er
vivider14265623_vivider
voider103611553_vo_ider

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.436409841.7
2DLD Change Limit1461621737.28320068.9
3Display Results1731730.0602883.3
 (SQL Overall)1786911737.77922970.9
 
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.