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

150 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
lashers10412183(None) 
bashers124820831bashers
clashers134213991clashers
dashers115016861dashers
flashers143912651flashers
kashers143914021kashers
lasers64925701las_ers
lasher94824531lasher_
lashes94831001lashe_s
lasters75627691lasters
lathers104321881lathers
mashers124621051mashers
plashers133813451plashers
rashers104020911rashers
slashers113313611slashers
washers134517521washers
ashes86230612_ashe_s
ashlers10319582_ashlers
askers105915402_askers
aspers86220312_aspers
asters65631602_asters
basher115123812basher_
bashes115631392bashe_s
basters94930302basters
bathers124720362bathers
blasters104116142blasters
blathers134713792blathers
blushers133911292blushers
bushers124018802bushers
cashes114729882cashe_s
cashews15428602cashews
cashiers13318882cashiers
casters94729902casters
clasher124615512clasher_
clashes124017282clashe_s
claspers124410912claspers
classers104111832classers
coshers123618182coshers
crashers134013232crashers
dasher104318982dasher_
dashes106124982dashe_s
easters75125682easters
fashes124524022fashe_s
fathers133916502fathers
fishers134714722fishers
flasher133914062flasher_
flashes133916102flashe_s
fleshers14339442fleshers
flushers14279732flushers
gasher104320372gasher_
gashes105725152gashe_s
gaspers105014132gaspers
gassers84714632gassers
gasters85624292gasters
gathers114315072gathers
gushers113512512gushers
hashes125024802hashe_s
jaspers164310462jaspers
joshers174111592joshers
kasher134915032kasher_
koshers144811802koshers
laagers83411252laagers
lacers85225252la_cers
laches116528352lache_s
lackers134120542lackers
ladders94115172ladders
laders74927762la_ders
ladlers84613572ladlers
lagers74826142la_gers
laggers94216242laggers
lahars94013162la_hars
lakers105225152la_kers
lambers113817112lambers
lampers113817332lampers
lamsters1099752lamsters
lancers93616642lancers
landers84026212landers
lanners73618332lanners
lappers113717462lappers
lapsers93911052lapsers
larders83516942larders
larkers113014512larkers
lascars979012lascars
laser54633322las_er_
lases54944762las_e_s
lashed105625212lashe_d
lashins103915152lashins
lashkars1543672lashkars
lasses64827592lasse_s
lassoers8338512lassoers
laster64830632laster_
lather95124362lather_
lathery133911122lathery
lathes95127502lathe_s
lauders84012892lauders
laughers1235922laughers
laveers10329362laveers
lavers94526362la_vers
lavishers1564642lavishers
lawyers13377152lawyers
layers93921182la_yers
leachers133712812leachers
leasers74717842leas_ers
leashes103514402leashe_s
leathers114215082leathers
lechers123313962lechers
lispers94514322lispers
listers74026532listers
loathers113310442loathers
losers65123582los_ers
lusher93818762lusher_
lushes94022742lushe_s
lusters73921442lusters
masers84623452mas_ers
masher114123202masher_
mashes115030002mashe_s
maskers133913842maskers
masters94628922masters
moshers124017842moshers
mushers124016442mushers
noshers103614332noshers
pashes115828392pashe_s
passers94717752passers
pasters94531732pasters
pishers123815752pishers
plasher124215032plasher_
plashes124417392plashe_s
plasters103518132plasters
pushers123814502pushers
quashers20186802quashers
rasers64526782ras_ers
rasher95024122rasher_
rashes95330152rashe_s
raspers94415922raspers
rasters74629022rasters
rushers103816102rushers
sashes94728482sashe_s
slasher104515332slasher_
slashes103619112slashe_s
slathers113914782slathers
smashers13339592smashers
splashers1445282splashers
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.376475242.0
2DLD Change Limit1076711503.48330913.3
3Display Results1501500.0632381.0
 (SQL Overall)1786911503.92245561.2
 
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.