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

122 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
providers153559(None) 
provider1436701provider_
provides1439881provide_s
broiders114211192bro_iders
presiders1248212presiders
prodders1237462pro_dders
profilers14236292profilers
profiters14228312profiters
promisers13268202promisers
provenders1644272provenders
provers123817792prov__ers
provide1339852provide__
provided1536842provide_d
provident1546222provident
provokers1894202provokers
avoiders1254793avo_iders
braiders114110573br_aiders
breviers1335923brevi_ers
broider103912973bro_ider_
broidery14356083bro_idery
broilers103210093bro_ilers
bromides13219363bromide_s
brooders112610243bro_oders
crosiers103312063crosi_ers
crowders14398803cro_wders
croziers19287003crozi_ers
dividers13257213_dividers
drovers115212643drov__ers
grounders1156783grounders
grovelers13305163grovelers
improvisers1892773improvisers
oroides8311973oro_ide_s
pavisers13387443p_avisers
peroxides1947483peroxide_s
pervaders1544433pervaders
plodders1235523plo_dders
plovers123611833plov__ers
poisers94214433p_o_isers
polders103617373p_o_lders
policers12259993p_olicers
ponders103618843p_o_nders
pounders113113283p_ounders
powders134111553p_o_wders
praisers103410833pr_aisers
preluders1234423preluders
premiers122911653premi_ers
preorders1235403preorders
presider11410423presider_
presides11414913preside_s
prevailers15123833prevailers
previewers1842563previewers
previews1634513previ_ews
previses133814283previse_s
previsors14126483previsors
pricers113915063pr__icers
prides94324183pr__ide_s
priers84521193pr__i_ers
primers114215673pr__imers
privier122910453privi_er_
privies122414263privi_e_s
prizers183911843pr__izers
probers113514583pro__bers
proceeders1543603proceeders
procurers1345033procurers
prodder1147953pro_dder_
producers1454883producers
profaners14256213profaners
proffers16126593pro_ffers
profiler13287643profiler_
profiles133211233profile_s
profiteers15213693profiteers
profiter132710203profiter_
proggers12258163pro_ggers
prolines102619693proline_s
promines123018803promine_s
promisees13246863promisees
promiser122510673promiser_
promises122916763promise_s
promisors13236363promisors
promodern1444133promodern
promoters13310093promoters
prompters1537553prompters
proofers13118363pro_ofers
propers113619033pro__pers
propines122618933propine_s
proposers13228523proposers
prosers94219643pro__sers
prosier93817483prosi_er_
prosiness11311683prosiness
prospers123012263pro_spers
proteides12238783proteide_s
protoderm1445303protoderm
protoderms1544403protoderms
prouder10310383pro_uder_
provender1544893provender_
prover113819723prov__er_
proverb14378213prov__erb
proverbs15315583prov__erbs
proves114322253prov__e_s
providence1854093providence
providences1953823providences
providing1637963providing
provinces1646853provinces
provirus1345453provi_rus
provisoes1446653provisoes
provisory1744353provisory
provisos1336913provi_sos
provoker1784913provoker_
provokes1776603provoke_s
prowlers13328933pro_wlers
proxies163014933proxi_e_s
raiders84615143_r_aiders
residers93311883_residers
revilers114011693_revilers
revisers113511933_revisers
revivers14389633_revivers
riders74123903_r__iders
rotifers1136043_rotifers
rounders92613693_rounders
rovers95423523_rov__ers
trovers103713323trov__ers
voiders11279823_vo_iders

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411226.56322648.3
3Display Results1221220.0462652.2
 (SQL Overall)1786911226.77926359.5
 
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.