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

55 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
stygian114408(None) 
ataghan1144653ataghan
elysian1065083elysian
etesian757853etesian
isthmian1343073isthmian
magian9312833_magian
salpian938493salpian
saurian739913saurian
simian8811163s_imian
skyman1535313sky_man
slogan7539223slog_an
soybean1243953soybean
stadia7312143stadia_
stadias8411113stadias
stagier83513443stagier
stagily1139053stagily
staging93818373staging
stagnant946893stagnant
stain55727943st_ai_n
stamina9310793stamina
statin63921473stati_n
station72717243station
stein54620543st_ei_n
stewpan1234193stewpan
stibial946583stibial
stigma9226763stigma_
stigmal10245923stigmal
stigmas10206643stigmas
stogie7311323stogi_e
stogies8413693stogies
stotin63215063stoti_n
strain64919573strai_n
stria55723213st_ria_
striae65422273st_riae
stying105414573sty_ing
stylar9358113sty_lar
styli83911173styli__
styling112910653styling
stylise10208953stylise
stylish13197443stylish
stylist102110283stylist
stylite10219613stylite
stylize19177453stylize
stymie1137623stymi_e
stymied1335663stymied
stymies1239213stymies
styrax1675243sty_rax
swagman1334913swagman
sylvan12257363s_ylvan
syzygial2451433syzygial
titian62512663_titian
tyin76424003_ty_i_n
tyiyn11635333_ty_iyn
tympan13257013_tympan
utopian9126273utopian

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 Filter1786911340270.390458182.1
2DLD Change Limit134027556.03322215.6
3Display Results55550.0301833.3
 (SQL Overall)178691556.45327691.2
 
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.