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 “candleholders” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

51 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
candleholders206165(None) 
candleholder1961771candleholder_
candlepowers20101513candlepo_wers
cardholders1852993card__holders
landholders1653253land__holders
bandleaders1552714bandle__aders
bondholders1852834bond__holders
candlepower1981754candlepo_wer_
candlewoods1852074candlewood__s
cardholder1753174card__holder_
landholder1563554land__holder_
titleholders1661624_titleholders
banderoles1344855band_erol_e_s
bandleader1453245bandle__ader_
bandoleers1343565band___oleers
bandoliers1344145band___oliers
beholders1544935____beholders
bondholder1753095bond__holder_
calenders1237405ca__le__nders
canallers1137215canal___l_ers
cancelers13247865can_ce__l_ers
cancellers1445365can_ce__llers
candlefishes2152005candlefishe_s
candlelighters219945candlelighters
candlers114214105cand____l_ers
candlesnuffers239485candlesnuffers
candlewood1752205candlewood___
chandeliers1743485chand_e__liers
coholders1535625c____oholders
condolers122710575cond___ol_ers
copyholders2252175c__opyholders
freeholders1852855__freeholders
gasholders1543805ga___sholders
handholds1745005hand__hold__s
handleless1473125handle__l_ess
householders1952855_householders
inholders1345355_in___holders
landlopers1343675landl__o_pers
leaseholders1652135_leaseholders
officeholders256755officeholders
penholders1643795pen___holders
placeholders2062365_placeholders
sandlotters1252875sandl__otters
shareholders1952805_shareholders
slaveholders1992655_slaveholders
smallholders18112195_smallholders
stadtholders1752255stad_tholders
stakeholders2062815_stakeholders
stallholders16102445_stallholders
titleholder1561665_titleholder_
toolholders1552515_tool_holders

Search took 9 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 Filter1786911247900.403443402.0
2DLD Change Limit124790518.28315065.8
3Display Results51510.0301700.0
 (SQL Overall)178691518.71620501.5
 
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.