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

48 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
deponents124667(None) 
deponent11410551deponent_
dependents1446162dependents
depones103717092depone__s
exponents1844332exponents
opponents1343972opponents
components1646943components
deboners11268113debone_rs
debones103315113debone__s
decadents1346393decadents
decedents1347323decedents
decongests1443243decongests
deferents13269393deferents
deforests1344373deforests
dements103016623de__ments
demoness1138053demone_ss
demonists1248703demonists
demounts1135473demo_unts
depaints1136643dep_aints
dependants1444693dependants
dependent1349113dependent_
depends11348993dep__ends
deployments1954243deployments
depone93616553depone___
deponed113712873depone__d
deponing121211213deponin_g
deportments1655753deportments
deports105012883depo__rts
deposers11359243depose_rs
deposes103117213depose__s
deposits1138843depo_sits
depots94716343depo___ts
descents112511203de_scents
desinent9312963desinent_
despondent1455973despondent_
detents83615153de__tents
dipnets10109033dip_ne_ts
docents102810803d__ocents
dubonnets1242133dubonnets
exponent1747133exponent_
idempotents1651963idempotents
impotents1347003impotents
opponent1246403opponent_
ponent82821593__ponent_
proponents1445803proponents
repents93717623rep__ents
resonants946693resonants
respondents1454273respondents

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641488.64017203.8
3Display Results48480.0163000.0
 (SQL Overall)178691488.82920239.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.