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

135 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
elastics10271088(None) 
clastics122811411clastics
elastic93013391elastic_
elastins82111741elastins
plastics122412331plastics
blasties102113632blasties
classics12418872classics
clastic113013962clastic_
ekistics1485702ekistics
elastin72611842elasti_n
eristics10610192eristics
euplastics1443662euplastics
mastics112614782_mastics
plastic112815062plastic_
plastids11269212plastids
spastics1237502spastics
telestics1196962telestics
alastors8311223alastors
anelastic1147043anelastic_
antics84621453__antics
aplastic1249243aplastic_
asdics9439863__asdics
aspics104211563__aspics
attics84413283__attics
basics104915123_bas_ics
beasties102514653beasties
blasters104116143blasters
blastie92411393blasti_e
blastier10249493blastier
blastiest111710053blastiest
blasting114013433blasting
blastings12347913blastings
blasts85116773blast__s
bustics11810883_bustics
caustics1237483caustics
cladistics1553653cladistics
classic113710113classic_
classico12386303classico
classis93712723classi_s
clasts84817293clast__s
clitics11279973cl_itics
drastic10310883drastic_
easies64126633e_as_ies
easters75125683e_asters
easting84924303e_asting
eastings93412953e_astings
easts57530323e_ast__s
eclectics1254813eclectics
ecliptics1553653ecliptics
ekistic1377843ekistic_
elains64919853ela__ins
elapids1036503ela_pids
elastase845643elastase
elastases946113elastases
elasticity1575383elasticity
elaters74420193ela_ters
elates65032363ela_t_es
elating83423083ela_ting
elation73620453ela_tion
elations83719123ela_tions
elative10312453ela_tive
elatives1139783ela_tives
electrics1348003electrics
emetics11610723e_metics
enatic8317563ena_tic_
encaustics1452373encaustics
entastic1048553entastic_
ergastic11106623ergastic_
eristic9814093eristic_
erotics91914153e_rotics
erratics1046983erratics
euplastic1345463euplastic_
exotics16229193e_xotics
flagstick1942793flagstick
flagsticks2052363flagsticks
fustics1279593_fustics
gelatins93414093gela_tins
gelatis83313513gela_ti_s
glassies94012273glassies
glyptics1643103glyptics
gnostics1146323gnostics
hematics151712193hema_tics
hepatics15198933hepa_tics
hexastich2443343hexastich
hexastichs2541823hexastichs
inelastic1146463inelastic_
lactic10713493_lactic_
laics76419253_la__ics
laities7320343_laities
lashins103915153_lashins
lassies74420103_lassies
lassis65216703_lassi_s
lasters75627693_lasters
lasting84725243_lasting
lastings94214423_lastings
lasts57731263_last__s
latices9313763_la_tices
lattice938433_lattice
lattices1038383_lattices
lattins74115483_lattins
lealties8310793lealties
leasts64616413least__s
luetics937323_luetics
mastic103119173_mastic_
melanics1237733mela_nics
monastics1346803monastics
mystics14279103_mystics
nastic82915973_nastic_
nasties73520493_nasties
pasties94529813_pasties
pastils94416173_pastils
pastis84924323_pasti_s
pelagics1345553pela_gics
plasmic13249113plasmic_
plasmids13236553plasmids
plasmins12199413plasmins
plasters103518133plasters
plasticky2043593plasticky
plasticly1644763plasticly
plastid102112523plasti_d
platies93722543pla_ties
quantics19276833quantics
quartics19216853quartics
rustics9810733_rustics
semantics1346823semantics
slapstick1742863slapstick
slapsticks1852403slapsticks
spastic11310383spastic_
statics93314533sta_tics
swastica1384153swastica
swasticas1493803swasticas
tactics1149323_tactics
telestic10118953telestic_
telestich14135323telestich
telestichs15113223telestichs

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 Limit1461621357.31319986.6
3Display Results1351350.0602250.0
 (SQL Overall)1786911357.79622920.9
 
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.