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 “baskets” with Change Limit: [1] [2] [3]

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

58 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
baskets13511183(None) 
basket125722911basket_
bassets96414821bassets
boskets13409471boskets
caskets133910171caskets
gaskets12348151gaskets
askers105915402_askers
assets65617662_assets
backers153821882backers
backsets1638852backsets
baguets1037482baguets
bakers125323452ba_kers
bakes117035372ba_ke_s
balkers134915722balkers
ballets93719512ballets
bankers133919092bankers
bankits133410152bankits
bannets94013842bannets
barbets114915842barbets
barkers134318512barkers
barrets94917102barrets
basalts9358962basalts
bases75644352bas_e_s
basest84720492bas_est
bashers124820832bashers
bashes115631392bashe_s
basinets1039062basinets
basked135218602baske_d
basketry1743512basketry
basks115621762bask__s
basses85428302basse_s
basset85225382basset_
bassett94213862bassett
bassetts10407372bassetts
basters94930302basters
bastes85330382baste_s
basts75936932bas__ts
beckets15399822beckets
besets85718802bes_ets
blankets14356502blankets
bosket124919222bosket_
brackets163310432brackets
briskets14346562briskets
buckets153811692buckets
buskers133414092buskers
casket124820992casket_
flaskets1534602flaskets
gasket114417252gasket_
haslets102510862haslets
jackets205011372jackets
markets133314032markets
maskegs14375412maskegs
maskers133913842maskers
muskets13258642muskets
packets155114772packets
rackets134916872rackets
tackets134914362tackets
tassets75012772tassets

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671583.14334257.4
3Display Results58580.0134461.5
 (SQL Overall)178691583.52950635.0
 
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.