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

42 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
distillers114513(None) 
distiller1046671distiller_
distillery1443151distillery
dispellers13115452dispellers
distilled1147182distille_d
distilleries1352832distilleries
distills9319042distill__s
instillers1043662instillers
bastilles1147363bastille_s
desilvers13306083des_ilvers
diallers957773di__allers
disablers1255803dis_ablers
disciples1446403disciple_s
disinters1039713dis_inters
dislikers14286423disli_kers
dispeller12146983dispeller_
dissolvers1444643dissolvers
distempers1544293distempers
distenders12166733distenders
distill83011323distill___
distillate1146743distillate
distillates1246153distillates
distilling1247793distilling
distils83015803disti_l__s
distorters1147163distorters
disturbers13164163disturbers
drillers9429723d__rillers
hostellers1344683hostellers
installers1043633installers
instiller944953instiller_
miscallers1444303miscallers
missileers1244193missileers
mistitles1147953mistitle_s
pastilles1148703pastille_s
pistoleers1243793pistoleers
pistoliers1244583pistoliers
sillers73822103__s_illers
spillers103311703__spillers
stiflers11238833__stiflers
stiller73414303__stiller_
swillers11299113__swillers
tillers73418743___tillers

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.420425454.8
2DLD Change Limit140603426.31322272.0
3Display Results42420.0162625.0
 (SQL Overall)178691426.74926476.7
 
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.