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

244 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
rewraps1213656(None) 
bewraps14135401bewraps
prewraps15114051prewraps
rewrap11127531rewrap_
rewrapt12138111rewrapt
bewrap13157052bewrap_
bewrapt14147132bewrapt
bewrays15145112bewrays
dewlaps1334662dewlaps
enwraps1284832enwraps
inwraps12105252inwraps
prewrap14104972prewrap_
reaps75626192re__aps
recaps103615732re_caps
redcaps1247072redcaps
redraws11218472redraws
remaps105012872re_maps
rewards114813992rewards
rewarms12439602rewarms
rewears102911042rewears
ripraps1134942ripraps
unwraps1255512unwraps
wraps105617152__wraps
becaps123811403be_caps
bedrape1277693bedrape
bedrapes1386963bedrapes
beleaps1138053beleaps
betrays12127823betrays
bewares12313373bewares
beweeps1494563beweeps
bewray14147733bewra_y
craps95328643__craps
defrags1236193defrags
defrays1436113defrays
derats74625063de_rats
derays105514253de_rays
dewans105215143dew_ans
dewars105117073dew_ars
dewdrops1542963dewdrops
dewlap1264843dewlap_
earlaps936393_earlaps
enrapt8313013_enrapt
entraps9109763entraps
enwrap1185213enwrap_
eras45441503_e_ra_s
eyras84715923_eyra_s
ferals94216643fe_rals
firetraps1444303firetraps
fraps105620553__fraps
gelcaps1235203gelcaps
gerahs1039413ge_rahs
gewgaws1541643gewgaws
heaps105223223he__aps
inwrap11115903inwrap_
leaps75522933le__aps
neaps75618323ne__aps
perhaps1446123perhaps
perps95521483pe_r_ps
petnaps1145033petnaps
prewarms15406733prewarms
prewarns13456943prewarns
raps66247733___raps
rattraps1044823rattraps
readapt1039743readapt
readapts1145583readapts
reads64835273re__ads
reals55038653re__als
reams75729623re__ams
reap65934743re__ap_
rearers74323563rearers
rearms85114653rear_ms
rears54739653re__ars
reatas64021013reata_s
rebars84019833re_bars
rebops10311433re_bops
recap95718023re_cap_
reclads1049993reclads
reclasp1136643reclasp
reclasps1235053reclasps
recoals94214623recoals
recoats92616643recoats
recoups1188843recoups
recrate92621663recrate
recrates102420373recrates
recross989843recross
redans75421023re_dans
redbays1336013redbays
redcap1158493redcap_
redears82814453redears
redials84416883redials
redias74523603redia_s
redips93713843re_dips
redraft11310573redraft
redrafts1235603redrafts
redraw10269853redra_w
redrawn11245953redrawn
redreams1195953redreams
redress82511873redress
redries83721713redries
redtops1037373redtops
redwares1239053redwares
reearns749103reearns
reflags1156953reflags
refract121311603refract
refracts13137383refracts
refrain10310043refrain
refrains1139593refrains
reframe1239393reframe
reframes1338993reframes
refries104419733refries
regards94112563regards
regears83012463regears
reggaes948883reggaes
regrade92612033regrade
regrades103212173regrades
regraft11310153regraft
regrafts1235303regrafts
regrant8317323regrant
regrants9310013regrants
regrate82618663regrate
regrates92618403regrates
regress82711453regress
regrets83212923regrets
regroups11104383regroups
regrows11269153regrows
rehabs1139023re_habs
rehears103312773rehears
reheats104513523reheats
relapse947703re_lapse
relays94316753re_lays
reloads8911313reloads
reloans7313133reloans
remans84823003re_mans
remap95418103re_map_
remarks13329983remarks
remoras9314073remora_s
rentals74017473rentals
reparks13249513reparks
repass84114703re_pass
repays113813973re_pays
repeals94014523repeals
repeats94316053repeats
replans92814943replans
replays12399763replays
repps95114343re__pps
repress92712683repress
repros84216003repr_os
reps65937953re___ps
repumps1334403repumps
rerack122513163re_rack
reracks132310533re_racks
reraise7316313re_raise
reran57329103re_ra_n
rereads81512293rereads
rerigs74014793re_rigs
reruns66413743re_runs
resaws93713513re_saws
resays93714153re_says
reseals73917673reseals
reseats74319583reseats
reseaus74012153reseaus
reshape1249043reshape
reshapes1338803reshapes
reships1239863reships
resoaks1148973resoaks
resprays1344713resprays
restamps1234703restamps
retags73414303re_tags
retape83917683re_tape
retapes93917423re_tapes
retards85015003retards
reteams9339563reteams
retears72814923retears
retrace91417343retrace
retraces101417273retraces
retrack131310723retrack
retracks14149103retracks
retract91318113retract
retracts101111313retracts
retrain7615423retrain
retrains8314533retrains
retral64419743retra_l
retreads937823retreads
retreats8311413retreats
retrials8510823retrials
retries74129073retries
retrims93612373retrims
retros63820193retr_os
revamps1433993revamps
reveals103812723reveals
rewake135218463rew_ake
rewakes144614983rewakes
rewan85623663rew_a_n
reward106017643rew_ard
rewarm115913493rew_arm
rewash1237673rew_ash
rewax155713923rew_a_x
rewaxes173911333rewaxes
rewear93012003rewea_r
reweave1336773reweave
reweaves1436603reweaves
reweds104412303rew_eds
rewelds11457413rewelds
rewets94617213rew_ets
rewinds114810483rewinds
rewins95020823rew_ins
rewires104717113rewires
rewords115413983rewords
reworks145113603reworks
rewrapped1763033rewrapped
rewrite10311143rewrite
rewrites11311063rewrites
rewrote1039123rewrote
ricracs1136363ricracs
riprap1055513riprap_
rowans95715343row_ans
ryegrass1242793ryegrass
satraps95011643satraps
scraps106017243_scraps
seracs84418573se_racs
serais64326133se_rais
serape84818413se_rape
serapes95218103se_rapes
seraph114011163se_raph
seraphs12408093se_raphs
sewans95215903sew_ans
sewars94018633sew_ars
straps87721783_straps
swaps104819203_sw_aps
terais64023513te_rais
teraph11319093te_raph
terras63516973terra_s
tetrads82910193tetrads
tetras63017623tetra_s
traps75727483__traps
twerps11345153twer_ps
unwrap11126323unwrap_
waps96642083__w_aps
warps107126423__warps
whaps135115163__whaps
wrap96821973__wrap_
wrapt105123183__wrapt
zebras1737853zebra_s
zebrass1834113zebrass

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272448.11016526.1
3Display Results2442440.0932623.7
 (SQL Overall)1786912448.60920756.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.