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

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

128 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
mashers12462105(None) 
bashers124820831bashers
dashers115016861dashers
kashers143914021kashers
lashers104121831lashers
masers84623451mas_ers
masher114123201masher_
mashes115030001mashe_s
maskers133913841maskers
masters94628921masters
moshers124017841moshers
mushers124016441mushers
rashers104020911rashers
smashers13339591smashers
washers134517521washers
amassers10337842amassers
ashes86230612_ashe_s
ashlers10319582_ashlers
askers105915402_askers
aspers86220312_aspers
asters65631602_asters
basher115123812basher_
bashes115631392bashe_s
basters94930302basters
bathers124720362bathers
bushers124018802bushers
cashes114729882cashe_s
cashews15428602cashews
cashiers13318882cashiers
casters94729902casters
clashers134213992clashers
coshers123618182coshers
crashers134013232crashers
dasher104318982dasher_
dashes106124982dashe_s
easters75125682easters
fashes124524022fashe_s
fathers133916502fathers
fishers134714722fishers
flashers143912652flashers
gasher104320372gasher_
gashes105725152gashe_s
gaspers105014132gaspers
gassers84714632gassers
gasters85624292gasters
gathers114315072gathers
gushers113512512gushers
hashes125024802hashe_s
jaspers164310462jaspers
joshers174111592joshers
kasher134915032kasher_
koshers144811802koshers
lasers64925702las_ers
lasher94824532lasher_
lashes94831002lashe_s
lasters75627692lasters
lathers104321882lathers
macers105321272ma_cers
maches134827232mache_s
madders113513212madders
maihems1444302maihems
mailers94420332mailers
maimers113813042maimers
makers123921732ma_kers
mammers104615692mammers
mamzers20409162mamzers
mangers103521262mangers
manners93417832manners
mappers133313782mappers
marchers153710812marchers
markers133516102markers
marrers93414312marrers
marshes123615372marshe_s
maser75029972mas_er_
mashed125325042mashe_d
mashies12318252mashies
maskegs14375412maskegs
masker124416102masker_
masquers19195702masquers
masses85028712masse_s
masseurs1034922masseurs
master84831342master_
mastery124214322mastery
matchers153012432matchers
maters85032392ma_ters
matters94421752matters
maulers94213302maulers
mayhems1763412mayhems
mazers173917092ma_zers
meshes115019442meshe_s
misers85025702mis_ers
mishears1338322mishears
misters93927512misters
mithers123516732mithers
mosher114719792mosher_
moshes115222872moshe_s
mossers94116192mossers
mothers123717622mothers
musers84719102mus_ers
musher113820572musher_
mushes114124562mushe_s
musters94522512musters
noshers103614332noshers
pashes115828392pashe_s
passers94717752passers
pasters94531732pasters
pishers123815752pishers
plashers133813452plashers
pushers123814502pushers
quashers20186802quashers
rasers64526782ras_ers
rasher95024122rasher_
rashes95330152rashe_s
raspers94415922raspers
rasters74629022rasters
rushers103816102rushers
sashes94728482sashe_s
slashers113313612slashers
smasher123911022smasher_
smashes123914612smashe_s
swashers14389532swashers
tasters74225642tasters
trashers113013642trashers
ushers94415532_ushers
washer124720392washer_
washes124425492washe_s
wasters104026592wasters
wishers133215212wishers

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711282.94036622.8
3Display Results1281280.0462782.6
 (SQL Overall)1786911283.35953197.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.