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

80 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
santalic104889(None) 
tantalic1048051tantalic
antalgic1146692_antalgic
mandalic1347802mandalic
santalol844792santalol
satanic939932sa_tanic
vandalic1446112vandalic
alkalic13146973_alkalic
angelic1039623_angelic
animalic1258153_animalic
antacid10311223_antacid
antalgics1245173_antalgics
antic75728863_ant__ic
astatic9514193_astatic
atavic11189293_a_tavic
ataxic15169203_a_taxic
atelic8313703_a_telic
battalia1045293battalia
cannabic1474913cannabic
cantal84122033cantal__
cantala94114673cantal_a
cantalas104013523cantalas
cantals93919573cantal_s
cantic103920543cant__ic
dactylic1643663dactylic
dentalia947533dentalia
fanatic12610693fan_atic
fantail10310233fanta_il
fantails1139693fantails
fantasia1197013fantasia
fantasie11117743fantasie
fantastic1446143fantastic
genitalic1243923genitalic
italic839903__italic
manganic1346993manganic
mantic104120903mant__ic
mantric11311343mant_ric
pachalic1757273pachalic
pantalet10415903pantalet
pashalic1546183pashalic
sabbatic1445323sabbatic
saccadic1244173saccadic
salic73424713s___alic
sandal73317283sandal__
sandaled1039243sandaled
sandaling112010563sandaling
sandals82715203sandal_s
sandarac1145833sandarac
sanitaria947063sanitaria
santalols944773santalols
santeria8311653santeria
santimi938793santimi_
santir6315253sant__ir
santol64515243santol__
santolina946263santolina
santols73513323santol_s
santonica1145373santonica
santonin849703santonin
satiric939243sa_tiric
satyric1237493sa_tyric
sialic8313633s__ialic
stanzaic1943363stanza_ic
static83118683s__tatic
stelic8313083s__telic
sultanic1046173sultanic
syngamic1644243syngamic
syntactic1644553syntactic
syntonic1347703syntonic
systaltic1444623systaltic
systolic1345653systolic
tantalise91210823tantalise
tantalite91010863tantalite
tantalize181010573tantalize
tantalum1044323tantalum
tantalus836373tantalus
tantric939583tant_ric
tartaric1047053tartaric
vanadic1336743van_adic
vanillic1344263vanillic
xanthic1945863xant_hic

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 Filter1786911461620.423422437.4
2DLD Change Limit146162807.28320068.9
3Display Results80800.0302666.7
 (SQL Overall)178691807.73623098.6
 
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.