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

93 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
mysteries14121119(None) 
masteries111018491masteries
hysterias1547142hysterias
hysterics1746052hysterics
miseries10320402mis_eries
mysterious1543902mysterious
mystifies1745882mystifies
wasteries121115342wasteries
absterges1244763absterges
arteries8321463_arteries
asterias8317003_asterias
batteries11615113batteries
booteries11312773booteries
butteries11711763butteries
catteries11815513catteries
cauteries11615363cauteries
coteries10422703_coteries
cycleries1647033cycleries
cysteines1445133cysteines
cysteins1355733cyste_ins
dysenteries1554273dysenteries
easterlies1046713easterlies
eateries8324303_eateries
fisheries1548643fisheries
histories12412473histories
hosieries1249213hosieries
hostelries1345423hostelries
hystereses1643803hystereses
hysteria1447383hysteri_a
hysteric1647533hysteri_c
listerias959213listerias
lotteries9311073lotteries
martyries1446563martyries
masonries1146853masonries
mastered112614003master_ed
mastering122315303mastering
masters94628923master__s
materiel10311253m_ateriel
materiels1147823m_ateriels
merceries13410033merceries
mesenteries1345893mesenteries
mesmerise1345843mesmerise
mesmerises1445823mesmerises
mesmerizes2345993mesmerizes
mestees94617753meste__es
mestesoes1145323mestesoes
midstories1345653midstories
misrelies1149723misrelies
mistermed1438363mistermed
misterms123711333mister_ms
misters93927503mister__s
mockeries17128253mockeries
monasteries1345923monasteries
monkeries15129913monkeries
moperies12313873m_operies
mummeries1247243mummeries
musketries1643303musketries
mustees94614923muste__es
mustelids1243583mustelids
mustered112511503muster_ed
mustering122212333mustering
musters94522493muster__s
mystery15436523myster__y
mystics14279103myst__ics
mystified1845083mystified
mystifier1744363mystifier
mystifiers1843103mystifiers
mystiques2342423mystiques
niteries8318373_niteries
oystered1236913oyster_ed
oysterer1136103oyster_er
oysterers1245573oysterers
oystering1337553oystering
oysterings1443883oysterings
oystermen1443743oystermen
oysters103411683oyster__s
pastries101517423past_ries
potteries11313593potteries
roseries8317313ros_eries
series64540973__s_eries
sesterces1147863sesterces
smelteries1246163smelteries
steres63929533__ster_es
stories7324273__stories
systemics1644273systemics
systemizes2444623systemizes
tusheries1246893tusheries
vestries11314043vest_ries
wasterie111211583wasterie_
wastries111212883wast_ries
westerlies1345603westerlies
wisterias1248083wisterias
xysters17307163xyster__s

Search took 7 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.1731032896.0
2DLD Change Limit148641936.48322927.8
3Display Results93930.0462021.7
 (SQL Overall)178691936.70226662.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.