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

149 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
restocks143750(None) 
restacks1438091restacks
restock1338671restock_
diestocks1644382diestocks
penstocks1743712penstocks
recocks154711462re_cocks
redocks14409932re_docks
relocks134411292re_locks
resoaks1148972res_oaks
restack1339432restack_
restocked1655172restocked
restoke116113902resto_ke
restokes125213042restokes
restores85222992restores
retacks132210712re_tacks
stocks124715632__stocks
bedrocks1745333bedrocks
bedticks1774163bedticks
bemocks1735373be_mocks
bestows1248863besto_ws
bitstocks1743293bitstocks
bittocks1644443bittocks
buttocks1645233buttocks
cassocks1645033cassocks
cestodes1138203cestodes
cestoids11308273cestoids
cestos84718093cesto__s
defrocks1844113defrocks
deticks1437353de_ticks
diestock1544863diestock_
estops84011223_esto_ps
fatstocks1843453fatstocks
feedstocks2052043feedstocks
festoons1136443festoons
fetlocks1744713fetlocks
foreshocks2243533foreshocks
futtocks1743833futtocks
gunstocks1643233gunstocks
hassocks1744693hassocks
headstocks2042823headstocks
hemlocks1944993hemlocks
kebbocks1743023kebbocks
linstocks1544143linstocks
livestocks1952303livestocks
mattocks1644983mattocks
nestors73614973nesto_rs
nostocs947553nostoc_s
overstocks1943643overstocks
peacocks1844993peacocks
penstock1644073penstock_
pestos84719083pesto__s
petcocks1844583petcocks
presoaks1436603pres_oaks
prestores114716083prestores
prestos93716083presto__s
reattacks1543753reattacks
rebecks15288013re_becks
rebooks134010513re_books
rechecks1944553rechecks
recks115625133re___cks
recock145112723re_cock_
recooks134711233re_cooks
recorks134813023re_corks
rectors93520523recto_rs
rectos85718783recto__s
rednecks1544013rednecks
redock134311543re_dock_
redtops1037373redto_ps
refocus1236973re_focus
reitboks1443073reitboks
relock124713523re_lock_
relooks114010723re_looks
repacks15269543re_packs
reracks132310533re_racks
rescores105415693rescores
resects94115593res_ects
reseeks11348623res_eeks
reshoes102316033resho_es
reshoots11228413reshoots
reshows132510453resho_ws
resoak10311093res_oak_
resods74116303res_o_ds
resoles73823653res_oles
resorbs95010523res_orbs
resorts74817193res_orts
resows93915353res_o_ws
respaces12311043respaces
respeaks1434953respeaks
respects1247703respects
respoke134311283respo_ke
responds1136913responds
respools1036253respools
respots92912763respo_ts
restacked1636483restacked
restaffs1444783restaffs
restages92815773restages
restamps1234703restamps
restarts8310873restarts
restates83423433restates
resters74130403rest_ers
restless82713163restless
restocking1745703restocking
restoked135710533restoked
restoral8810983restoral
restorals978073restorals
restore75822983resto_re
restored96417193restored
restorer84813723restorer
restorers95110113restorers
restress82511773restress
restricts1138823restricts
restrike1239673restrike
restrikes1339413restrikes
restrooms1146033restrooms
restruck1445223restruck_
rests54935873rest___s
restuffs1444193restuffs
restyles1139193restyles
retack122612823re_tack_
retook104313443re_took_
retools73411023re_tools
retorts76016513re_torts
retracks14149103retracks
reworks145113603re_works
rimrocks1644043rimrocks
rocks114626413r___ocks
rootstocks1652363rootstocks
rowlocks1744353rowlocks
ruddocks1643043ruddocks
rustics9810733rustic_s
seacocks1645643seacocks
seedstocks1752153seedstocks
shocks154414583__shocks
smocks145710013__smocks
socks114926083__s_ocks
stacks124317263__stacks
sticks125118613__sticks
stock114417563__stock_
stocky15369153__stocky
stooks105115373__stooks
storks106115953__storks
testons7313563testo_ns
testoons837323testoons
tipstocks1743423tipstocks
tussocks1443333tussocks
unstacks1446043unstacks
unsticks1436233unsticks
wedlocks1844393wedlocks
wristlocks1951683wristlocks

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621497.44019645.4
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.92322553.5
 
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.