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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
scenes8452035(None) 
scenas84114701scenas
scends95213001scends
scene77220571scene_
scents85317021scents
scones84521301scones
skenes104616631skenes
achenes12313492achenes
acnes75922622ac_nes
agenes74720252agenes
akenes104817342akenes
arenes64928392arenes
ascends10388202ascends
ascents93812552ascents
asceses938622asceses
benes75536232_benes
canes75350372_canes
cedes84927332_cedes
cees65941592_ce_es
cense75121402_cense
censes83721802_censes
cents74730332_cents
cepes94424462_cepes
ceres75540012_ceres
cetes75731102_cetes
cines75239682_cines
cones76457422_cones
denes65639722_denes
dienes75719902dienes
genes65133092_genes
icones84616382icones
lenes54738522_lenes
nenes55329672_nenes
oscines9310362oscines
penes75839222_penes
sanes55649072s_anes
scales84529312scales
scans74625102scan_s
scants85219722scants
scapes105122262scapes
scares85033002scares
scena74815782scen_a
scend85516292scen_d
scended11329872scended
scenery1236562scenery
scenic10510512scenic
scenics1137772scenics
scent75831622scen_t
scented102811892scented
schemes1489662schemes
sciences1238782sciences
sconces113811452sconces
scone74621832scone_
scopes104719592scopes
scores84725922scores
screens95212182screens
screes85023972screes
scries85226822scries
scutes85219192scutes
secedes103711982secedes
sees45361052s_e_es
seines65029902seines
semes75731582s_emes
sends65528242s_ends
sene46848052s_ene_
sense55526822s_ense
senses63923942s_enses
serenes73222902serenes
seres55448892s_eres
sexes126126222s_exes
sheens95116992sheens
shends105313772shends
shines95028912shines
sieges73816832sieges
sieves93216002sieves
sines55954822s_ines
skeanes113610712skeanes
skeens103912912skeens
skees95023122ske_es
skene96118122skene_
sones55444142s_ones
spences113413922spences
spends94714472spends
spense83912432spense
spenses92913572spenses
sphenes123013162sphenes
spines85132032spines
stanes64933402stanes
steles63725662steles
stenos63915772stenos
stents65019452stents
steres63929532steres
stones65130032stones
suedes73918112suedes
swedes102711892swedes
sycees11409652syce_es

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.360496363.9
2DLD Change Limit82551962.26636430.3
3Display Results96960.0303200.0
 (SQL Overall)178691962.65667278.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.