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

167 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
resees6382748(None) 
resee54336331resee_
reseed74823291reseed
reseeds84012331reseeds
reseek103813131reseek
reseeks11348621reseeks
reseen64318411reseen
resets65427611resets
resews94814171resews
reshes94124361reshes
beseem1069082beseem
beseems1175912beseems
beses75830722bes_es
besets85718802besets
cesses84221362cesses
creeses93914622creeses
cresses94219812cresses
desexes1537832desexes
dresses83716172dresses
epees75219832_epees
erses55826802ers_es
eses45336102_es_es
esnes54817362_esnes
esses56422972_esses
fesses94820252fesses
foresees11311642foresees
freshes133515822freshes
frisees104411692frisees
fusees95416402fusees
gelees74116262gelees
gestes75721392gestes
jesses135215952jesses
leses54930812les_es
lessees73510242lessees
levees93714522levees
melees83618082melees
meseems1165602meseems
meshes115019442meshes
mesnes85216212mesnes
messes84924342messes
mestees94617752mestees
nesses64718322nesses
pensees9311202pensees
pewees11311392pewees
presets94216422presets
presses93523152presses
ragees74618662ragees
rakees104516972rakees
ramees84620892ramees
ranees64623962ranees
rasers64526782rasers
rases55447212ras_es
rashes95330152rashes
razees154314762razees
reales64934122reales
reaves94127572reaves
rebbes10313532rebbes
rebecs103913672rebecs
rebels84518132rebels
recces10614912recces
recedes102816062recedes
recess8314262recess
redeem9311532redeem
redeems1037162redeems
redes65139132re_des
redeyes112910972redeyes
redoes74623772redoes
redyes104214092redyes
reeds65430902re_eds
reefs85121662re_efs
reeks94124032re_eks
reels55333262re_els
rees45364192r__ees
reests64618892reests
reeves94721492reeves
refeed104717622refeed
refeeds11368972refeeds
refeel93913242refeel
refeels10379692refeels
refels94618052refels
refers93921082refers
reges65628792re_ges
reheel93610822reheel
reheels10298252reheels
rehems113410982rehems
reives95723042reives
rekeys13347692rekeys
relets64025672relets
releves103914972releves
relies65036422relies
remeet86325472remeet
remeets93712412remeets
reneges82513592reneges
renews93811752renews
rentes65431192rentes
repegs93311942repegs
repels84318762repels
resales74724902resales
resaws93713512resaws
resays93714152resays
rescues9312752rescues
reseal64819642reseal
reseals73917672reseals
reseat64131492reseat
reseats74319582reseats
reseau64216212reseau
reseaus74012152reseaus
resect84424702resect
resects94115592resects
reseda739702reseda
resedas839122resedas
reseizes1759852reseizes
resell64215202resell
resells73313202resells
resend75016772resend
resends83513712resends
resent63833622resent
resents74221222resents
reserves111011982reserves
reset55051862res_et
resew84519502res_ew
resewed113011822resewed
resewn9459812resewn
reshoes102316032reshoes
resides84523282resides
resids74219152resids
resiles74026542resiles
resins64528772resins
resites74027792resites
resits64725562resits
resizes164216842resizes
resods74116302resods
resoles73823652resoles
resows93915352resows
rested74430782rested
rester63832432rester
resters74130402resters
rests54935872res_ts
resumes9313372resumes
retems83914572retems
retenes76324622retenes
reties65436192reties
reuses66025522reuses
revels94220572revels
reveres103621342reveres
revers94529632revers
revets94022172revets
revues9813902revues
reweds104412302reweds
rewets94617212rewets
rexes124526952re_xes
risers64624782risers
rises55244042ris_es
roses56445772ros_es
rosets65819952rosets
rupees8312572rupees
ruses56136582rus_es
rushees103311952rushees
rushes94724362rushes
sees45361052__sees
tepees84215242tepees
testees74215912testees
testes65125822testes
tresses73719542tresses
vestees103513172vestees
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.346516448.0
2DLD Change Limit825511672.29635954.3
3Display Results1671670.0463630.4
 (SQL Overall)1786911672.68866477.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.