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

108 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
dashers11501686(None) 
bashers124820831bashers
dasher104318981dasher_
dashes106124981dashe_s
kashers143914021kashers
lashers104121831lashers
mashers124621051mashers
rashers104020911rashers
washers134517521washers
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
dabbers123813212dabbers
dabsters1137052dabsters
dackers143417042dackers
daggers103714912daggers
daikers124010312daikers
dammers123214272dammers
damners104112112damners
dampers123915692dampers
dancers103413092dancers
danders93921182danders
dangers94818212dangers
darers75921872da_rers
darners83815772darners
darters84017602darters
dashed115920562dashe_d
dasheen1136392dasheen
dasheens1244692dasheens
dashier114311182dashier_
dashis104414392dash_is
daters74827372da_ters
daubers104610422daubers
deashes113313902deashe_s
diasters92913182diasters
dishes104622652dishe_s
dithers114016152dithers
dosers75723632dos_ers
dossers84516232dossers
dusters84918362dusters
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
masers84623452mas_ers
masher114123202masher_
mashes115030002mashe_s
maskers133913842maskers
masters94628922masters
moshers124017842moshers
mushers124016442mushers
noshers103614332noshers
pashes115828392pashe_s
passers94717752passers
pasters94531732pasters
pishers123815752pishers
plashers133813452plashers
pushers123814502pushers
quashers20186802quashers
rasers64526782ras_ers
rasher95024122rasher_
rashes95330152rashe_s
raspers94415922raspers
rasters74629022rasters
rushers103816102rushers
sashes94728482sashe_s
slashers113313612slashers
smashers13339592smashers
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 Limit1076711083.03335499.8
3Display Results1081080.0462347.8
 (SQL Overall)1786911083.45251764.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.