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

189 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
mammered1223765(None) 
hammered16218851hammered
yammered16225761yammered
cambered15129002cambered
hammerer15278142hammerer
hampered16239932hampered
mammee94417852mamme_e_
mammees104411142mamme_es
mammer94218862mammer__
mammers104615692mammer_s
mannered11249652mannered
mastered112614002mastered
mattered112412902mattered
membered1535902membered
pampered15229222pampered
simmered1336862simmered
stammered1444642stammered
summered1338142summered
tampered13279462tampered
yammerer15225482yammerer
adhered1239233_adhered
admired1135703_admired
altered83215733_altered
amerced1256523_a_merced
ammeter1148393_ammeter
ampere10514413_ampere_
amperes11313983_amperes
angered93013473_angered
armored102610473_armored
badgered1336213badgered
bammed133913243bamm__ed
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
bumpered1536003bumpered
cameoed1238383ca_meoed
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043ca_pered
careered1139493careered
catered103117773ca_tered
chambered19145993chambered
chamfered20165063chamfered
clambered16146133clambered
commerced18125463commerced
compered153414923compered
cumbered15157963cumbered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dammed124214793damm__ed
dammer114317933dammer__
dammers123214273dammer_s
dampened1435623dampened
dandered112110963dandered
dangered11248513dangered
dormered1255673dormered
faltered122810983faltered
fathered151510433fathered
gammed124216163gamm__ed
gammer1112318333gammer__
gammers123214563gammer_s
gammoned1444993gammoned
gandered112211173gandered
garnered10247113garnered
gartered10319583gartered
gathered13149373gathered
glimmered1543103glimmered
haltered123112553haltered
hammed144116973hamm__ed
hammer138120033hammer__
hammerers16216563hammerers
hammerhead2152193hammerhead
hammers144216063hammer_s
hamperer15379093hamperer
hankered16289443hankered
havered144011453ha_vered
homered133212713_homered
immerged1444023_immerged
immersed1344833_immersed
immured1235063_immured
jabbered2034433jabbered
jammed183811503jamm__ed
jammer174014133jammer__
jammers183710703jammer_s
kashered1636403kashered
laagered1055853laagered
lackered15108673lackered
laddered1136743laddered
lagered92311153la_gered
lammed113915623lamm__ed
lappered13288213lappered
lathered121512323lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
limbered13158123limbered
lumbered13188233lumbered
mackerel1644863mackerel
maddened1334893maddened
maimed114812663maim__ed
maimer104514593maimer__
maimers113813043maimer_s
majored1735853ma_jored
mamboed14417623ma_mboed
mameyes14376983ma_meyes
mammae94613213mamm_ae_
mammary1335993mammar_y
mammate104411273mammate_
mammering1337333mammering
mammet94319253mamm__et
mammets103911113mamme_ts
mammey124310893mamm__ey
mammeys13376723mamme_ys
mammie94313783mamm_ie_
mammies104314763mamm_ies
mammocked1941963mammocked
mamzer19459833mamzer__
mamzers20409163mamzer_s
manured1039473ma_nured
marketed1537323marketed
marred95421043ma__rred
martyred1434283martyred
marveled1436433marveled
matured10310033ma_tured
maundered1394943maundered
mayweed1634163maywe_ed
meandered1346143meandered
metered103514013m_etered
mimeoed1235193m_imeoed
mitered103213233m_itered
moldered1237173moldered
mongered1238953mongered
mothered142310103mothered
mummed104411553mumm__ed
mummer93614543mummer__
mummeries1247243mummeries
mummers103712843mummer_s
mummery13336663mummer_y
mummied11327103mumm_ied
murdered1236023murdered
murmured1343113murmured
mustered112511503mustered
muttered112610793muttered
nattered92011623nattered
numbered13147143numbered
paltered113012483paltered
pamperer14228333pamperer
pandered121812573pandered
papered122513163pa_pered
pattered112714203pattered
paupered13216933paupered
pommeled1543103pommeled
pummeled1543373pummeled
raftered1237663raftered
rammed113117303ramm__ed
rammer103519653rammer__
rammers113715043rammer_s
rapiered1136053rapiered
rehammered1843083rehammered
sabered103213023sa_bered
saggered11237553saggered
scampered1635233scampered
shimmered1744783shimmered
simpered1338253simpered
smattered12186783smattered
stammerer1344063stammerer
tabered103311593ta_bered
tamperer12248893tamperer
tapered102612933ta_pered
tattered92011443tattered
tempered13248213tempered
timbered13137383timbered
trammeled1453203trammeled
umbered121510113_umbered
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wandered132110793wandered
watered113014953wa_tered
wavered142910433wa_vered
yabbered1633963yabbered
yammer133713183yammer__
yammerers16214453yammerers
yammers143410323yammer_s
yattered12239533yattered

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621899.33015665.8
3Display Results1891890.0932032.3
 (SQL Overall)1786911899.57918654.5
 
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.