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

129 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
restacked163648(None) 
restocked1655171restocked
retacked15169271re_tacked
reattacked1743222reattacked
repacked17188742re_packed
reracked15169122re_racked
resoaked1337942resoa_ked
respaced1338502respac_ed
restabled12148962restabled
restack1339432restack__
restacks1438092restack_s
restaffed1653752restaffed
restaged103011862resta_ged
restamped1444432restamped
restarted10410052restarted
restated93120182resta_ted
restoked135710532rest_oked
retackled1644072re_tackled
retracked1657452retracked
stacked143416122__stacked
unstacked1636432unstacked
attacked15125113_attacked
destained1158253destained
detached1537733de_tached
deticked1635693de_ticked
estated83715573_esta_ted
gestated102910573gesta_ted
mustached17164833mustached
peptalked1842473peptalked
prepacked20155653pre_packed
presoaked1635653presoa_ked
prestamped1742963prestamped
racked134526083r___acked
ransacked1643843ransacked
reached134619083re__ached
reacted103015713re__acted
reattached1643103reattached
reawaked16366623reawa_ked
rechecked2143973rechecked
recked134821803re___cked
recocked17248473re_cocked
redacted12410243re_dacted
rednecked1743163rednecked
redocked16206823re_docked
reenacted1236853reenacted
refaced133713573re_fac_ed
refracted1557393refracted
rejacket2166733re_jacket
relaced103517213re_lac_ed
relocked15217743re_locked
remarked15209243re_marked
rematched1745223rematched
reparked15208923re_parked
repatched1745313repatched
replaced133211403replac_ed
resailed93613063res_ailed
resawed113111183res_a_wed
rescaled113311303resca_led
rescued10410043res__cued
resealed92713973resea_led
researched1643433researched
reseated93220263resea_ted
resected112514743res_ected
reshaped1437203resha_ped
reshaved1536873resha_ved
reslated93517523resla_ted
respace11310913respac_e_
respaces12311043respac_es
respaded1238133respa_ded
respected1438493respected
restable101618443restable_
restables111511423restables
restacking1737183restacking
restage83316193resta_ge_
restages92815773resta_ges
restate73824883resta_te_
restates83423433resta_tes
rested74430783rest___ed
restitched1644133restitched
restock1338673restock__
restocks1437503restock_s
restoke116113903rest_oke_
restokes125213043rest_okes
restored96417193rest_ored
restrained1148413restrained
restricken1643793restricken
restricted1348303restricted
restrike1239673restrike_
restrikes1339413restrikes
restudied11104853restudied
restuffed1663333restuffed
restyled1236953rest_yled
retack122612823re_tack__
retackle1445043re_tackle
retackles1545363re_tackles
retacks132210713re_tack_s
retagged1136063re_tagged
retailed94113963re_tailed
retained93016093re_tained
retake104718533re_ta_ke_
retaken113911803re_ta_ken
retaker113714313re_ta_ker
retakes113718863re_ta_kes
retaped103814283re_ta_ped
retarded102410753re_tarded
retasted92412113re_tasted
retaxed153512233re_ta_xed
retched133814273re_t_ched
retraced111413023retrac_ed
retracted12410953retracted
rewaked153811903re_wa_ked
sacked135525213__s_acked
shacked174015393__shacked
slacked143815453__slacked
smacked163710993__smacked
snacked144013113__snacked
stacker134416263__stacker
staked114621943__sta_ked
stalked123811173__stalked
sticked144114633__sticked
stocked144312873__stocked
swacked173110523__swacked
tacked134723943___tacked
tentacled1244953tentacled
testacies1148373testacies
tictacked18153053tictacked
unstalked1435523unstalked
unstocked1645063unstocked
untacked15239923_untacked

Search took 9 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.440406115.9
2DLD Change Limit1486411297.93618730.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911298.42221217.2
 
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.