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

124 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
protester11151048(None) 
protecter13179101protecter
protested12159111protested
protesters12169381protesters
protestor11178491protestor
prester93519622pr__ester
pretested12149112pretested
processer1346892processer
protected14158652protected
protecters14168252protecters
protector13169532protector
protest9317532protest__
protestors12169312protestors
protests10310492protest_s
protostar1146692protostar
arrester839253ar_rester
attester836503_attester
contester11311183contester
detester9239683_detester
dopester1137253_dopester
forester11313673_forester
honester1139713_honester
jokester1934443_jokester
modester1197483_modester
molester1099373_molester
orometer10310703orome_ter
ovotestes1242533ovotestes
pester84827593p___ester
plotter94113663plot__ter
poetaster1145673poetaster
polestar1047113p_olestar
pollster1037103p_ollster
polyester1445353polyester
poster84129173p_o__ster
potter83926983p_ot__ter
prankster1543183prankster
preheater1448913preheater
presenter11311643presenter
presser93717623pr__esser
presters103419003pr__esters
pretaste10139523pretaste_
pretasted12147963pretasted
pretastes11119423pretastes
pretender1246663pretender
pretest9517633pretest__
pretests10310013pretest_s
pretexted19135693pretexted
pretheater1545543pretheater
preventer1438593preventer
priested1138393pr_iested
proceeder1444173proceeder
processed1446803processed
processers1446003processers
processes13310233processes
processor1346233processor
proette9312363pro_ette_
proettes10312763pro_ettes
professed1545243professed
professes1437873professes
professor1445033professor
profiter132710203pro_fiter
progestin1248423progestin
projected21165823projected
projector20186683projector
promiser122510673promis_er
promoter12311453pro_moter
prompter1437983pro_mpter
propeller1346623propeller
properer1259203prope_rer
prophesier17114333prophesier
proposer121810633propos_er
prosected14158633prosected
prosector13208533prosector
proser84223463pro__s_er
prosier93817483pro__sier
prosper114012193pro__sper
protases102115033protas_es
protease10209893protease_
proteases112110833proteases
protect11313633protect__
protectors142010143protectors
protectory17157483protectory
protects1239743protect_s
protege1059153prote_ge_
protegee1156963prote_gee
protegees1275393protegees
proteges1149923prote_ges
proteide11239723proteide_
proteides12238783proteides
protended1336803protended
proteome12228423proteome_
proteomes13248653proteomes
proteose10229413proteose_
proteoses112211013proteoses
protestant1247423protestant
protesting131910253protesting
proteuses11238993proteuses
protheses1449073prothes_es
protist9320223protist__
protistan1145983protistan
protistic13410983protistic
protists10313363protist_s
protostars1246853protostars
protostele1245073protostele
provender1544893provender
prowesses1437193prowesses
prowest12311533prowest__
pyrometer1648883pyrome_ter
rester63832433_r__ester
retested92212533_retested
rimester1037813_rimester
roadster935463_roadster
roaster74116663_ro_aster
robuster1035663_robuster
roister73516203_ro_ister
rooster74415173_ro_oster
roster64329083_ro__ster
rotter64325463_rot__ter
rouster73517083_ro_uster
royster103110533_ro_yster
tester64227153___tester
trimester1145823trimester
trotter73312253trot__ter
wrester102812413wr__ester

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411247.37620152.0
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.84222786.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.