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

117 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
graders9471601(None) 
grader84919691grader_
grades84926311grade_s
graters85419741graters
gravers114515271gravers
grazers175112451grazers
traders84316951traders
abraders1137342abraders
beaders104120182beaders
bladers104214682bladers
bracers114616702bracers
braiders114110572braiders
branders114313092branders
bravers124715522bravers
brayers124511902brayers
brazers184513942brazers
carders104820352carders
cradlers11309202cradlers
craters95021892craters
cravers124416562cravers
degraders12245932degraders
drapers105313352drapers
drawers113610072drawers
erasers74413942erasers
evaders1136932evaders
faders105117462_faders
framers125113822framers
fraters103517212fraters
gadders103611502gadders
gagers84021332g_agers
gamers94420832g_amers
ganders93521702ganders
gapers94520472g_apers
gardens93312092gardens
garners83815982garners
garters84218232garters
gaters74728642g_aters
gazers164516302g_azers
gelders93812572gelders
genders93616782genders
gilders94212462gilders
girders9379942girders
glades84820342glade_s
glanders103811502glanders
glazers174410042glazers
gliders94811842gliders
gnawers11356392gnawers
grabbers13337882grabbers
grabens10367002grabens
graces94523492grace_s
grade75126092grade__
graded94919552grade_d
gradins93416232gradins
grads75625752grad__s
gradus84411222grad_us
grafters12409192grafters
grainers93012072grainers
grandees103211282grandees
grander93315872grander_
grandeurs11335112grandeurs
grangers103011972grangers
granters93614142granters
grapery13457952grapery
grapes95123122grape_s
graspers11338402graspers
grater74625442grater_
grates75429892grate_s
gravels113611142gravels
graver105018592graver_
graves104624002grave_s
grayer106014542grayer_
grazer164815762grazer_
grazes164519642graze_s
graziers18387122graziers
greasers93410252greasers
gridders11286292gridders
grides84422362gride_s
grinders103410422grinders
gripers104011462gripers
groaners9248502groaners
grocers103511252grocers
gropers104813852gropers
growers113612722growers
grudgers11266752grudgers
guarders1035882guarders
guiders94111112guiders
headers113819392headers
irades74517392irade_s
kraters114212342kraters
laders74927762_laders
larders83516942larders
leaders83819602leaders
loaders83413432loaders
orders74315992or_ders
paraders113113112paraders
praters94921652praters
prayers124212852prayers
racers84725432_racers
radars71314672_radars
raiders84615142_raiders
rakers104123572_rakers
rapers84327182_rapers
rasers64526782_rasers
raters63936582_raters
ravers94628182_ravers
razers154919612_razers
readers83823772readers
riders74123902_riders
shaders115915552shaders
spaders104214472spaders
tracers94917842tracers
trader75218762trader_
trades75724502trade_s
treaders93311842treaders
waders109120642_waders
warders113416812warders
yarders113211592yarders

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 Limit1076711173.17333933.5
3Display Results1171170.0462543.5
 (SQL Overall)1786911173.59249746.9
 
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.