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

84 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
stigmal1024592(None) 
stigma9226761stigma_
stigmas10206641stigmas
seismal937302seismal
sigma84513832s_igma_
sigmas94111362s_igmas
signal73711482s_ignal
stibial946582stibial
stigmata1144672stigmata
stomal85213312st_omal
stromal93010592stromal
animal85016253ani_mal
astigmia1143363astigmia
astigmias1243463astigmias
dismal92412243_dismal
enigma935643enigma_
enigmas1045173enigmas
epigeal1046243epigeal
estival1036323esti_val
gimmal11247513_gimmal
hiemal11339503_hiemal
intimal9109943inti_mal
optimal1145783opti_mal
primal104014623pri_mal
saiga64717933saig_a_
saigas74114293saig_as
serumal938783serumal
shipman14247133shipman
sial45938833s_i__al
sigil63515503s_ig_il
sigla64515203s_igla_
sigmate10710143s_igmate
signa66114703s_igna_
signals8359163s_ignals
sima64730783s_i_ma_
simar74920813s_i_mar
simas75727553s_i_mas
sisal54217733s_i_sal
smegma1134113smegma_
smegmas1233503smegmas
spinal84915313spi_nal
spiral83715343spi_ral
spital83813873spi_tal
stammel11607533stammel
statal61613223st_atal
steal56125473st__eal
stemma10328133stemma_
stemmas11256973stemmas
sterigma1144113sterigma_
sterigmas1243563sterigmas
sternal73411913sternal
stickman1643943stickman
stigmatic1445733stigmatic
still54922083sti__ll
stillman1043953stillman
stime76521803sti_m_e
stimes85920573sti_mes
stimuli944513sti_muli
stimy105114743sti_m_y
stingray1243583stingray
stipel84412123sti_pel
stoical9310283stoical
stoma75918273st_oma_
stomas84816323st_omas
stratal72710603stratal
strigil837263strig_il
stroma84313073stroma_
struma84313273struma_
strumae9368093strumae
strumas9419833strumas
stygian1144083stygian
subgoal1046323subgoal
swagman1334913swagman
swingman1443593swingman
tamal73522623_t_amal
tibial849843_tibial
tical76021493_ti_cal
tidal64516443_ti_dal
timbal102510753_timbal
tincal83913363_tincal
tineal66216163_tineal
tinman82411143_tinman
titman82711003_titman
vestigial1343773vestigial

Search took 9 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.406440125.6
2DLD Change Limit134027847.64017542.8
3Display Results84840.0332545.5
 (SQL Overall)178691848.07922118.0
 
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.