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

56 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
descanters134501(None) 
decanters12229221de_canters
descanter1246441descanter_
decanter112510792de_canter_
decenters122410372de_centers
desalters1037672des_alters
descanted1336672descante_d
descants112910142descant__s
descenders1445452descenders
recanters112310482re_canters
bespatters1442783bespatters
canters94827733___canters
debaters113511923de_ba_ters
decaliters1345213de_caliters
decameters15156593de_cameters
decanes103118913de_can_e_s
decanted122310493de_cante_d
decants103514443de_cant__s
decayers14307963de_ca_yers
decenter112412163de_center_
decentres12238523de_centres
defeaters13289103defea_ters
deflaters13298703defla_ters
demanders13247573de_manders
derangers1136703de_rangers
desalter938363des_alter_
descant104315583descant___
descanting1446923descanting
descender1346663descender_
descents112511203descent__s
describers1543583describers
descriers1245693desc_riers
desecraters1444813desecraters
deserters10129983des_erters
designers1136003design_ers
desolaters1146043desolaters
despairers1343103despairers
dewaters122910723de_wa_ters
disasters1039153dis_asters
discanted1339333discante_d
discants112912023discant__s
discarders1445043discarders
discounters1445753discounters
disinters1039713dis_inters
dissenters1197723dissenters
enchanters1545223_enchanters
escapers12337413_esca_pers
levanters1254993le_vanters
mishanters1544983mishanters
newscasters1651603newscasters
recanter101913153re_canter_
rescinders1344303rescinders
scanners10379703__scanners
scanter94215183__scanter_
scatters103612753__scatters
webcasters1742143webcasters

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.436409841.7
2DLD Change Limit140603566.56321423.6
3Display Results56560.0331697.0
 (SQL Overall)178691567.03225411.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.