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

165 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
reshes9412436(None) 
freshes133515821freshes
meshes115019441meshes
rashes95330151rashes
resees63827481resees
reshoes102316031reshoes
rushes94724361rushes
ashes86230612_ashes
bashes115631392bashes
beses75830722bes_es
boshes114721882boshes
brashes124518462brashes
brushes124014662brushes
bushes115226112bushes
cashes114729882cashes
cesses84221362cesses
coshes115022782coshes
crashes124618402crashes
creches14313092creches
creeshes1336952creeshes
cresses94219812cresses
crushes124215132crushes
dashes106124982dashes
deashes113313902deashes
dishes104622652dishes
dresses83716172dresses
eches106322162_eches
erses55826802ers_es
eses45336102_es_es
esnes54817362_esnes
esses56422972_esses
fashes124524022fashes
fesses94820252fesses
fishes125221342fishes
fleshes133913272fleshes
freshed143312592freshed
freshen133010882freshen
freshens14298312freshens
fresher132612642fresher
freshest143010582freshest
freshet133416642freshet
freshets14298672freshets
gashes105725152gashes
gestes75721392gestes
gushes104719032gushes
hashes125024802hashes
hushes124718592hushes
jesses135215952jesses
joshes165114852joshes
lashes94831002lashes
leashes103514402leashes
leches115421312leches
leses54930812les_es
lethes94818082lethes
lushes94022742lushes
mashes115030002mashes
menshes12310452menshes
meshed124415932meshed
mesnes85216212mesnes
messes84924342messes
moshes115222872moshes
mushes114124562mushes
nesses64718322nesses
noshes96618232noshes
pashes115828392pashes
pishes114722102pishes
presses93523152presses
pushes114621662pushes
raphes115117452raphes
rases55447212ras_es
rasher95024122rasher
rashers104020912rashers
rashest103916872rashest
reaches123423202reaches
reales64934122reales
reaves94127572reaves
rebbes10313532rebbes
recces10614912recces
rechew14310212rechew
rechews1537292rechews
redes65139132re_des
redoes74623772redoes
redyes104214092redyes
rees45364192re__es
reeves94721492reeves
reges65628792re_ges
rehashes1436952rehashes
rehem103815352re_hem
rehems113410982re_hems
reives95723042reives
relies65036422relies
relishes11311952relishes
rentes65431192rentes
resales74724902resales
resaws93713512resaws
resays93714152resays
rescues9312752rescues
resee54336332res_ee
reseed74823292reseed
reseeds84012332reseeds
reseek103813132reseek
reseeks11348622reseeks
reseen64318412reseen
reset55051862res_et
resets65427612resets
resew84519502res_ew
resews94814172resews
resh76523452resh__
reshapes1338802reshapes
reshaves1438732reshaves
reshines112615442reshines
reship11310672reship
reships1239862reships
reshod103012232reshod
reshoe92816482reshoe
reshoed112212152reshoed
reshot93519632reshot
reshow123111432reshow
reshows132510452reshows
resides84523282resides
resids74219152resids
resiles74026542resiles
resins64528772resins
resites74027792resites
resits64725562resits
resizes164216842resizes
resods74116302resods
resoles73823652resoles
resows93915352resows
rested74430782rested
rester63832432rester
resters74130402resters
rests54935872res_ts
resumes9313372resumes
retches123318512retches
reties65436192reties
reuses66025522reuses
revues9813902revues
rewashes1447032rewashes
rexes124526952re_xes
riches115022082riches
rises55244042ris_es
rishis9312452rishis
roses56445772ros_es
roshis9311792roshis
ruches114819582ruches
ruses56136582rus_es
rushed104419862rushed
rushee93818772rushee
rushees103311952rushees
rusher94019652rusher
rushers103816102rushers
sashes94728482sashes
shes75734352__shes
testes65125822testes
threshes1437382threshes
toshes94520102toshes
trashes104119262trashes
tresses73719542tresses
tushes94319472tushes
washes124425492washes
welshes13379092welshes
wishes124920952wishes
yeses85119322yes_es
yesses93615812yesses

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511652.53032628.9
3Display Results1651650.0463587.0
 (SQL Overall)1786911652.91961216.5
 
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.