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

263 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
rewrap1112753(None) 
bewrap13157051bewrap
prewrap14104971prewrap
rewraps12136561rewraps
rewrapt12138111rewrapt
bewraps14135402bewraps
bewrapt14147132bewrapt
bewray14147732bewray
dewlap1264842dewlap
enwrap1185212enwrap
inwrap11115902inwrap
prewraps15114052prewraps
reap65934742re__ap
recap95718022re_cap
redcap1158492redcap
redraw10269852redraw
remap95418102re_map
reran57329102re_ran
retral64419742retral
rewan85623662rew_an
reward106017632reward
rewarm115913482rewarm
rewax155713922rew_ax
rewear93011992rewear
riprap1055512riprap
unwrap11126322unwrap
wrap96821972__wrap
becap114315053be_cap
bedrape1277693bedrape
beleap10410283beleap
betray111511443betray
beware11313713beware
beweep13147253beweep
bewrays15145113bewrays
crap85731843__crap
crewman1435743crewman
defrag1136463defrag
defray1337643defray
derat65044083de_rat
deray95024183de_ray
dewan95718043dew_an
dewar95817733dew_ar
dewars105117073dewars
dewax165510853dew_ax
dewdrop1442813dewdrop
dewlaps1334663dewlaps
earlap837183_earlap
enrapt8313013_enrapt
entrap8710563entrap
enwraps1284833enwraps
era35741503_e_ra_
eras45441503_e_ras
eyra76217553_eyra_
eyras84715923_eyras
feral85424653fe_ral
firetrap1344863firetrap
frap95925813__frap
gelcap1136213gelcap
gerah9315303ge_rah
gewgaw1441783gewgaw
heap96432893he__ap
inwraps12105253inwraps
leap66032683le__ap
neap66927013ne__ap
neural6311993neural
perp89029893pe_r_p
petnap1037423petnap
preoral9312673preoral
prewar114712573prew_ar
prewarm14479603prewarm
prewarn124410143prewarn
rap56261963___rap
rattrap945263rattrap
read55942533re__ad
readapt1039743readapt
real45750293re__al
ream65841613re__am
reaps75626193re__aps
rear45644553re__ar
reared75930013reared
rearer64928913rearer
rearm75923563rear_m
rearms85114653rearms
rears54739653rear_s
reata54225393reata_
reatas64021013reatas
rebar75420193re_bar
rebars84019823rebars
rebop9313283re_bop
rebred95816353rebred
recaps103615733re_caps
reclad9311873reclad
reclasp1136643reclasp
recoal84117973recoal
recoat84024273recoat
recoup10810373recoup
recrate92621643recrate
recta74220263recta_
rectal84418133rectal
redan66125013re_dan
redbay1238333redbay
redcaps1247073redcaps
redear73515173redear
redia65524483redia_
rediae74221993rediae
redial74923113redial
redias74523603redias
redip87816963re_dip
redraft11310573redraft
redrawn11245953redrawn
redraws11218473redraws
redream10107913redream
redrew10309503redrew
redry94314363redr_y
redtop937973redtop
redware1139353redware
reearn6612143reearn
reflag1098083reflag
refract121311603refract
refrain10310043refrain
reframe1239393reframe
refry114412463refr_y
regal65023793re_gal
regard85215773regard
regear73512743regear
reggae858953reggae
regma84612333regma_
regna64614813regna_
regnal74812933regnal
regrade92612033regrade
regraft11310153regraft
regrant8317323regrant
regrate82618653regrate
regret73723533regret
regrew10388563regrew
regroup1095173regroup
regrow10309883regrow
rehab10312443re_hab
rehear93713223rehear
reheat94423943reheat
relax124817803re_lax
relay84424673re_lay
reload7413893reload
reloan6415693reloan
reman75730153re_man
remaps105012873re_maps
remark123512373remark
remora8414583remora_
remoras9314073remoras
renal55929503re_nal
rental63922023rental
rep55847803re___p
repark123511713repark
repay104818453re_pay
repeal84718283repeal
repeat85127213repeat
replan83215823replan
replay113412923replay
repp85418743re__pp
repro75315913repr_o
repros84216003repros
repump1235683repump
rerack122513163re_rack
reread71715433reread
rerig64018483re_rig
rerun58722153re_run
resat55139683re_sat
resaw84117253re_saw
resay85320543re_say
reseal64819643reseal
reseat64131493reseat
reseau64216213reseau
reshape1249043reshape
reship11310673reship
resoak10311093resoak
respray1236503respray
restamp1146483restamp
retag63618413re_tag
retape83917683re_tape
retard75018933retard
retax124517973re_tax
reteam83214533reteam
retear63115483retear
retia55326113retia_
retial64724993retial
retrace91417343retrace
retrack131310723retrack
retract91318113retract
retrain7615423retrain
retread849003retread
retreat7317533retreat
retrial7615553retrial
retrim83514873retrim
retro55020953retr_o
retros63820193retros
retry84718083retr_y
revamp1336013revamp
reveal94115053reveal
rewake135218463rewake
rewards114813993rewards
rewarms12439593rewarms
rewash1237673rewash
rewears102911033rewears
reweave1336773reweave
rewed95425453rew_ed
reweds104412303reweds
reweld103711113reweld
rewet85135153rew_et
rewets94617213rewets
rewin85623963rew_in
rewind104715883rewind
rewins95020823rewins
rewire95421403rewire
rewired115413283rewired
rewires104717113rewires
rewoke1339521213rewoke
rewon86920573rew_on
reword106321403reword
rewords115413973rewords
rewore938030153rewore
rework136619783rework
reworks145113593reworks
reworn98122193reworn
rewove126420073rewove
rewrapped1763023rewrapped
rewrite10311143rewrite
rewrote1039113rewrote
ricrac1037013ricrac
ripraps1134943ripraps
rowan85418733row_an
rural55821173r_ural
satrap86212553satrap
scrap97120403_scrap
sera46141393se_ra_
serac75925203se_rac
serai56830163se_rai
seral56336383se_ral
serape84818413se_rape
seraph114011163se_raph
sewan85921293sew_an
sewar85421093sew_ar
sewars94018623sewars
strap77925263_strap
swap95925433_sw_ap
terai53525483te_rai
teraph11319093te_raph
terra54419653terra_
terrae62915203terrae
terras63516953terras
tetra53417953tetra_
tetrad73612053tetrad
tetras63017613tetras
trap67532803__trap
twerp10398413twer_p
unwraps1255513unwraps
vera76828843ve_ra_
wap86553373__w_ap
warp95635003__warp
whap125119643__whap
wraps105617153__wraps
wrapt105123183__wrapt
zebra1637883zebra_
zebras1737853zebras

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162635.26621404.5
3Display Results2632630.0932828.0
 (SQL Overall)1786912635.49932495.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.