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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
restocked165517(None) 
restacked1636481restacked
restoked135710531resto_ked
recocked17248472re_cocked
redocked16206822re_docked
relocked15217742re_locked
resoaked1337942res_oaked
restock1338672restock__
restocks1437502restock_s
restoke116113902resto_ke_
restokes125213042resto_kes
restored96417192resto_red
retacked15169272re_tacked
stocked144312872__stocked
unstocked1645062unstocked
bemocked1934073be_mocked
besmoked17405413besmo_ked
bestowed14156613besto_wed
defrocked2043053defrocked
deticked1635693de_ticked
estopped1334993_estopped
festooned1344303festooned
overstocked2143093overstocked
peacocked2042863peacocked
presoaked1635653pres_oaked
prestored125111673presto_red
reattacked1743223reattacked
rebooked15226503re_booked
rechecked2143973rechecked
recked134821803re___cked
recooked15268243re_cooked
recorked15239853re_corked
rednecked1743163rednecked
reevoked16355143reevo_ked
relooked13236653re_looked
repacked17188743re_packed
reracked15169123re_racked
rescored114513103resco_red
rescued10410043res__cued
resected112514743res_ected
reshoed112212153resho__ed
reshowed15117063resho_wed
resodded1136353res_odded
resoled84119283res_o_led
resolved12349343res_olved
resorbed1138533res_orbed
resorted9313493res_orted
resowed113712253res_o_wed
respaced1338503respac_ed
respected1438493respected
respoke134311283respo_ke_
respoken14506923respo_ken
responded1336513responded
respooled1245593respooled
respotted1235953respotted
restabled12148953restabled
restack1339433restack__
restacks1438093restack_s
restaffed1653753restaffed
restaged103011863rest_aged
restamped1444433restamped
restarted10410053restarted
restated93120183rest_ated
rested74430783rest___ed
restitched1644133restitched
restocking1745703restocking
restore75822983resto_re_
restorer84813723resto_rer
restores85222993resto_res
restricken1643793restricken
restricted1348303restricted
restrike1239673restrike_
restrikes1339413restrikes
restudied11104853restudied
restuffed1663333restuffed
restyled1236943rest_yled
retackled1644073re_tackled
retched133814273re_t_ched
retooled938473re_tooled
retorted9312333re_torted
retouched1545113re_touched
retracked1657453retracked
revoked154410523re_vo_ked
reworked16247773re_worked
rocked135022323r___ocked
shocked174611813__shocked
smocked16398223__smocked
socked134721503__s_ocked
stacked143416123__stacked
sticked144114633__sticked
stocker133713083__stocker
stoked114718293__sto_ked
stooked124312303__stooked
tictocked18152723tictocked
tussocked1641773tussocked
unstacked1636433unstacked

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.453394461.4
2DLD Change Limit148641966.54622707.1
3Display Results96960.0303200.0
 (SQL Overall)178691967.02925422.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.