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

111 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
protected1415865(None) 
projected21165821projected
prosected14158631prosected
protecter13179101protecter
protested12159111protested
prelected1439132prelected
pretested12149112pretested
pretexted19135692pretexted
prosecuted1544282prosecuted
prospected1744872prospected
protect11313632protect__
protecters14168252protecters
protector13169532protector
protects1239742protect_s
protended1336802protended
protester111510482protester
protracted1545762protracted
unprotected1652752unprotected
corrected1438113corrected
crotched16428593crot_ched
detected12289733_detected
erected103213993er__ected
obtected1344553_obtected
patented1188893p_atented
perfected1736643perfected
pirouetted1342943pirouetted
plotted104612373plot__ted
portended1345643portended
portered112311543porte_red
porticoed1445423porticoed
potted94624013p_ot__ted
praelected1544393praelected
preacted132710943pr_eacted
precented14310693precented
precited133013813pr__ecited
predicted1538913predicted
preelected1545783preelected
preerected1545573preerected
preheated1539813preheated
presented12311633presented
pretasted12147963pretasted
pretended1337193pretended
pretreated1347623pretreated
prevented1539003prevented
priested1138393pr_iested
probated13410863pro_bated
proceed12310553pro__ceed
proceeded1544103proceeded
processed1446803processed
procreated1546443procreated
produced1456073produc_ed
proette9312363pro_ette_
proettes10312763pro_ettes
professed1545243professed
profited14279973pro_fited
project1838453project__
projector20186683projector
projects1936413project_s
promoted13310543pro_moted
prompted1536903pro_mpted
pronated11414053pro_nated
propelled1456913propelled
propended1546163propended
propertied15137253propertied
prorated11513713pro_rated
prosect11313393prosect__
prosector13208533prosector
prosects1239473prosect_s
prosecute1345953prosecute_
prosecutes1445663prosecutes
proselyted1643433proselyted
prostrated1349423prostrated
protease10209893protease_
proteases112110833proteases
protectant1446913protectant
protecting151910213protecting
protection14511473protection
protective1748423protective
protectors142010143protectors
protectory17157483protectory
protectress1553133protectress
protege1059153prote_ge_
protegee1156963prote_gee
protegees1275393protegees
proteges1149923prote_ges
proteid103513673prote__id
proteide11239723proteide_
proteides12238783proteides
protend104012793prote__nd
proteome12228423proteome_
proteomes13248653proteomes
proteose10229413proteose_
proteoses112211013proteoses
protest9317533protest__
protesters12169383protesters
protestor11178493protestor
protests10310493protest_s
proteuses11238993proteuses
protocoled1544983protocoled
protonated1348593protonated
protruded1343443protruded
proverbed1743813proverbed
refected142311663_refected
rejected182710113_rejected
resected112514743_resected
retested92212533_retested
rotated82715293_rot_ated
rotted74524433_rot__ted
trajected1944043trajected
trisected1244913trisected
trotted83711283trot__ted

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.406440125.6
2DLD Change Limit1486411116.42323142.0
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.87525991.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.