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

133 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
rashers10402091(None) 
bashers124820831bashers
crashers134013231crashers
dashers115016861dashers
kashers143914021kashers
lashers104121831lashers
mashers124621051mashers
rasers64526781ras_ers
rasher95024121rasher_
rashes95330151rashe_s
raspers94415921raspers
rasters74629021rasters
rushers103816101rushers
trashers113013641trashers
washers134517521washers
archers124414572archers
ashes86230612_ashe_s
ashlers10319582_ashlers
askers105915402_askers
aspers86220312_aspers
asters65631602_asters
basher115123812basher_
bashes115631392bashe_s
basters94930302basters
bathers124720362bathers
brasher124515242brasher_
brashes124518462brashe_s
brasiers103710512brasiers
brushers134210572brushers
bushers124018802bushers
cashes114729882cashe_s
cashews15428602cashews
cashiers13318882cashiers
casters94729902casters
clashers134213992clashers
coshers123618182coshers
crasher124616162crasher_
crashes124618402crashe_s
crushers134010092crushers
dasher104318982dasher_
dashes106124982dashe_s
easters75125682easters
erasers74413942eras_ers
fashes124524022fashe_s
fathers133916502fathers
fishers134714722fishers
flashers143912652flashers
gasher104320372gasher_
gashes105725152gashe_s
gaspers105014132gaspers
gassers84714632gassers
gasters85624292gasters
gathers114315072gathers
graspers11338402graspers
gushers113512512gushers
hashes125024802hashe_s
jaspers164310462jaspers
joshers174111592joshers
kasher134915032kasher_
koshers144811802koshers
lasers64925702las_ers
lasher94824532lasher_
lashes94831002lashe_s
lasters75627692lasters
lathers104321882lathers
masers84623452mas_ers
masher114123202masher_
mashes115030002mashe_s
maskers133913842maskers
masters94628922masters
moshers124017842moshers
mushers124016442mushers
noshers103614332noshers
pashes115828392pashe_s
passers94717752passers
pasters94531732pasters
pishers123815752pishers
plashers133813452plashers
pushers123814502pushers
quashers20186802quashers
racers84725432ra_cers
rachets124516832rachets
rackers134320452rackers
rafters103715632rafters
raiders84615142raiders
railers74420662railers
raisers73617392raisers
rakers104123572ra_kers
rammers113715042rammers
ranchers133311792ranchers
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
rapers84327182ra_pers
raphes115117452raphe_s
rapiers95012872rapiers
rappers113618442rappers
raser55633412ras_er_
rases55447212ras_e_s
rashest103916872rashest
rashness1138092rashness
rasper83917332rasper_
raster64731442raster_
rasures7312012rasures
raters63936582ra_ters
rather94319742rather_
ratters74422472ratters
ravers94628182ra_vers
ravishers1564782ravishers
razers154919612ra_zers
reachers133515722reachers
reshes94124362reshe_s
resters74130402resters
risers64624782ris_ers
riskers114011992riskers
roasters83615932roasters
rosters73727542rosters
rushees103311952rushees
rusher94019652rusher_
rushes94724362rushe_s
sashes94728482sashe_s
slashers113313612slashers
smashers13339592smashers
swashers14389532swashers
tasters74225642tasters
thrashers1565312thrashers
trasher104416132trasher_
trashes104119262trashe_s
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 Limit1076711333.51630623.2
3Display Results1331330.0632111.1
 (SQL Overall)1786911333.95245215.3
 
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.