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

189 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
restock133867(None) 
restack1339431restack
restocks1437501restocks
diestock1544862diestock
penstock1644072penstock
recock145112722re_cock
redock134311542re_dock
relock124713522re_lock
resoak10311092res_oak
restacks1438092restacks
restocked1655172restocked
restoke116113902restoke
restore75822972restore
restruck1445222restruck
retack122612822re_tack
retook104313442re_took
stock114417562__stock
bedrock1645643bedrock
bedtick1645233bedtick
bemock1636173be_mock
bestow1149463besto_w
bestows1248863bestows
betook12439603be_took
bitstock1643333bitstock
bittock1544433bittock
buttock1545563buttock
cassock1545953cassock
cestode1037963cestode
cestoi84511953cesto_i
cestoid104011673cestoid
cestos84718093cesto_s
defrock1744643defrock
detick1339383de_tick
diestocks1644383diestocks
estop74312103_esto_p
estops84011223_estops
fatstock1743613fatstock
feedstock1952283feedstock
festoon1037673festoon
fetlock1645323fetlock
foreshock2144053foreshock
futtock1644153futtock
gestic9312773gestic_
gunstock1543463gunstock
hassock1645443hassock
headstock1943013headstock
hemlock1845633hemlock
kebbock1643613kebbock
linstock1444433linstock
livestock1852503livestock
mattock1535823mattock
mistook1337153mistook
nestor63713423nesto_r
nestors73614973nestors
nostoc868193nostoc_
nostocs947553nostocs
overstock1844503overstock
peacock1745143peacock
penstocks1743713penstocks
pesto75723723pesto__
pestos84719083pesto_s
petcock1744603petcock
prerock1536723pre_rock
presoak1348453pres_oak
presto84216203presto__
prestore104217343prestore
prestos93716083presto_s
reattack1444123reattack
rebeck14419913re_beck
rebook125213203re_book
recheck1835613recheck
reck106130563re___ck
recocks154711463re_cocks
recook125513923re_cook
recork126315483re_cork
recto74520803recto__
rector84019743recto_r
rectors93520513rectors
rectory123512723rectory
rectos85718783recto_s
redneck1445113redneck
redocks14409933re_docks
redtop937973redto_p
redtops1037373redtops
reitbok1343133reitbok
relocks134411293re_locks
relook104813743re_look
repack142412163re_pack
rerack122513163re_rack
rescore95616193rescore
resect84424703res_ect
reseek103813133res_eek
reshod103012233resho_d
reshoe92816483resho_e
reshoed112212153reshoed
reshoes102316033reshoes
reshone102414163reshone
reshoot102513893reshoot
reshot93519633resho_t
reshow123111433resho_w
reshown13257903reshown
reshows132510453reshows
resoaks1148973res_oaks
resod64720053res_o_d
resods74116303res_ods
resold73915363res_old
resole64624183res_ole
resorb84914343res_orb
resort65728613res_ort
resow88217243res_o_w
resown94112923res_own
resows93915353res_ows
respace11310913respace
respeak1335933respeak
respect11412033respect
respoke134311283respoke
respond1039113respond
respool937633respool
respot83117633respo_t
respots92912763respots
rest46459843rest___
restacked1636483restacked
restaff1339013restaff
restage83316193restage
restamp1146483restamp
restart7320033restart
restate73824883restate
rested74430783rest_ed
rester63832433rest_er
resters74130403resters
restful1038623restful
resting85031183resting
restitch1344693restitch
restive10315933restive
restocking1745703restocking
restoked135710533restoked
restokes125213043restokes
restoral8810983restoral
restored96417193restored
restorer84813723restorer
restores85222993restores
restrict10313633restrict
restrike1239673restrike
restroom1047573restroom
restrove1138963restrove
rests54935873rest__s
restudy1144763restudy
restuff1346953restuff
restyle1038763restyle
retacks132210713re_tacks
retch104818303re_t_ch
retold73013753re_told
retool63914483re_tool
retore67630763re_tore
retorn610923423re_torn
retort66831143re_tort
retouch1235853re_touch
retrack131310723retrack
rework136619783re_work
rimrock1544383rimrock
rock105735183r___ock
rootstock1552683rootstock
rowlock1654783rowlock
ruddock1543133ruddock
rustic8712673rustic_
rustics9810733rustics
seacock1545573seacock
seedstock1652323seedstock
shock144917033__shock
smock135311673__smock
sock105233213__s_ock
stack114421693__stack
stick115121563__stick
stocks124715633__stocks
stocky15369153__stocky
stook95218213__stook
stork96819693__stork
stuck114515773__stuck
testacy1235963testacy
teston6313303testo_n
testons7313553testons
testoon748363testoon
tipstock1643733tipstock
tussock1343833tussock
unstack1337373unstack
unstick1338123unstick
unstuck1345023unstuck
wedlock1744553wedlock
wristlock1851923wristlock

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271897.32618294.7
3Display Results1891890.0633000.0
 (SQL Overall)1786911897.54523683.4
 
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.