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

77 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
murderers124459(None) 
murderees1244351murderees
murderer1145261murderer_
murderess1243591murderess
borderers1276332borderers
burdeners1245062burdeners
maunderers1383752maunderers
murdered1236022murdere_d
murderee1146842murdere_e
murderous1244662murderous
murders103311362murd__ers
murmurers1342672murmurers
mutterers11247372mutterers
orderers9116562_orderers
sunderers1039072sunderers
verderers1344842verderers
barterers11269633barterers
blunderers1343943blunderers
borderer1168103borderer_
boulderers1343663boulderers
burdener1136143burdener_
burrers93814493bur__rers
careerers1137243careerers
cumberers15176003cumberers
curdlers11368493curd_lers
dodderers1243803dodderers
furbearers1552723furbearers
furtherers1643323furtherers
gardeners1136603gardeners
hardeners1338083hardeners
hinderers1337353hinderers
hurdlers12337493hurd_lers
launderers1183873launderers
lumberers13196013lumberers
marketers1545983marketers
marrers93414313mar__rers
maunderer1294193maunderer_
meanderers1343803meanderers
miterers10219683m_iterers
modelers1138463m_odelers
mudders113211113mu_d_ders
muddlers12428813mu_ddlers
murder93613783murd__er_
murderesses1443103murderesses
murdering1357133murdering
murexes1636973mur_exe_s
murmurer1242873murmurer_
murrelets11123243murrelets
murres85019043mur__re_s
murreys12367323mur__reys
murthers1336543mur_thers
mutterer10218913mutterer_
numberers13165153numberers
nurturers943353nurturers
orderer8127943_orderer_
panderers12229153panderers
plunderers1343333plunderers
ponderers12248453ponderers
powderers15214793powderers
puckerers1744513puckerers
putterers11238363putterers
quarterers19124823quarterers
quaverers2143853quaverers
quiverers2143713quiverers
renderers10208093renderers
solderers1066533solderers
sorcerers1145323sorcerers
sufferers1555103sufferers
sunderer9310523sunderer_
tenderers10227803tenderers
thunderers1443973thunderers
ureters7311823_ur_eters
utterers8218653_utterers
verderer1245373verderer_
verderors1343653verderors
wanderers13228483wanderers
wonderers13217933wonderers

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 Filter1786911486410.420425454.8
2DLD Change Limit148641776.89321564.1
3Display Results77770.0461673.9
 (SQL Overall)178691777.35924282.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.