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

86 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
provokers189420(None) 
provoker1784911provoker_
provokes1776601provoke_s
promoters13310092promoters
proofers13118362pro_ofers
proposers13228522proposers
provers123817792prov__ers
providers1535592providers
provoke1676122provoke__
provoked1875052provoke_d
revokers15366752_revokers
bookers134016613_bo_okers
brokers133111913br__okers
brooders112610243bro_oders
convokers18246103convokers
cookers134619463_co_okers
croakers14288523cro_akers
crooker134111093cro_oker_
crookery17415993cro_okery
crooners103911393cro_oners
drovers115212643drov__ers
evokers14386793__evokers
frivolers1543473frivolers
groomers11388483gro_omers
groovers12337123gro_overs
grovelers13305163grovelers
hookers144916513_ho_okers
invokers1534673_invokers
lookers114014073_lo_okers
plovers123611833plov__ers
pokers124617923p___okers
poolers94217423p_o_olers
popovers1595663p_opovers
porkers134314933p_o_rkers
precookers1843063precookers
prickers163710673pr_ickers
prinkers143010383pr_inkers
prisoners1147373prisoners
probers113514583pr__obers
procurers1345033procurers
prodders1237463pro_dders
producers1454883producers
profaners14256213profaners
proffers16126593pro_ffers
profilers14236293profilers
profiters14228313profiters
proggers12258163pro_ggers
prolongers13264763prolongers
promisers13268203promisers
promodern1444133promodern
promoter12311453promoter_
promotes12314123promote_s
prompters1537553prompters
proofer12149103pro_ofer_
propers113619033pr__opers
propones122516963propone_s
proposer121810633proposer_
proposes122515973propose_s
prosers94219643pr__osers
prospers123012263pro_spers
protoderm1445303protoderm
protoderms1544403protoderms
provenders1644273provenders
prover113819723prov__er_
proverb14378213prov__erb
proverbs15315583prov__erbs
proves114322253prov__e_s
provider1436703provider_
provides1439883provide_s
provoking1935133provoking
provosts1336083provo_sts
prowlers13328933pro_wlers
revoker14419193_revoker_
revokes144212503_revoke_s
rockers133916553_ro_ckers
roofers105013903_ro_ofers
rookery14398313_ro_okery
roomers95416413_ro_omers
roosers74217873_ro_osers
rooters74522933_ro_oters
rovers95423523_rov__ers
snookers12398653sno_okers
stookers12449793sto_okers
troopers10289443tro_opers
trovers103713323trov__ers
uprooters1164253upro_oters

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.420425454.8
2DLD Change Limit148641866.37623312.6
3Display Results86860.0302866.7
 (SQL Overall)178691866.82626178.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.