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

62 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
detassel94365(None) 
detassels1042671detassels
degassed11275962degassed
degasser10325812degasser
degasses10278362degasses
detasseled1252012detasseled
tassel66014772__tassel
damsel9148033d__amsel
deashed123411303de_ashed
deashes113313903de_ashes
deasil71110983de_a_sil
debase94014473deba_se_
debased113310583deba_sed
debaser103510413deba_ser
debases103814133deba_ses
declasse1165943declasse_
declassed1344993declassed
declasses1246443declasses
degases93413103dega_ses
degassers11354833degassers
degaussed1242543degaussed
degausser1172163degausser
degausses1143203degausses
demasted1238763demasted
demitasse1242873demitasse_
demitasses1342953demitasses
detached1537733detached
detacher1437543detacher
detaches1439653detaches
detail74516433deta__il
detailed10319873detailed
detailer9268673detailer
detained103111643detained
detainee92511723detainee
detainer92910793detainer
detasseling1362203detasseling
detasselled1351843detasselled
detested10279623detested
detester9239683detester
dossel74813643d__ossel
easel54521113_e_a_sel
eyasses10388023_eyasses
hassel95614213__hassel
megasse10266243megasse_
megasses11307743megasses
metisse936503metisse_
metisses1036833metisses
passel85117003__passel
petasoses1145443petasoses
petasuses1144373petasuses
repassed11229273repassed
repasses101810373repasses
retaste72313133retaste_
retasted92412113retasted
retastes82212903retastes
tasse54821843__tasse_
tassels74510853__tassels
tasses64826763__tasses
tasset65925313__tasset
teasel63914983te_a_sel
vessel937953ve__ssel
weasel93410523we_a_sel

Search took 10 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 Filter1786911461620.1701051123.5
2DLD Change Limit146162629.28315745.1
3Display Results62620.0302066.7
 (SQL Overall)178691629.48318843.3
 
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.