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

41 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
chastisers154317(None) 
chastiser1444371chastiser_
chastises1437701chastise_s
chasteners1554792chasteners
chastise1348172chastise__
chastised1554682chastise_d
cashiers13318883c_ashi_ers
cassises103811743c_assise_s
casters94729903c_ast__ers
chaises124317493cha__ise_s
challises14358783challise_s
chamises153513313cha_mise_s
chamoises16327933chamoise_s
chanters134016743chant__ers
chanties132615803chanti_e_s
chapiters1635203cha_piters
chapters154012133chapt__ers
charterers15146053charterers
charters134115583chart__ers
chartists14126803chartis_ts
chasers123714923cha___sers
chasses124017503chas__se_s
chasseurs1443323chas__seurs
chastener1445703chastener_
chasteness1546523chasteness
chastens13429183chast__ens
chaster124718503chast__er_
chastising1654883chastising
chastities1545863chastities
chatterers15205463chatterers
chatters134213953cha_t_ters
chattier1337513chatti_er_
chattiness1565123chattiness
chestier1387423chesti_er_
classers104111833clas__sers
coasters104317333coast__ers
hasteners12267813_hasteners
hastier103916623_hasti_er_
hastiness122410883_hastiness
pastises103616053_pastise_s
whatsises1543203whatsise_s

Search took 7 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.423422437.4
2DLD Change Limit140603416.48321688.0
3Display Results41410.0162562.5
 (SQL Overall)178691416.92225814.9
 
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.