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

140 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
restamp114648(None) 
prestamp1445321prestamp
restamps1234701restamps
prestamps1543522prestamps
restack1339432restack
restaff1339012restaff
restage83316192restage
restamped1444432restamped
restart7320032restart
restate73824882restate
revamp1336012re_vamp
stamp95217362__stamp
bedlamp1464513bedlamp
beshame1447483beshame
cesta75419483cesta__
cestas85018543cesta_s
crestal9312133cresta_l
decamp1338453de_camp
destain8412083destain
encamp1235943_encamp
escarp10449003_escarp
estate64719763_estate
estop74312103_est_op
festal94213563festa_l
gestalt8411173gestalt
gestapo1044493gestapo
gestate83614073gestate
jetsam15116323jetsam_
jetsams16124103jetsams
metump1235713me_tump
misstamp1443803misstamp
preamp1238993pre__amp
prestamped1742963prestamped
ramp85934003r___amp
ream65841613re__am_
reams75729623re__ams
reap65934743re__a_p
reata54225393reata__
reatas64021013reata_s
recap95718023re_ca_p
reclame11411063reclame
reclasp1136643reclasp
recta74220263recta__
rectal84418133recta_l
rectum103411283rectum_
rectums11338523rectums
redcap1158493redca_p
redstart949193redstart
redtail858713redtail
redtop937973redt_op
reframe1239393reframe
remap95418103re_ma_p
rename82718813re_name
rental63922023renta_l
rentals74017473rentals
reptant92817073reptant
repump1235683re_pump
resaid74517083res_aid
resail64418733res_ail
resale64025543res_ale
resample1244673res_ample
resat55139683res_a_t
resaw84117253res_a_w
resawn9399953res_awn
resaws93713513res_aws
resay85320543res_a_y
resays93714153res_ays
rescale93215473rescale
reseal64819643resea_l
reseals73917673reseals
reseat64131493resea_t
reseats74319583reseats
reseau64216213resea_u
reseaus74012153reseaus
reseaux14326233reseaux
reshape1249043reshape
reshave1338603reshave
reship11310673res_hip
reslate73520593reslate
resoak10311093resoa_k
resoaks1148973resoaks
respace11310913respace
respade1039573respade
rest46459843rest___
restable101618443restable
restacks1438093restacks
restaffs1444783restaffs
restaged103011863restaged
restages92815773restages
restamping1565213restamping
restarts8310873restarts
restated93120183restated
restates83423433restates
rested74430783rest_ed
rester63832433rest_er
resters74130403resters
restful1038623restful
resting85031183resting
restive10315933restive
restock1338673restock
restoke116113903restoke
restore75822983restore
restrain8311703restrain
rests54935873rest__s
restudy1144763restudy
restuff1346953restuff
restyle1038763restyle
resume8313783res_ume
retack122612823re_tack
retag63618413re_ta_g
retags73414303re_tags
retail65522073re_tail
retain64523283re_tain
retake104718533re_take
retape83917683re_tape
retard75018933re_tard
retax124517973re_ta_x
reteam83214533reteam_
reteams9339563reteams
retem74221953re_tem_
retems83914573re_tems
retime85321803re_time
revamps1433993re_vamps
rewrap11127533rewra_p
samp85733593__s_amp
scamp115717313__scamp
sesame8311013ses_ame
stamps105614023__stamps
stomp95616663__stomp
stump94616463__stump
swamp125015323__swamp
tamp86133013___tamp
testa54822043testa__
testacy1235963testacy
testae64216253testa_e
testate73916233testate
vesta86618303vesta__
vestal94615573vesta_l
vestals104612333vestals
vestas95916683vesta_s

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.420425454.8
2DLD Change Limit1340271407.01619103.1
3Display Results1401400.0632222.2
 (SQL Overall)1786911407.49923828.6
 
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.