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 “unprotected” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
unprotected165275(None) 
protected14158652__protected
introjected2153193introjected
projected21165823__projected
prosected14158633__prosected
protecter13179103__protecter
protested12159113__protested
uncorrected1653953uncorrected
undetected1444873un_detected
unpotted11108393unp_ot__ted
unprocessed1652843unprocessed
unproduced1643273unproduc_ed
unprofessed1752213unprofessed
unprompted1743113unpro_mpted
introspected1752844introspected
introverted1553484introverted
overprotected2162844overprotected
prelected1439134__prelected
pretested12149114__pretested
pretexted19135694__pretexted
prosecuted1544284__prosecuted
prospected1744874__prospected
protect11313634__protect__
protecters14168254__protecters
protector13169534__protector
protects1239744__protect_s
protended1336804__protended
protester111510484__protester
protracted1545764__protracted
unaffected1942944un_affected
unattested1143374un_attested
unbreeched1842784unbr_eeched
uncollected1653674uncollected
unconnected1644314unconnected
uncontested1444564uncontested
uncorseted1345154uncorse_ted
uncreated12312304uncr__eated
undirected1445024un_directed
undotted1048524un_dot__ted
unelected1237824un__elected
unexpected2243114un_expected
unforested1444804un_forested
unfrocked1944224unfro__cked
uninfected1663694un_infected
uninflected17112684uninflected
uninspected1652464uninspected
unknotted1443624unknot__ted
unmolested1343784un_molested
unnoticed1243924un_notic_ed
unpatched1744054unp_at_ched
unpitted1148624unp_it__ted
unpointed1237154unp_o_inted
unpoliced1445164unp_olic_ed
unpolluted1342134unp_olluted
unposted1159434unp_o__sted
unpressed1237954unpr__essed
unpriced1338144unpr__ic_ed
unprinted1238134unpr__inted
unprobed1366974unpro___bed
unproved1457534unpro___ved
unprovoked2041584unpro_voked
unrented92413924un_r__ented
unrested91914514un_r__ested
unroasted1036614un_ro_asted
unrooted9810514un_ro__oted
unselected1344974un_selected
unspotted1244934unspot__ted
unsuspected1652034unsuspected
untented92613414un___tented
untested92612414un___tested
untreated10312904untr__eated
uprooted1186394u_pro__oted

Search took 9 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 Filter1786911488190.420425454.8
2DLD Change Limit148819728.20618135.4
3Display Results72720.0431674.4
 (SQL Overall)178691728.66920612.6
 
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.