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

101 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
protesters1216938(None) 
protecters14168251protecters
protester111510481protester_
protestors12169311protestors
presters103419002pr__esters
processers1446002processers
protecter13179102protecter_
protectors142010142protectors
protested12159112proteste_d
protestor11178492protestor_
protests10310492protest__s
protostars1246852protostars
arresters948193ar_resters
attesters935803_attesters
contesters12410183contesters
detesters10298303_detesters
dopesters1237283_dopesters
foresters12312533_foresters
jokesters2044443_jokesters
molesters1198873_molesters
orometers11310423orome_ters
ovotestes1242533ovoteste_s
pesters93827093p___esters
plotters104011553plot__ters
poetasters1245283poetasters
polestars1157283p_olestars
pollsters1137173p_ollsters
polyesters1545233polyesters
posters93928013p_o__sters
potters94024343p_ot__ters
pranksters1653283pranksters
preheaters1557193preheaters
presenters1239863presenters
pressers103215023pr__essers
prester93519623pr__ester_
pretastes11119423pretaste_s
pretenders1345243pretenders
pretested12149113preteste_d
pretests10310013pretest__s
preventers1547393preventers
priestess1145293pr_iestess
proceeders1543603proceeders
processer1346893processer_
processes13310233processe_s
processors1446433processors
proestrus1144843pro_estrus
proettes10312763pro_ette_s
professes1437873professe_s
professors1555253professors
profiters14228313pro_fiters
progestins1348663progestins
projectors21187173projectors
promisers13268203promis_ers
promoters13310093pro_moters
prompters1537553pro_mpters
propellers1455203propellers
prophesiers18113153prophesiers
proposers13228523propos_ers
prosectors14199123prosectors
prosers94219643pro__s_ers
prospers123012263pro__spers
protases102115033protas_e_s
proteases112110833protease_s
protected14158653protecte_d
protector13169533protector_
protectory17157483protectory
protectress1553133protectress
protects1239743protect__s
protegees1275393prote_gees
proteges1149923prote_ge_s
proteides12238783proteide_s
proteomes13248653proteome_s
proteoses112211013proteose_s
protest9317533protest___
protestant1247423protestant
protestants1354553protestants
protesting131910253protesting
proteuses11238993proteuse_s
protheses1449073prothes_e_s
protistans1245203protistans
protists10313363protist__s
protostar1146693protostar_
protostele1245073protostele
protosteles1354563protosteles
provenders1644273provenders
prowesses1437193prowesse_s
pyrometers1748333pyrome_ters
resters74130403_r__esters
rimesters1137483_rimesters
roadsters1035103_roadsters
roasters83615933_ro_asters
roisters83615553_ro_isters
roosters83514663_ro_osters
rosters73727543_ro__sters
rotters74421393_rot__ters
rousters84315683_ro_usters
roysters113610533_ro_ysters
testers74124543___testers
trimesters1245413trimesters
trotters83310243trot__ters
wresters112711733wr__esters

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 Filter1786911406030.450397091.1
2DLD Change Limit1406031016.31322272.0
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.80926243.4
 
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.