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 “retracked” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
retracked165745(None) 
reracked15169121re_racked
retacked15169271ret_acked
retraced111413021retrac_ed
retracted12410951retracted
detracted1357792detracted
reattacked1743222reattacked
refracted1557392refracted
repacked17188742re_packed
restacked1636482restacked
retackled1644072ret_ackled
retrace91417342retrac_e_
retracer101411882retrac_er
retraces101417272retrac_es
retrack131310722retrack__
retracks14149102retrack_s
retrained10411312retrained
retroacted1366132retroacted
tracked143716132__tracked
untracked16228372untracked
attacked15125113_attacked
attracted1246073attracted
barracked1844753barracked
beraked144312433be_ra_ked
bethanked1943283bethanked
betrayed1436303betra_yed
cracked163514743__cracked
defrocked2043053defrocked
detached1537733det_ached
deticked1635693det_icked
detrained1158913detrained
extracted1946723extracted
outraced112414203outrac_ed
outranked14247863outranked
outrocked1646523outrocked
prefranked2042773prefranked
prepacked20155653pre_packed
pretrained1357063pretrained
protracted1545763protracted
racetracker1952293racetracker
racked134526083___racked
ransacked1643843ransacked
reached134619083re__ached
reacted103015713re__acted
reattached1643103reattached
reawaked16366623reawa_ked
rebranched1843673rebranched
rechecked2143973rechecked
recked134821803re___cked
recocked17248473re_cocked
recrated112918603recra_ted
redacted12410243re_dacted
rednecked1743163rednecked
redocked16206823re_docked
redrafted1435143redrafted
reenacted1236853reenacted
reerected1238613reerected
refaced133713573re_fac_ed
refrained1347223refrained
reframed1437853refra_med
regraded113410763regra_ded
regrafted1435243regrafted
regranted1137703regranted
regrated102816333regra_ted
rejacket2166733re_jacket
relaced103517213re_lac_ed
relocked15217743re_locked
remarked15209243re_marked
reparked15208923re_parked
replaced133211403replac_ed
repriced132610543repric_ed
reproached1854713reproached
rerack122513163re_rack__
reracks132310533re_rack_s
reraised9312353re_raised
resoaked1337943resoa_ked
respaced1338503respac_ed
restocked1655173restocked
restrained1148413restrained
restricken1643793restricken
restricted1348303restricted
retack122612823ret_ack__
retackle1445043ret_ackle
retackles1545363ret_ackles
retacks132210713ret_ack_s
retagged1136063ret_agged
retailed94113963ret_ailed
retained93016093ret_ained
retake104718533ret_a_ke_
retaken113911803ret_a_ken
retaker113714313ret_a_ker
retakes113718863ret_a_kes
retaped103814283ret_a_ped
retarded102410753ret_arded
retasted92412113ret_asted
retaxed153512233ret_a_xed
retched133814273ret__ched
reteaches1437123reteaches
reteamed1138013retea_med
retouched1545113retouched
retracers11149553retracers
retracing12313293retracing
retracking1738163retracking
retract91318113retrac__t
retractor11218513retractor
retracts101111313retrac_ts
retrainee9511163retrainee
retreaded1137053retreaded
retreated10312623retreated
retrenched1654393retrenched
retried84419153retr__ied
retrieved1385093retrieved
retrimmed1443673retrimmed
retrocede1245403retroc_ede
retroceded1443473retroceded
rewaked153811903re_wa_ked
rewrapped1763023rewrapped
sidetracked1952093sidetracked
stacked143416123_st_acked
straked125415343_stra_ked
tacked134723943__t_acked
terraced11318123terrac_ed
tetracid1147263tetrac_id
thacked173810203__thacked
traced94821583__trac_ed
tracker133515173__tracker
traiked123310453__traiked
tricked144016163__tricked
trocked144312243__trocked
trucked143910813__trucked
uncracked18226803uncracked
untacked15239923unt_acked
untraced112413243untrac_ed
wracked174110113__wracked

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411347.44019978.6
3Display Results1341340.0602233.3
 (SQL Overall)1786911347.92022562.0
 
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.