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

472 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
rewears10291103(None) 
redears82814451redears
regears83012461regears
rehears103312771rehears
retears72814921retears
rewear93011991rewear_
beweary1536222beweary
brewers123811052brewe_rs
dewars105117072dew_ars
ewers86018822_ewe_rs
hewers123715272hewe_rs
rears54739652r__ears
rebars84019822re_bars
redear73515172redear_
reearn6612142re_earn
reearns749102re_earns
refers93921082refe_rs
regear73512742regear_
rehear93713222rehear_
reheard11309022reheard
rehearse11296652rehearse
reheats104513522reheats
relearn747972relearn
relearns836302relearns
repeals94014522repeals
repeats94316052repeats
rereads81512292rereads
reseals73917662reseals
reseats74319582reseats
reseaus74012152reseaus
reteams9339562reteams
retear63115482retear_
reveals103812722reveals
revers94529632reve_rs
reward106017632rew_ard
rewards114813992rew_ards
rewarm115913482rew_arm
rewarms12439592rew_arms
reweave1336772reweave
reweaves1436602reweaves
reweds104412302rewe_ds
rewelds11457412rewelds
rewets94617212rewe_ts
rewraps12136562rewraps
rowers94924572rowe_rs
sewars94018622sew_ars
sewers94719712sewe_rs
swears94114072_swears
wears86030302__wears
anears63717183_anears
appears11308953appears
arrears738843arrears
aweary1237303_aweary
bears75739043__bears
beers75628393be_e_rs
beggars11378223beggars
beheads1338523beheads
beleaps1138053beleaps
bemeans1148733bemeans
besmears1234543besmears
beware11313713bew_are
bewares12313373bew_ares
bewearies1447013bewearies
beweeps1494563beweeps
bewraps14135403bewraps
bewrays15145113bewrays
bezoars1836793bezoars
blears85116453_blears
bowers115523703bowe_rs
brewer114812543brewe_r_
brewery15376953brewe_ry
cedars93312833ce_dars
ceders93817673cede_rs
cellars93713693cellars
cereals9313173cereals
chewers154111133chewe_rs
clears84116563_clears
cowers114625533cowe_rs
crewels12438483crewe_ls
crowbars1544423crowbars
crowers124614893crowe_rs
dears65736883__dears
debars94218043de_bars
debeaks1436103debeaks
debeard1137353debeard
debeards1235503debeards
deers64930523de_e_rs
deewans11306903deewans
defeats113511233defeats
defers105116943defe_rs
deleads9379703deleads
demeans1039713demeans
denars74621433de_nars
deodars937623deodars
deters74724683dete_rs
dewans105215143dew_ans
dewar95817733dew_ar_
dewlaps1334663dewlaps
dogears937513dogears
dowers104523293dowe_rs
drawbars1483093drawbars
drawers113610073drawe_rs
drears74614253_drears
ears46356593___ears
egers65120373_ege_rs
eggars8398973_eggars
embars103812883_embars
emeers83314183_emeers
endears83710053endears
escars83913133_escars
eskars10357593_eskars
ewer77523983_ewe_r_
ewes76328703_ewe__s
eyebars1245333_eyebars
eyers86521333_eye_rs
eyewear1342623eyewear_
fears84829393__fears
feuars938653fe_uars
fevers125414893feve_rs
fewer115216123fewe_r_
forebears1446413forebears
foreswears1643223foreswears
forswears1543243forswears
freers94717303fre_e_rs
freeware1446163freeware
freewares1545943freewares
freeways1744723freeways
gears64628693__gears
gewgaws1541643gewgaws
growers113612723growe_rs
hears86737373__hears
heders104119763hede_rs
hewer115719933hewe_r_
hexers165612753hexe_rs
jeers124818133je_e_rs
jewelers1834713jewelers
jewelry2041993jewelry
jewels16508613jewe_ls
jowars16369653jow_ars
kebars124112493ke_bars
krewes1337923krewe__s
lears55938733__lears
leers54828983le_e_rs
leeward1135783leeward
leewards1244983leewards
leeways1354453leeways
legers74518313lege_rs
lekvars1432693lekvars
lepers84817323lepe_rs
levers94621323leve_rs
lowers94624923lowe_rs
medlars10259443medlars
meteors94610013meteors
meters85625833mete_rs
mewlers12288983mewlers
mowers113219403mowe_rs
nears55529423__nears
nectars938463nectars
newels93710823newe_ls
newer85717463newe_r_
outwears1197263outwears
overwears15227873overwears
pawers114818783pawe_rs
pears75138613__pears
pedlars103210213pedlars
peers75130273pe_e_rs
peters86624593pete_rs
pewees11311393pewe_es
pewters124113353pewters
powers113822323powe_rs
preclears1344373preclears
prefers123713333prefe_rs
preheats1339413preheats
prewar114712573prew_ar_
prewarm14479603prew_arm
prewarms15406723prew_arms
prewarn124410143prew_arn
prewarns13456943prew_arns
prewraps15114053prewraps
preyers124412363preye_rs
racers84725433race_rs
radars71314663r_adars
rakers104123573rake_rs
rapers84327183rape_rs
rasers64526783rase_rs
raters63936573rate_rs
ravers94628183rave_rs
rawer84623733rawe_r_
razers154919613raze_rs
readers83823763readers
reads64835273r__eads
realgars934533realgars
reals55038653r__eals
reamers94221083reamers
reams75729623r__eams
reapers93520453reapers
reappears1342853reappears
reaps75626193r__eaps
rear45644553r__ear_
rearers74323563rearers
rearm75923563r__earm
rearms85114653r__earms
reatas64021013reata_s
reavers108320743reavers
rebar75420193re_bar_
rebecks15288013rebecks
rebecs103913673rebe_cs
rebels84518133rebe_ls
reboard10310763reboard
reboards1138773reboards
recaps103615733re_caps
recedes102816063recedes
recepts113010263recepts
recess8314263rece_ss
rechart12314323rechart
recharts1337663recharts
recheats1339193recheats
reclads1049993reclads
recleans1037513recleans
recoals94214623recoals
recoats92616643recoats
rectors93520513rectors
recurs83315803re_curs
redans75421023re_dans
redbays1336013redbays
redcaps1247073redcaps
redders93615343redders
redeems1037163redeems
redes65139123rede__s
redeyes112910973redeyes
redheads1336173redheads
redials84416883redials
redias74523603redia_s
redraws11218473redraws
redreams1195953redreams
redware1139353redware
redwares1239053redwares
reeds65430903re_e_ds
reefers103312593reefers
reefs85121663re_e_fs
reekers113613143reekers
reeks94124033re_e_ks
reelers73520273reelers
reels55333263re_e_ls
rees45364193re_e__s
reests64618893re_ests
reeves94721493re_eves
refects124012743refects
refeeds11368973refeeds
refeels10379693refeels
refels94618053refe_ls
refer84822143refe_r_
reflags1156953reflags
regard85215773re_gard
regards94112563re_gards
regeared1039433regeared
regents83416543regents
reges65628783rege__s
reggaes948883reggaes
regulars936253regulars
rehabs1139023re_habs
rehearsal1242343rehearsal
rehearsed13305913rehearsed
rehearser12265023rehearser
rehearses12286843rehearses
reheat94423943rehea_t
reheaters122010263reheaters
reheels10298253reheels
rehems113410983rehe_ms
reivers105117083reivers
rejects163910693rejects
rekeys13347693reke_ys
relays94316753re_lays
relearnt849213relearnt
release7312763release
releasers937323releasers
releases8313343releases
relends84013253relends
relents74018503relents
relets64025673rele_ts
releves103914973releves
reliers75519213reliers
reloads8911313reloads
reloans7313133reloans
remans84823003re_mans
remaps105012873re_maps
remark123512373re_mark
remarks13329983re_marks
remeets93712413remeets
remelts93511493remelts
remends105013033remends
remoras9314073remoras
renders83821673renders
renegers9248793renegers
reneges82513593reneges
renests74014213renests
renewals1137273renewals
renewers11238183renewers
renews93811753rene_ws
rentals74017473rentals
renters74224813renters
repairs9319973repairs
repark123511713re_park
reparks13249513re_parks
repass84114703re_pass
repays113813973re_pays
repeal84718283repea_l
repealers11278843repealers
repeat85127213repea_t
repeaters112811983repeaters
repegs93311943repe_gs
repels84318763repe_ls
repents93717623repents
reperk122511773repe_rk
reperks13298093reperks
replans92814943replans
replays12399763replays
repleads11357203repleads
repours9310223repours
repowers13288533repowe_rs
reread71715433rerea_d
reredos838633reredos
rerents73319423rerents
rereward1246133rereward
rerewards1344643rerewards
resaws93713513re_saws
resays93714153re_says
reseal64819643resea_l
research1344553research
reseat64131493resea_t
reseau64216213resea_u
reseaux14326233reseaux
resects94115593resects
resedas839123resedas
reseeds84012333reseeds
reseeks11348623reseeks
resees63827483rese_es
resells73313203resells
resends83513713resends
resents74221223resents
resets65427613rese_ts
resews94814173rese_ws
resoaks1148973resoaks
respeaks1434953respeaks
restart7320033restart
restarts8310873restarts
resters74130403resters
retags73414303re_tags
retard75018933re_tard
retards85015003re_tards
reteach1237413reteach
reteam83214533retea_m
retells73211523retells
retems83914573rete_ms
retenes76324623retenes
retests73813853retests
retiary1038333retiary
retreads937823retreads
retreats8311403retreats
reveal94115053revea_l
revealers12318243revealers
revelers113414133revelers
revelry1335693revelry
revels94220573reve_ls
reverb113912573reve_rb
reverbs12368863reverbs
revere94621253reve_re
reverers113113153reverers
reveres103621343reveres
reverse103913743reve_rse
reverso10367693reve_rso
revert93529113reve_rt
reverts104715043reverts
revery124014213reve_ry
revests104413733revests
revets94022173reve_ts
rewake135218463rew_ake
rewakes144614983rewakes
rewan85623663rew_a_n
rewash1237673rew_ash
rewax155713923rew_a_x
rewaxes173911333rewaxes
rewearing132310703rewearing
reweaved1535953reweaved
rewed95425453rewe__d
reweigh1464773reweigh
reweighs1583203reweighs
reweld103711113rewe_ld
rewet85135153rewe__t
rewinds114810483rewinds
rewins95020823rew_ins
rewire95421403rew_ire
rewires104717113rewires
reword106321403rew_ord
rewords115413973rewords
rewore938030153rew_ore
rework136619783rew_ork
reworks145113593reworks
reworn98122193rew_orn
rewrap11127533rewra_p
rewrapt12138113rewrapt
rexes124526953rexe__s
reynard1135123reynard
reynards1244303reynards
rezero1578873reze_ro
rezeros1647453rezeros
rheas84816953r_hea_s
ricers84120993rice_rs
riders74123903ride_rs
rievers104311453rieve_rs
rimers84522553rime_rs
risers64624783rise_rs
rivers94626543rive_rs
roars55622233r__oars
rogers74517913roge_rs
ropers84325903rope_rs
rovers95423523rove_rs
rowans95715343row_ans
rowels94515453rowe_ls
rowens94515303rowe_ns
rower85430493rowe_r_
ruers515019413r_ue_rs
rulers64317093rule_rs
sawers94620163sawe_rs
screwers13358053screwe_rs
sears54744913__sears
secpars1138413secpars
seders74420283sede_rs
seers55136383se_e_rs
seggars9377783seggars
severs94121123seve_rs
sewans95215903sew_ans
sewar85421093sew_ar_
sewer84426213sewe_r_
shears93820903_shears
shewers134312043shewe_rs
shmears1277073shmears
skewers14498373skewe_rs
smears84714433_smears
sowars94318003sow_ars
sowcars1236003sowcars
sowers94923433sowe_rs
spears84019473_spears
spewers124210653spewe_rs
strewers11409053strewe_rs
swear85316853_swear_
sweats94814613_sweats
tawers94118603tawe_rs
tears55436463__tears
towers94423673towe_rs
tweaks1335963_tweaks
unbears998043unbears
unswears1144023unswears
unweary1335843unweary
upbears1195423upbears
uprears9107493uprears
uptears9106443uptears
ureters7311823urete_rs
veers84521363ve_e_rs
velars93913723ve_lars
veneers103710293veneers
vexers165210403vexe_rs
viewers1337173viewe_rs
vowers124317183vowe_rs
wars78659803__w_ars
weals85428743__weals
weans85326743__weans
wear75836723__wear_
weary115620613__weary
webers11310943webe_rs
weirs84316493__weirs
years84527673__years

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.1561145455.1
2DLD Change Limit1340274727.53017799.1
3Display Results4724720.1732728.3
 (SQL Overall)1786914727.85922737.1
 
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.