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

47 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
benchmarkings27697(None) 
benchmarking2651541benchmarking_
benchmarks2351913benchmark___s
bechalking2244114be_ch_alking_
becharming2044304be_ch_arming_
benchmark2252054benchmark____
benchmarked2551544benchmark__ed
matchmakings2651954matchma_kings
matchmarking2651974matchmarking_
peacemakings2352044peacema_kings
watchmakings2751884watchma_kings
bearings113912255be____ar_ings
bechancing2044445be_ch_ancing_
becloaking1944885be_cloa_king_
becomings1643785be_com___ings
becowarding2052535be_cowarding_
bedcoverings2151245bedcover_ings
benching163411345bench____ing_
benchlands1852705benchla___nds
benchwarmers2461035benchwar_mers
bethanking2044295be_th_anking_
bookmakings1951975b_ookma_kings
bookmarking1952195b_ookmarking_
charking183512615___ch_arking_
checkmarking2551365checkmarking_
demarking1736775de___marking_
earmarking1743585_e_armarking_
enchaining1644945_ench_aining_
enchains1348525_ench_a__in_s
enchanting1645945_ench_anting_
enchasing1567735_ench_a_sing_
landmarking1952445lan_dmarking_
markings153410245_____markings
matchmaking2552975matchma_king_
merrymakings2461495merryma_kings
moneymakings2461785moneyma_kings
mythmakings2651865_mythma_kings
pacemakings2262825_pacema_kings
peacemaking2252865peacema_king_
pockmarking2152385_pockmarking_
recharging1745295re_ch_arging_
recharting1637215re_ch_arting_
rehearings14214575re__hear_ings
remarking1638895re___marking_
uncharging1744395_unch_arging_
uncharming1844525_unch_arming_
watchmaking2652465watchma_king_

Search took 10 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.423422437.4
2DLD Change Limit124790479.26313471.9
3Display Results47470.0331424.2
 (SQL Overall)178691479.71918385.7
 
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.