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

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

46 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
bookmarkers185199(None) 
bookmakers1743171bookma_kers
bookmarker1752171bookmarker_
biomarkers1842652bio_markers
bookmaker1643632bookma_ker_
bookmarked1851742bookmarke_d
bookmarks1643082bookmark__s
biomarker1743083bio_marker_
bookmark1543343bookmark___
bookmarking1952193bookmarking
lockmakers1743183lockma_kers
toolmakers1643013toolma_kers
backpackers2252884backpackers
barkers134318514b____arkers
bedmakers1844384b_edma_kers
boarders11408624b_o__arders
bombarders17153204b_ombarders
bookbinders2051654bookbinders
bookcases1743874bookca_se_s
bookers134016614boo____kers
bookkeepers1851824bookkeepers
booklores1545074booklor_e_s
bookmaking1843134bookma_king
bookmakings1951974bookmakings
bookracks1643604bookrack__s
booksellers1751934booksellers
boomers114115914boo_m___ers
bootlickers1951914bootlickers
broodmares1552724broodmar_e_s
comakers16339174_co_ma_kers
cookwares1844804cookwar_e_s
dockmasters2053104dockmasters
dockworkers20142334dockworkers
footmarks1843584footmark__s
homemakers2144664homema_kers
lockmaker1643674lockma_ker_
lovemakers1943074lovema_kers
markers133516104____markers
nonmarkets1653034_nonmarkets
pockmarked2052054pockmarke_d
pockmarks1843004pockmark__s
remarkers15197284__remarkers
shoemakers1943494shoema_kers
snowmakers1972584snowma_kers
toolmaker1543134toolma_ker_
woodworkers22152724woodworkers

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 Filter1786911488190.190940478.9
2DLD Change Limit148819467.90618823.6
3Display Results46460.0301533.3
 (SQL Overall)178691468.12621990.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.