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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
satanist831337(None) 
satanism1039671satanism
satanists948231satanists
atavist10311092_atavist
botanist10412032botanist
fatalist11314972fatalist
lutanist8410272lutanist
paganist11411812paganist
satangs8479712satangs_
satanic939932satani_c
satanisms1148142satanisms
satirist8313502satirist
shamanist1447102shamanist
sitarist8315282sitarist
statist7317722s_tatist
tanist6324592__tanist
against838383_against
agonist82615403_agonist
astonish1148453astonish
atavism1238033_atavism
atavists1137583_atavists
atheist10314063_atheist
atomist92915763_atomist
botanise1039643botanise
botanists1148203botanists
cabalist12314503cabalist
canonist10513533canonist
catalyst1347313catalyst
dadaist9310103dada_ist
etatist7415033_etatist
fantasist1288003fantasist
fatalism13310483fatalism
fatalists12310023fatalists
hagadist1347603hagadist
halakist15158223halakist
humanist13410493humanist
kabalist14410083kabalist
lutanists966843lutanists
lutenist8610663lutenist
melanist10313053melanist
metalist10519353metalist
natant6318733natan__t
nativist11118683nativist
naturist8410813naturist
onanist7314633_onanist
organist9411543organist
paeanism1248703paeanism
paganise1139663paganise
paganish1447773paganish
paganism1369113paganism
paganists1247643paganists
pianist9615103_pianist
ratanies8312923ratanies
ratans63819373ratan_s_
sacrist9315423sa_crist
sadist74221353s__adist
safaris101110663safaris_
saganash1243073saganash
salamis9313513salamis_
salariat8416303salariat
saltant7316773saltan__t
sanest64426693s__anest
sapphist1545773sapphist
sarans64224433saran_s_
sarodist9510923sarodist
satang75711563satan__g
satanical1145413satanical
sataras7315063sataras_
satays94411683sata_ys_
satinet7325283satin_et
satinets8311733satinets
satins64930483satin_s_
satirise8310683satirise
satirists958923satirists
satis55633683sat__is_
satoris7317253satoris_
saturnism1144223saturnism
savagest1245773savagest
savagism1444883savagism
savant9416043savan__t
savants1038653savants_
shamanism1645343shamanism
shamanists1544323shamanists
simonist10410723simonist
sitarists949373sitarists
sodalist9311883sodalist
stagiest91613413s_tagiest
stains64923653s_tains_
stalest73720173s_talest
standish1238543s_tandish
stands75118053s_tands_
stanes64933403s_tanes_
stangs75018163s_tangs_
stanine73417073s_tanine
staning83922243s_taning
stanks104917703s_tanks_
stasis63116873s_tasis_
statant7313123statan__t
statism9412283s_tatism
statists8310163s_tatists
stoniest8413543s_toniest
stonish10410653s_tonish
stylist102110283s_tylist
swarajist1942873swarajist
tanists7313653__tanists
tarantist948913tarantist
tatamis939723tatamis_
tetanise8610203tetanise
titanism1048213titanism
totalist8315583totalist
urbanist10109073urbanist
vitalist11313393vitalist
votarist111012163votarist
womanist13410433womanist

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621147.70318974.7
3Display Results1141140.0462478.3
 (SQL Overall)1786911148.17221866.3
 
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.