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

215 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
press7542595(None) 
cress75022831cress
dress65319831dress
prees75937171prees
preps96220691preps
presa74319041presa
prese75228381prese
prest75736351prest
prests84021261prests
preys105717781preys
priss74623891priss
pross76529401pross
tress55423161tress
apres75426402apre_s
areas55935772areas
ares45871022are_s
arses55733872arses
bless75917812bless
brass75428022brass
brees75632552brees
brens75823362brens
brews105617072brews
briss75824272briss
caress85720262caress
cess65326052_cess
chess105016922chess
crass76328042crass
creds85418772creds
cressy11439112cressy
crest74632692crest
crests85218702crests
crews105917492crews
cross75124502cross
cypress1434652cypress
depress10239872depress
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dressy10518142dressy
drest65530342drest
dross65418092dross
duress74712062duress
egress73310432egress
empress1138162empress
erses55826802erses
ess36030882__ess
express1637492express
fess76529162_fess
frass85321122frass
frees86131392frees
fresh115012202fresh
frets85523402frets
grass66125202grass
grees65132472grees
greys96614852greys
gross65421692gross
guess64213362guess
impress1137772impress
ires45639282ire_s
jess116022032_jess
less45635102_less
loess55714702loess
mess65932432_mess
ness45526562_ness
ogress7529502ogress
oppress1135992oppress
ores46056682ore_s
pareos87023772pareos
parers85530742parers
pares77164482pare_s
pareses94718882pareses
paresis93315092paresis
pareus85420742pareus
parses85534702parses
pases75346502pases
pass65239952p_ass
peas65755062p_eas
pecs84634102p_ecs
peds75835242p_eds
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peeress939502peeress
peers75130272peers
pees65257372p_ees
pegs75531762p_egs
pehs95625762p_ehs
pens65649642p_ens
peps85134512p_eps
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
perse75429522perse
perses85428062perses
pervs105117372pervs
pes57259782p_e_s
peso66925822p_eso
pesos77221622p_esos
pest65555292p_est
pests75933272p_ests
pets66248332p_ets
pews95731532p_ews
piers75926332piers
pies66949602pie_s
piss65033332p_iss
pleas75627032pleas
plebs95814582plebs
plews105415352plews
poems95715552poems
poesy105014062poesy
poets76024442poets
pores75849032pore_s
poses74642762poses
prams96125512prams
praos74923562praos
prase76128752prase
prases84429022prases
prats76333392prats
praus74621752praus
prays105022432prays
precess11310862precess
precis103416702precis
pree67044732pre_e
preed85128112preed
preen75925052preen
preens85020112preens
premiss113513812premiss
preop94715872preop
preops104911942preops
prep86427672pre_p
preset84430982preset
presets94216422presets
pressed103317312pressed
presser93717622presser
presses93523152presses
pressor93512872pressor
presto84216202presto
prestos93716082prestos
prex135722972pre_x
prexes154915942prexes
prexy174611572prexy
prey96228482pre_y
prez156126312pre_z
prezes173614692prezes
priers84521192priers
pries74339532pries
priest84125422priest
priests93810862priests
prigs85219702prigs
prims95425932prims
prise74632612prise
prises84133172prises
prism94820262prism
prisms104915502prisms
prissy11347852prissy
proas75028802proas
process11310402process
prods85523552prods
proems104711162proems
profess1237712profess
profs105120892profs
progs86624152progs
proms95426412proms
props95726882props
pros65742782pr_os
prose75835122prose
proses84733472proses
proso77222412proso
prosos85718552prosos
prost75434102prost
prosy106319252prosy
prowess1237902prowess
prows106327012prows
pryers115012242pryers
purees84721682purees
purest84021932purest
purses84826372purses
puses75532202puses
puss64830132p_uss
pyes95528992pye_s
pyres105523882pyre_s
rebs65733562_rebs
recs65734182_recs
reds56042862_reds
rees45364192_rees
refs75732242_refs
regs55436572_regs
reis45343232_reis
rems66237722_rems
repress92712682repress
reps65937952_reps
res35565042_re_s
resh76523452_resh
rest46459842_rest
rests54935872_rests
rets45352562_rets
revs75027052_revs
sprees85620642sprees
stress66616672stress
trass56226472trass
trees55835762trees
treks96016852treks
tres46542902tre_s
tressy9448552tressy
trets55928022trets
trews86118892trews
treys85018212treys
truss54916922truss
ureas55826012ureas
wrens85016242wrens
wrest84925432wrest
wrests95313082wrests

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 Filter178691538000.0901985455.6
2DLD Change Limit538002151.59633709.3
3Display Results2152150.0464673.9
 (SQL Overall)1786912151.732103170.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.