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

46 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
properties14141188(None) 
propertied15137251propertied
poperies12316792p_oper_ies
poverties1439512p_overties
properdins1546012properdins
prosperities1655482prosperities
roperies10315762_roper_ies
cooperies131113313cooper_ies
draperies1249193draper_ies
fromenties1546673fromenties
graperies1239613graper_ies
groceries1249503grocer_ies
moperies12313873_moper_ies
peripeties1448393peripe_ties
poetries10315583p_o_etries
prepuberties1892043prepuberties
preterites12411793preterites
pretties10615133pr__etties
probities13312653pro_bities
proettes10312763pro_e_ttes
progenies12314123proge_nies
progerias1248623proger_ias
progestins1348663progestins
projectiles2243803projectiles
propenes122816513prope__nes
propensities1655263propensities
properdin1446273properdi_n
properer1259203proper__er
properest1349663proper__est
properness1445923properness
propers113619033proper___s
property1547073propert__y
propertyless195983propertyless
prophecies1996503prophecies
prophesies17107893prophesies
proportion1448993proportion
proportions1548463proportions
propretors1445793propretors
proprieties1556183proprieties
propylites1746303propylites
prosties101421193pro__sties
pruderies1247873pruder_ies
puberties1346603p_uberties
puppetries1343883puppetries
pyrometries1898123pyrometries
roseries8317313_roser_ies

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 Filter1786911406030.470380193.6
2DLD Change Limit140603466.83020586.1
3Display Results46460.0301533.3
 (SQL Overall)178691467.33024378.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.