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

105 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
traders8431695(None) 
graders94716011graders
tracers94917841tracers
trader75218761trader_
trades75724501trade_s
treaders93311841treaders
abraders1137342abraders
beaders104120182beaders
bladers104214682bladers
bracers114616702bracers
braiders114110572braiders
branders114313092branders
bravers124715522bravers
brayers124511902brayers
brazers184513942brazers
carders104820352carders
cradlers11309202cradlers
craters95021892craters
cravers124416562cravers
drapers105313352drapers
drawers113610072drawers
erasers74413942erasers
evaders1136932evaders
faders105117462_faders
framers125113822framers
fraters103517212fraters
grader84919692grader_
grades84926312grade_s
graters85419742graters
gravers114515272gravers
grazers175112452grazers
headers113819392headers
irades74517392irade_s
kraters114212342kraters
laders74927762_laders
larders83516942larders
leaders83819602leaders
loaders83413432loaders
orders74315992or_ders
paraders113113122paraders
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
strafers11379912strafers
stranders10389942stranders
strayers113510142strayers
striders94412122striders
tabers84621572t_abers
takers103923742t_akers
talers64628152t_alers
tamers84224032t_amers
tapers84025812t_apers
taters64932202t_aters
tawers94118602t_awers
taxers134015282t_axers
tearers75218232tearers
teasers75317242teasers
tedders94010232tedders
tenders83719722tenders
thalers106212262thalers
thawers13428482thawers
threaders1365742threaders
tinders84219172tinders
tirades8311722tirade_s
tracer84820232tracer_
tracery12399792tracery
traces85329932trace_s
trackers143512852trackers
trade65026042trade__
traded85717682trade_d
traducers1243722traducers
trailers82912932trailers
trainers83114652trainers
tramels93812492tramels
trampers123210392trampers
trapes85024462trape_s
trappers123711042trappers
trashers113013642trashers
travels104711292travels
traverse1136212traverse
traves94222742trave_s
trawlers113310202trawlers
treader84113832treader_
treadlers1045892treadlers
treaters83615852treaters
triers64321522tr_iers
trimers94615142trimers
trovers103713322trovers
trudgers10256862trudgers
tsades74310992tsade_s
waders109120652_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.376475242.0
2DLD Change Limit1076711053.01335735.5
3Display Results1051050.0462282.6
 (SQL Overall)1786911053.43552020.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.