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

53 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
bedcover166356(None) 
bedcovers1783561bedcovers
recover124312622re_cover
beachier1538803beachier
beaconed1336983beaconed
beaver114819253be__aver
beckoner1654963beckoner
become123312593be_come_
becomes132911963be_comes
bedchair1642793bedchair
bedcovering2052663bedcovering
bedder104215793bed__der
bediaper1344933bediaper
bedmaker1744933bedmaker
bedrivel1444083bedrivel
bedsore1057803bedsore_
bedsores1157633bedsores
beechier1535633beechier
beflower16166283beflower
behaver15206723be_haver
behoove1553773behoove_
behooved1743133behooved
behooves1653793behooves
behove14207203be_hove_
behoved16205563be_hoved
behoves15177353be_hoves
belcher143511493belc_her
believer13448423believer
bellower13159073bellower
beloved13188393be_loved
bencher144113483benc_her
bereaver1346673bereaver
bescour1145203besco_ur
beshiver1634483beshiver
bestower13126213bestower
boilover1344023boilover
cover105430773___cover
decoder113712293de_coder
decoyer13348683de_coyer
discover1439563discover
drover104614593__drover
encoder1038633_encoder
hardcover1843243hardcover
leftover1442713leftover
newcomer1543343newcomer
recovers133511123re_covers
recovery16366213re_covery
rediscover1653163rediscover
redrove11249423redrove_
remover124612273re_mover
reprover13229203reprover
uncover1239003_uncover
welcomer1544033welcomer

Search took 8 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.436409841.7
2DLD Change Limit146162537.00020880.3
3Display Results53530.0163312.5
 (SQL Overall)178691537.45223978.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.