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

49 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
maunderers138375(None) 
launderers1183871launderers
maunderer1294191maunderer_
blunderers1343942blunderers
launderer1094512launderer_
maundered1394942maundere_d
maunders11348342maund__ers
meanderers1343802meanderers
murderers1244592m_urderers
panderers12229152pa_nderers
plunderers1343332plunderers
saunterers1044382saunterers
sunderers1039072_sunderers
thunderers1443972thunderers
wanderers13228482wa_nderers
banterers112410003ba_nterers
blunderer1244543blunderer_
boulderers1343663boulderers
calenderers1452213calenderers
daundered1294423daundere_d
daunders10278473daund__ers
hankerers16226713ha_nkerers
hinderers1337353_hinderers
laundered1185023laundere_d
launders9358743laund__ers
laundress1042813laund_ress
malingerers1451753malingerers
mandrels1137313ma_nd_rels
manurers1037593ma_n_urers
maunder10328683maund__er_
maundering1455353maundering
maundies1137853maund_ie_s
meanderer1244733meanderer_
murderees1244353m_urderees
murderer1145263m_urderer_
murderess1243593m_urderess
mutterers11247373m_utterers
panderer112210913pa_nderer_
plunderer1243753plunderer_
ponderers12248453_ponderers
renderers10208093_renderers
saunterer945033saunterer_
slanderers1145143slanderers
squanderers2151423squanderers
sunderer9310523_sunderer_
tenderers10227803_tenderers
thunderer1344253thunderer_
wanderer122210123wa_nderer_
wonderers13217933_wonderers

Search took 7 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 Filter1786911406030.420425454.8
2DLD Change Limit140603495.75024452.7
3Display Results49490.0163062.5
 (SQL Overall)178691496.18628886.4
 
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.