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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 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
martyred143428(None) 
bartered113113012bartered
gartered10319582gartered
marred95421042mar__red
marted94425212mart__ed
martyr1135692martyr__
martyries1446562martyries
martyrized2543532martyrized
martyrly1642352martyrly
martyrs1234892martyr_s
martyry1533372martyr_y
mastered112614002mastered
mattered112412902mattered
matured10310032ma_tured
mortared1137212mortared
altered83215733_altered
antired82316193_antired
arbored103811603_arbored
armored102610473_armored
attired8238913_attired
bantered113313633bantered
barbered13259543barbered
barred95725793bar__red
barterer102711633barterer
battered113315053battered
cantered113415983cantered
captured1336573captured
careered1139493careered
carted98631443cart__ed
cartoned111312833cartoned
catered103117773ca_tered
chartered15158393chartered
cratered1149683cratered
darted84620923dart__ed
dartled9409853dart_led
earthed1139923eart_hed
factored1436213factored
faltered122810983faltered
farted105121783fart__ed
garnered10247113garnered
garred85217403gar__red
haltered123112553haltered
harbored1438633harbored
hatred104814333ha_t_red
jarred144613253jar__red
majored1735853ma_jored
malted94819863malt__ed
mammered12237653mammered
mannered11249653mannered
mantled104113393mant_led
manured1039473ma_nured
marauded1244333marauded
marbled123212113mar_bled
marched153813403mar_ched
margined1237743margined
marked133921623mar__ked
marketed1537323marketed
marled95523163mar__led
marooned1138563marooned
marrer83716673mar__rer
married104715303mar_ried
marrowed1445973marrowed
marten84518263mart__en
martinet10319643martinet
martlet93419153mart_let
martyrdom1751353martyrdom
martyring1535783martyring
martyrize2344523martyrize
martyrizes2444433martyrizes
marveled1436433marveled
masted94025803mast__ed
matched153513963ma_tched
mated85537783ma_t__ed
matres84522233ma_t_res
matted94521413ma_t_ted
mature8313463ma_ture_
maturer938973ma_turer
matures9314303ma_tures
mayed115522403ma__y_ed
mentored1138003mentored
metered103514013m_etered
metred95315143m_et_red
mirrored1145773mirrored
mistyped1685173mistyped
mitered103213233m_itered
mitred94414343m_it_red
morticed1377163morticed
mortised1178743mortised
motored1039933m_otored
murdered1236023murdered
murmured1343113murmured
murthered1544473murthered
mustered112511503mustered
muttered112610793muttered
nattered92011623nattered
natured838963na_tured
nurtured935253nurtured
paltered113012483paltered
parred95024073par__red
parted94228683part__ed
partied103516553part_ied
partnered1244473partnered
partyer12337873party_er
partyers13277763partyers
pastored1139963pastored
pastured1138233pastured
pattered112714203pattered
portered112311533portered
quartered19155963quartered
raftered1237663raftered
raptured1155463raptured
satyrid1137233sa_tyrid
smarted105012613smart__ed
smartened1244263smartened
smartweed1542113smartweed
smattered12186783smattered
tarred74720283tar__red
tartare73012683tartare_
tarted74923373tart__ed
tattered92011443tattered
tortured935843tortured
tyred95816433___tyred
waitered1238753waitered
warred104019843war__red
warted104223233wart__ed
watered113014953wa_tered
yattered12239533yattered

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621276.65621959.4
3Display Results1271270.0462760.9
 (SQL Overall)1786911276.85826055.8
 
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.