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

140 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
spastics123750(None) 
spastic11310381spastic_
clastics122811412clastics
elastics102710882elastics
mastics112614782_mastics
pasties94529812_pasties
pastils94416172_pastils
pastis84924322_pasti_s
plastics122412332plastics
statics93314532sta_tics
swastica1384152swastica
swasticas1493802swasticas
antics84621453__antics
aphasics15257243aphas_ics
aplastic1249243aplastic_
apostils1046773apostils
asdics9439863__asdics
aspics104211563__aspics
attics84413283__attics
basics104915123_bas_ics
beasties102514653beasties
blasties102113633blasties
bustics11810883_bustics
caustics1237483caustics
classics12418873classics
clastic113013963clastic_
drastic10310883drastic_
ekistics1485703ekistics
elastic93013393elastic_
elastins82111743elastins
eristics10610193eristics
euplastics1443663euplastics
fustics1279593_fustics
gnostics1146323gnostics
hepatics15198933hepa_tics
mastic103119173_mastic_
monastics1346803monastics
mystics14279103_mystics
nastic82915973_nastic_
nasties73520493_nasties
optics102810183op__tics
panics103815363_pa_nics
panties94230933_panties
paretics122312443_paretics
parties93230873_parties
pastas85422873_past_as
pastels95215183_pastels
pasters94531733_pasters
pastes85233913_past_es
pasticci1443823_pasticci
pastiche1546933_pastiche
pastiches1637453_pastiches
pastie85525523_pasti_e
pastier94320383_pastier
pastiest103319553_pastiest
pastil85018323_pasti_l
pastime114611973_pastime
pastimes123611903_pastimes
pastina93914593_pastina
pastinas103712163_pastinas
pasting103826553_pasting
pastises103616053_pastises
pastitso1043623_pastitso
pastors94119003_pastors
pastries101517423_pastries
pasts75936503_past__s
patins87528783_pa_tins
patios85221793_pa_tios
patsies93919483_patsies
patties93425143_patties
peptics132610243_peptics
photics142810483_photics
pistils93314303_pistils
plastic112815063plastic_
plastids11269213plastids
poetics11312073_poetics
posties93128813_posties
postins93721203_postins
quantics19276833quantics
quartics19216853quartics
rustics9810733_rustics
salties73725773s_alties
santims9312603s_antims
santirs7312963s_antirs
sapphics1743423sapphics
sasins64923103s_as_ins
sassies74719263s_assies
satins64930483s_a_tins
satis55633683s_a_ti_s
scanties103215423scanties
sceptics1455663sceptics
sciatics12117273sciatics
seasick1346193seas_ick
semantics1346823semantics
septics112810433s_eptics
shanties113116593shanties
shantihs14276213shantihs
shantis103313103shanti_s
shasliks1544143shasliks
skeptics1653863skeptics
slapstick1742863slapstick
slapsticks1852403slapsticks
smarties10312873smarties
solstice1047223solstice
solstices1146703solstices
spadices1336093spa_dices
spagyrics1741523spagyrics
spahis11310383spa_hi_s
spails84817823spa__ils
spaits85017473spa__its
sparids103512123spa_rids
sparoids11218713sparoids
sparsities1247323sparsities
spartina1037983spartina
spartinas1135803spartinas
spasming13227203spasming
spasms10418973spas__ms
spasticity1754263spasticity
spates85028173spa_t_es
spathes125116533spa_thes
spathic1437543spathic_
spatial9310323spa_tial
spats75031383spa_t__s
spatters103914703spatters
spatting113111763spatting
spavies123012953spa_vies
spavins12419323spa_vins
spherics1537073spherics
spics94123243sp___ics
stasis63116873stas_i_s
static83118683sta_tic_
statice92614033sta_tice
statices102712343sta_tices
statins73719773sta_tins
statistics1244343statistics
styptics1543813styptics
swastika1591853swastika
swastikas1681423swastikas
tactics1149323_tactics
upstirs935293up_stirs

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 Limit1461621406.84321359.3
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.31224438.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.