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

148 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
restacks143809(None) 
restack1339431restack_
restocks1437501restocks
retacks132210711re_tacks
reattacks1543752reattacks
repacks15269542re_packs
reracks132310532re_racks
resoaks1148972resoa_ks
respaces12311042respaces
restacked1636482restacked
restaffs1444782restaffs
restages92815772restages
restamps1234702restamps
restarts8310872restarts
restates83423432restates
restock1338672restock_
retack122612822re_tack_
retracks14149102retracks
stacks124317262__stacks
unstacks1446042unstacks
attacks13126943_attacks
bedticks1774163bedticks
cestas85018543cesta__s
cossacks1645223cossacks
destains9311813destains
deticks1437353de_ticks
diestocks1644383diestocks
estates74520183_estates
eyestalks16132343eyestalks
fastbacks2044253fastbacks
gestalts955493gestalts
gestapos1153913gestapos
gestates93213733gestates
haystacks2143373haystacks
penstocks1743713penstocks
peptalks1653843peptalks
prepacks1836583pre_packs
presoaks1436603presoa_ks
prestamps1543523prestamps
racks115028853r___acks
ransacks1445773ransacks
reacts83616603re__acts
reatas64021013reata__s
reattack1444123reattack_
rebecks15288013re_becks
rechecks1944553rechecks
recks115625133re___cks
recocks154711463re_cocks
redacts10510943re_dacts
rednecks1544013rednecks
redocks14409933re_docks
redshanks1742323redshanks
redstarts1044243redstarts
redtails968003redtails
reenacts1036993reenacts
refaces123216743re_faces
refracts13137383refracts
reitboks1443073reitboks
relaces93420883re_laces
relocks134411293re_locks
remarks13329983re_marks
rentals74017473renta_ls
repack142412163re_pack_
reparks13249513re_parks
replaces123114123replaces
rerack122513163re_rack_
resails74616743res_ails
resales74724903res_ales
resaws93713513res_a_ws
resays93714153res_a_ys
rescales103414573rescales
reseals73917663resea_ls
reseats74319583resea_ts
reseaus74012153resea_us
resects94115593res_ects
reseeks11348623res_eeks
reshapes1338803reshapes
reshaves1438733reshaves
reslates83619503reslates
resoak10311093resoa_k_
respace11310913respac_e
respaced1338503respaced
respades1139853respades
respeaks1434953respeaks
respects1247703respects
restable101618443restable
restables111511423restables
restacking1737183restacking
restaff1339013resta_ff
restage83316193resta_ge
restaged103011863restaged
restamp1146483resta_mp
restart7320033resta_rt
restate73824883resta_te
restated93120183restated
resters74130403rest_ers
restless82713163restless
restocked1655173restocked
restoke116113903rest_oke
restokes125213043restokes
restores85222993restores
restrains9311623restrains
restress82511773restress
restricts1138823restricts
restrike1239673restrike
restrikes1339413restrikes
restruck1445223restruck_
rests54935873rest___s
restuffs1444193restuffs
restyles1139193restyles
retacked15169273re_tacked
retackle1445043re_tackle
retackles1545363re_tackles
retags73414303re_ta_gs
retails74718973re_tails
retains74522253re_tains
retake104718533re_ta_ke
retakes113718863re_takes
retapes93917423re_tapes
retards85015003re_tards
retaxes143615093re_taxes
retraces101417273retraces
retrack131310723retrack_
retracts101111313retracts
runbacks1655903runbacks
rustics9810733rustic_s
sacks114228873__s_acks
seatbacks17115603seatbacks
setbacks1686303setbacks
shacks154817563__shacks
slacks124416533__slacks
smacks144112323__smacks
snacks124514553__snacks
stack114421693__stack_
stalks104614553__stalks
stanks104917703__stanks
sticks125118613__sticks
stocks124715633__stocks
tacks115430133___tacks
testacies1148373testacies
testacy1235963testac_y
testates83615453testates
unstack1337373unstack_
unsticks1436233unsticks
untacks1357503_untacks
vestals104612333vesta_ls
vestas95916683vesta__s
wetbacks1974983wetbacks

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621487.89318517.9
3Display Results1481480.0602466.7
 (SQL Overall)1786911488.37321341.3
 
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.