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

33 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
webcasted174197(None) 
webcaster1642381webcaster
webcast1445552webcast__
webcasters1742142webcasters
webcasts1543312webcast_s
webmaster1643002webmaster
basted95227233__b_asted
blasted104213473__blasted
boasted104113743__boasted
debased113310583deb_as_ed
debated113916083deb_a_ted
decanted122310493de_canted
demasted1238763de_masted
descanted1336673descanted
encased103512313_encas_ed
encashed14246473_encashed
encysted1444293_encysted
feasted11310843fe__asted
overcasted1647793overcasted
rebaited11410543reb_aited
rebated103619693reb_a_ted
recanted112513513re_canted
repasted112611533re_pasted
retasted92412113re_tasted
subcaste1287853subcaste_
subcastes1387483subcastes
telecasted1343943telecasted
unbasted112510073unb_asted
wasted104423023w___asted
webcasting1842483webcasting
webmasters1742913webmasters
webster1236093web__ster
yeasted1138503ye__asted

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641337.64019455.6
3Display Results33330.0132538.5
 (SQL Overall)178691337.80922882.7
 
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.