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

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

90 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
spiceries134931(None) 
pineries102419082_pineries
sorceries1149932sorceries
spicers113815552spicer__s
spiderier1244652spiderier
spideriest1345282spideriest
spinneries1245732spinneries
aperies9423203ap__eries
apiaries10312723api_aries
boiseries11411043boiseries
briberies1348333briberies
chicories1688763chicories
cicelies1269753_cicelies
epicenes1249253epice_nes
epicures1246513epicur_es
epimeres12117653epimer_es
fineries112416743_fineries
groceries1249503groceries
joineries1648103joineries
liveries11314373_liveries
merceries13410043merceries
miseries10320403_miseries
niceties10310863_niceties
niteries8318383_niteries
peeries93623023_p_eeries
picrites121811083_pic_rites
pierces113411193_pi_erces
pieties9419223_pi_eties
piggeries13107893_piggeries
piperines131610693_piperines
piscaries13410073_piscaries
poperies12316793_poperies
sceneries1149393sceneries
scries85226823s__c_ries
sealeries9313133sealeries
series64540973s___eries
shinneries1345713shinneries
sickies133717503s_ic_kies
sicklies14710013s_icklies
siderites10410433s_iderites
slaveries1249683slaveries
slicers94114923slicer__s
smitheries1546053smitheries
societies1148803societies
spacers113813873spacer__s
spareribs1353283spareribs
species11314133sp__ecies
specifies1647573specifies
spectres12268683spectr_es
spheres123114353sp_her_es
spherics1537073sp_herics
spherier1337783sp_herier
spheriest1438373sp_heriest
spiceless1335923spiceless
spicer104719313spicer___
spicery14499013spicer__y
spices104326033spic___es
spicier115112463spic__ier
spiciest122711603spic__iest
spicules12219803spic_ules
spiderish1544493spiderish
spiders103914413spider__s
spiderweb1751253spiderweb
spiderwebs185973spiderwebs
spiered104412463spi_er_ed
spiering112713353spi_ering
spiers84421743spi_er__s
spiffies16277993spi_ffies
spikers135311993spiker__s
spinelles1146083spinelles
spinnies103210543spi_nnies
spiremes12397623spire_mes
spires84628113spi__r_es
spirier93214073spi__rier
spiriest102513453spi__riest
spirits94112623spi__rits
spitfires1442903spitfires
splicers12338113splicer__s
spooferies1543703spooferies
spookeries1654293spookeries
spurries102311323sp_urries
stickies142211973stic_kies
stitcheries1653073stitcheries
subseries11312933subseries
succories1347183succories
surgeries10311363surgeries
traceries11312863traceries
trickeries1647143trickeries
vineries112716043_vineries
wineries112316533_wineries

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit148641907.01621186.0
3Display Results90900.0303000.0
 (SQL Overall)178691907.48223882.8
 
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.