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

185 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
restack133943(None) 
restacks1438091restacks
restock1338671restock
retack122612821re_tack
reattack1444122reattack
repack142412162re_pack
rerack122513162re_rack
resoak10311092resoa_k
respace11310912respace
restacked1636482restacked
restaff1339012restaff
restage83316192restage
restamp1146482restamp
restart7320032restart
restate73824882restate
restocks1437502restocks
restruck1445222restruck
retacks132210712re_tacks
retrack131310722retrack
stack114421692__stack
testacy1235962testacy
unstack1337372unstack
attack12148153_attack
bedtick1645233bedtick
cesta75419483cesta__
cestas85018543cesta_s
cossack1545823cossack
crestal9312133cresta_l
destain8412083destain
detach12310413de_tach
detick1339383de_tick
diestock1544863diestock
estate64719763_estate
eustacy1254663eustacy
eyestalk15123173eyestalk
fastback1944523fastback
festal94213563festa_l
gestalt8411163gestalt
gestapo1044493gestapo
gestate83614073gestate
gestic9312773gestic_
haystack2044013haystack
penstock1644073penstock
peptalk1554823peptalk
prepack1757643pre_pack
presoak1348453presoa_k
prestamp1445323prestamp
rack106234883r___ack
ransack1346463ransack
reach105123883re__ach
react74634333re__act
reata54225393reata__
reatas64021013reata_s
reattach1343743reattach
reattacks1543753reattacks
rebeck14419913re_beck
recheck1835613recheck
reck106130563re___ck
recock145112723re_cock
recta74220263recta__
rectal84418133recta_l
redact9419043re_dact
redneck1445113redneck
redock134311543re_dock
redshank1642893redshank
redstart949193redstart
redtail858713redtail
reenact9413003reenact
reface113616353re_face
refract121311603refract
reitbok1343133reitbok
relace83122153re_lace
relock124713523re_lock
remark123512373re_mark
rematch1436193rematch
rental63922023renta_l
rentals74017473rentals
repacks15269543re_packs
repark123511713re_park
repatch1435843repatch
replace113214283replace
reptant92817073reptant
reracks132310533re_racks
resaid74517083res_aid
resail64418733res_ail
resale64025543res_ale
resat55139683res_a_t
resaw84117253res_a_w
resawn9399953res_awn
resaws93713513res_aws
resay85320543res_a_y
resays93714153res_ays
rescale93215473rescale
reseal64819643resea_l
reseals73917663reseals
research1344553research
reseat64131493resea_t
reseats74319583reseats
reseau64216213resea_u
reseaus74012153reseaus
reseaux14326233reseaux
resect84424703res_ect
reseek103813133res_eek
reshape1249043reshape
reshave1338603reshave
reslate73520593reslate
resoaks1148973resoaks
respaced1338503respaced
respaces12311043respaces
respade1039573respade
respeak1335933respeak
respect11412033respect
rest46459843rest___
restable101618443restable
restacking1737183restacking
restaffs1444783restaffs
restaged103011863restaged
restages92815773restages
restamps1234703restamps
restarts8310873restarts
restated93120183restated
restates83423433restates
rested74430783rest_ed
rester63832433rest_er
resters74130403resters
restful1038623restful
resting85031183resting
restitch1344693restitch
restive10315933restive
restocked1655173restocked
restoke116113903restoke
restore75822983restore
restrain8311703restrain
restrict10313633restrict
restrike1239673restrike
rests54935873rest__s
restudy1144763restudy
restuff1346953restuff
restyle1038763restyle
retacked15169273re_tacked
retackle1445043re_tackle
retag63618413re_ta_g
retags73414303re_tags
retail65522073re_tail
retain64523283re_tain
retake104718533re_take
retape83917683re_tape
retard75018933re_tard
retax124517973re_ta_x
retch104818303re_t_ch
reteach1237413reteach
retook104313443re_took
retrace91417343retrace
retracks14149103retracks
retract91318113retract
runback1556603runback
rustic8712673rustic_
rustics9810733rustics
sack105337313__s_ack
seatback1675823seatback
setback1567143setback
shack145321753__shack
slack115021763__slack
smack134615453__smack
snack114718063__snack
stacks124317263__stacks
stalk94518003__stalk
stank95823303__stank
stark95425623__stark
stick115121563__stick
stock114417563__stock
stuck114515773__stuck
tack106536293___tack
testa54822043testa__
testae64216253testa_e
testate73916233testate
unstacks1446043unstacks
unstick1338123unstick
unstuck1345023unstuck
untack1239763_untack
vesta86618303vesta__
vestal94615573vesta_l
vestals104612333vestals
vestas95916683vesta_s
wetback1875613wetback

Search took 7 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.420425454.8
2DLD Change Limit1340271856.33021173.3
3Display Results1851850.0762434.2
 (SQL Overall)1786911856.82626178.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.