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 “reap” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

289 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
reap6593474(None) 
heap96432891heap
leap66032681leap
neap66927011neap
rap56261961r_ap
read55942531read
real45750291real
ream65841611ream
reaps75626191reaps
rear45644551rear
recap95718021recap
remap95418101remap
rep55847801re_p
repp85418741repp
area45843392area_
areae55229742areae
areal55928732areal
areas55935772areas
arepa75615562arepa
atap66722452atap
bap76455842_bap
bead75937922bead
beak106534382beak
beam86939232beam
bean66443862bean
bear66844642bear
beat66168302beat
beau66137272beau
becap114315052becap
beep85931212beep
bread85523112bread
break115319402break
bream95121812bream
cap76758982_cap
cep75736332ce_p
chap114928492chap
cheap126915942cheap
clap86429042clap
crap85731842crap
creak115418432creak
cream95721342cream
creep95218102creep
dap66652452_dap
dead65434242dead
deaf85838402deaf
deal56347412deal
dean56039482dean
dear55343602dear
deep76031882deep
dread74419022dread
dream85120392dream
drear65016902drear
ear36867882_ear
eat36989052_eat
eau37450942_eau
era35741502era_
eras45441502eras
feal713940422feal
fear75337792fear
feat76458222feat
flap96128702flap
frap95925812frap
freak125115242freak
gap67055612_gap
gear55934972gear
great66034242great
hap87360052_hap
head87137172head
heal75645692heal
heaps105223222heaps
heapy135914982heapy
hear76143882hear
heat77061422heat
help95328922help
hemp115725622hemp
hep86644142he_p
jean116629282jean
jeep135624842jeep
kea76540912kea_
keas86337092keas
keep106329812keep
kelp105322802kelp
kemp126418762kemp
kep96437202ke_p
knap105815402knap
kreep114610412kreep
lap58565272_lap
lea37660182lea_
lead56038852lead
leaf76441032leaf
leak86233712leak
leal46043272leal
lean46345242lean
leaps75522932leaps
leapt75027472leapt
lear47045952lear
leas45954182leas
map77255122_map
mead75531602mead
meal65643172meal
mean65538092mean
meat66359602meat
nap56753202_nap
neaps75618322neaps
near45236502near
neat46356782neat
neep65728312neep
oread64619602oread
pap76758402_pap
pea56657242pea_
peag75431342peag
peak106535202peak
peal68648102peal
pean66147172pean
pear69745232pear
peas65755062peas
peat65967932peat
peep85833692peep
pep76447082pe_p
perp89029892perp
preamp1238992preamp
preop94715872preop
prep86427672pre_p
rad47662002r_ad
rag45761322r_ag
rah68052402r_ah
rai37658222r_ai
raj105740222r_aj
ram56867272r_am
ramp85934002ramp
ran38266622r_an
rape65041632r_ape
raps66247732r_aps
rapt67245312r_apt
ras37575392r_as
rasp66029162rasp
rat37892742r_at
raw67252252r_aw
rax108445722r_ax
ray66361992r_ay
re26153742re__
reach105123882reach
react74634332react
readd74617132readd
reads64835272reads
ready94821502ready
realm75621622realm
reals55038652reals
reams75729622reams
reaped94122452reaped
reaper84223142reaper
rearm75923562rearm
rears54739652rears
reata54225392reata
reave84528022reave
reb55844962re_b
rebar75420192rebar
rebop9313282rebop
rebs65733562rebs
rec55645462re_c
recaps103615732recaps
reck106130562reck
recs65734182recs
red46755802re_d
redan66125012redan
redcap1158492redcap
redd66323172redd
rede55037662rede
redip87816962redip
redo56029362redo
reds56042862reds
ree37974072re_e
reed55549622reed
reef74938212reef
reek85232522reek
reel45240532reel
rees45364192rees
ref66053292re_f
refs75732242refs
reft75141272reft
reg46146492re_g
regal65023792regal
regs55436572regs
rehab10312442rehab
rei35647252re_i
reif76937652reif
rein46040892rein
reis45343232reis
relax124817802relax
relay84424672relay
rely75428952rely
rem56150042re_m
reman75730152reman
remaps105012872remaps
rems66237722rems
renal55929502renal
rend56136572rend
rent46661242rent
repay104818452repay
repo66027542repo
repps95114342repps
reps65937952reps
reran57329102reran
res35565042re_s
resat55139682resat
resaw84117252resaw
resay85320542resay
resh76523452resh
rest46459842rest
ret35982832re_t
retag63618412retag
retape83917682retape
retax124517972retax
rete44944132rete
rets45352562rets
rev65336622re_v
revamp1336012revamp
revs75027052revs
rewan85623662rewan
rewax155713922rewax
rewrap11127532rewrap
rex105740992re_x
rhea75017432rhea_
rheas84816952rheas
ria36745502ria_
rial45938092rial
rias45540592rias
rip56851302r_ip
road56332112road
roam67132412roam
roan47234202roan
roar46328572roar
romp85926572romp
roup66627692roup
rump86729082rump
rya67622012rya_
ryas77224612ryas
sap56463232_sap
sea36161292sea_
seal45654372seal
seam66645972seam
sear47353842sear
seas45755272seas
seat47575562seat
seep66540342seep
slap66434042slap
snap65727032snap
sneap75514822sneap
soap65831132soap
swap95925432swap
tap57663872_tap
tea37353322tea_
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teat45963632teat
temp85323332temp
tepa66021682tepa
threap11569662threap
trap67532802trap
tread64821702tread
treat56240352treat
urea46528052urea_
ureal56722682ureal
ureas55826012ureas
veal76936812veal
veep95325092veep
wap86553372_wap
weak117126302weak
weal75838682weal
wean75734352wean
wear75836722wear
weep95131652weep
whap125119642whap
wrap96821972wrap
wreak125513272wreak
yap85949822_yap
yea66445752yea_
yeah106725412yeah
yean75834582yean
year76534252year
yeas78638422yeas
yelp95621352yelp
yep86638962ye_p
zap145840692_zap
zeal135530332zeal
zep147129142ze_p

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298722890.93631914.5
3Display Results2892890.0634587.3
 (SQL Overall)1786912891.075166224.2
 
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.