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

78 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
softener114561(None) 
oftener1035921_oftener
softened1235661softened
softeners1245131softeners
rottener8216972rottener
shortener1245772shortener
soften9429492soften__
softens10347622soften_s
softer94015312soft__er
battener10369393battener
congener112412203congener
contemner1347183contemner
contender1239563contender
convener132913163convener
cozener18328953co_zener
fastener11227833fastener
fattener11268113fattener
fosterer11239523fosterer
goldener1045403goldener
hastener11259133hastener
hosteler1137273hosteler
listener8158313listener
lofter94614723loft__er
loftier1037763loft_ier
loiterer837083loiterer
loosener845633loosener
moistener1145843moistener
offender1543723_offender
offerer1335543_offerer
often84611413_often__
oftenest1148863_oftenest
ofter84116873_oft__er
opener83910993_o_pener
potterer102310263potterer
rattener8238533rattener
resoftened1443413resoftened
screener1037563screener
sentencer1156383sentencer
serener73415753s_erener
shortened1345663shortened
shorteners1345083shorteners
sickener1436603sickener
sifter94516233sift__er
soberer93110353so_berer
soddened1144643soddened
soever94412093so__ever
softcore1353033softcore
softcover1741623softcover
softening1365493softening
softest10310603softe_st
softie93312473soft_ie_
softies103414613soft_ies
softness1136433softness
software1464253software
solderer947183solderer
solemner1045053solemner
sooner64220463so__oner
soother104215033soot_her
sootier73916603soot_ier
sorcerer1036433sorcerer
sorner64720383so__rner
sorter64425083sort__er
soutane7312063soutane_
soutanes8312933soutanes
souter64225923sout__er
souther104116303sout_her
souvenir1142163souvenir
steer55423863s__te_er
sterner7411913s__terner
stiffener1541963stiffener
stoner65823203s__toner
stoutened1053573stoutened
sufferer1436063sufferer
sullener857243sullener
sweetener1243403sweetener
totterer8217793totterer
whitener1435733whitener
woodener1245763woodener

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162788.54617103.0
3Display Results78780.0332363.6
 (SQL Overall)178691788.74920424.2
 
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.