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

148 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
traced9482158(None) 
braced115420601braced
graced105217901graced
raced87635311_raced
trace75829611trace_
tracer84820231tracer
traces85329931traces
tracked143716131tracked
traded85717681traded
tranced104414171tranced
triced95518671triced
truced95312051truced
aced79540882__aced
arced88224162ar_ced
brace95629272brace_
bracer104620582bracer
braces108427772braces
bracted12410932bracted
braked135318692braked
braved124817442braved
brayed124615782brayed
brazed184717082brazed
cracked163514742cracked
craned96121652craned
craped116120532craped
crated94827772crated
craved125417772craved
crazed184714452crazed
draped105314362draped
drayed115911392drayed
erased74816762erased
faced117727652_faced
farced125216532farced
fracted1339372fracted
framed125116522framed
frayed135012162frayed
grace85124542grace_
graces94523492graces
graded94919552graded
grated84523922grated
graved114818812graved
grayed115415642grayed
grazed174115912grazed
laced87132642_laced
maced108528692_maced
orated74221502orated
outraced112414212outraced
paced106931682_paced
peaced115818912peaced
placed114318002placed
pranced123714042pranced
prated94924922prated
prayed124815432prayed
priced115018882priced
race66746262_race_
racer75233022_racer
races74943242_races
racked134526082_racked
raged74829452_raged
raked105831422_raked
raped85334622_raped
rared65738322_rared
rased65033932_rased
rated65441382_rated
raved94931432_raved
raxed135622662_raxed
rayed95127502_rayed
razed155027982_razed
retraced111413032retraced
riced85825542_riced
spaced114517252spaced
strafed114413332strafed
straked125415342straked
strawed114813622strawed
strayed114513282strayed
tace65342512t_ace_
taces76237802t_aces
tacet75840022t_acet
tacked134723942t_acked
talced93811002talced
tamed85528512t_amed
taped85327422t_aped
tared69340052t_ared
tarred74720282tarred
tarted74923372tarted
tawed95926192t_awed
taxed135620292t_axed
teamed95418592teamed
teared75722152teared
teased74721152teased
teated74924022teated
terraced11318132terraced
thacked173810202thacked
thawed13458462thawed
thrawed1435592thrawed
ticced11438442ticced
tracers94917842tracers
tracery12399792tracery
trachea12311682trachea
tracheid1437582tracheid
trachled1438312trachled
track114823012trac_k
tracker133515172tracker
tracks124818842tracks
tract75635712trac_t
tracts85019072tracts
trad55630912tra__d
trade65026042trade_
trader75218762trader
trades75724502trades
traduced1244672traduced
tragedy1234792tragedy
traiked123310452traiked
trailed83415672trailed
trained84117202trained
tramel84113712tramel
trammed123810712trammed
tramped124312432tramped
trance84718762trance_
trances93919642trances
trapes85024462trapes
trapped124512212trapped
trashed113514702trashed
trave85223032trave_
travel94112982travel
traves94222742traves
trawled113411522trawled
treaded95014282treaded
treated83618702treated
treed65626732tr_eed
triacid1038592triacid
triaged92810442triaged
trice75127492trice_
tricep103911072tricep
trices84826332trices
tricked144016162tricked
tried65026912tr_ied
trined74920712trined
troaked12438252troaked
trocked144312242trocked
troked114114582troked
trowed104714652trowed
truce75118692truce_
truces84916332truces
trucked143910812trucked
trued65117692tr_ued
untraced112413252untraced
wracked174110112wracked

Search took 3 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 Filter178691825510.376475242.0
2DLD Change Limit825511482.43633887.9
3Display Results1481480.0463217.4
 (SQL Overall)1786911482.85862523.1
 
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.