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

44 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
detassels104267(None) 
detassel943651detassel_
degassers11354832degassers
degasses10278362degasse_s
detasseled1252022detasseled
tassels74510852__tassels
damsels10126713d__amsels
deashes113313903de_ashe_s
debasers11377903deba_sers
debases103814133deba_se_s
declasses1246443declasse_s
degases93413103dega_se_s
degassed11275963degasse_d
degasser10325813degasse_r
degaussers1241663degaussers
degausses1143203degausse_s
demitasses1342953demitasse_s
detachers1536483detachers
detaches1439653detache_s
detailers10257253detailers
details84214043deta__ils
detainees10267153detainees
detainers10269103detainers
detasseling1362203detasseling
detasselled1351863detasselled
detesters10298303detesters
dossels85511613d__ossels
easels65914553_e_a_sels
eyasses10388023_eyasse_s
hassels104311023__hassels
megasses11307743megasse_s
metisses1036833metisse_s
passels93913023__passels
petasoses1145443petasose_s
petasuses1144373petasuse_s
reassess836513re_assess
repasses101810373repasse_s
retastes82212903retaste_s
tassel66014773__tassel_
tasses64826763__tasse_s
tassets75012773__tassets
teasels74311313te_a_sels
vessels1035933ve__ssels
weasels10468503we_a_sels

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.500357382.0
2DLD Change Limit148641447.71619264.0
3Display Results44440.0331333.3
 (SQL Overall)178691448.24921662.1
 
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.