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

99 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
aplastic124924(None) 
plastic112815061_plastic
anaplastic1445682anaplastic
anelastic1147042anelastic
aphasic142810062aphas_ic
aplanatic1344902aplanatic
aplasia92510802aplas_ia
aplitic11311742apl_itic
apractic1448302apractic
clastic113013962_clastic
elastic93013392_elastic
euplastic1345462euplastic
plasmic13249112_plasmic
plastics122412332_plastics
plastid102112522_plastid
spastic11310382sp_astic
acmatic13311693acma_tic
acoustic1246443acoustic
acrostic1239943acrostic
agnatic10310973agna_tic
agnostic1146713agnostic
agrestic1147923agrestic
ailanthic1443373ailanthic
alastor739653a_lastor
albitic1139133a_lbitic
allantoic1183903allantoic
aloetic9313183a_loetic
amnestic1247053amnestic
analytic1348183analytic
aoristic10311163aoristic
apatetic1258583apatetic
aphanitic1646013aphanitic
aphasia122510873aphas_ia
aphasiac15286593aphasiac
aphasics15257233aphas_ics
aphetic142912853ap_hetic
aphotic142913123ap_hotic
aplasias10279233aplasias
apostil947903ap_ostil
apraxic1846293apra_xic
aprotic112715243ap_rotic
apyretic1546843apyretic
aquatic1838113aqua_tic
artistic10310893artistic
asbestic1245383asbestic
asphaltic1644603asphaltic
astatic9514193asta_tic
atactic11410083a_tactic
autistic10310103autistic
aviatic1239243avia_tic
axoplasmic2382993axoplasmic
ballistic1346613ballistic
blastie92411393_blastie
chiastic15287483chiastic
classic113710113_classic
clastics122811413_clastics
dicastic1347343dicastic
drastic10310873_drastic
dynastic1445853dynastic
dysplastic1853453dysplastic
elastics102710883_elastics
elastin72611843_elastin
entastic1048553entastic
epiblastic1653653epiblastic
epinastic1344953epinastic
ergastic11106623ergastic
euplastics1443663euplastics
fantastic1446143fantastic
galactic13106533galactic
haplontic1643943haplontic
holistic13311263holistic
inelastic1146463inelastic
lactic10713493__lactic
mastic103119173__mastic
metaplastic1754393metaplastic
monastic1249863monastic
nastic82915973__nastic
neoplastic1446783neoplastic
nonplastic1447003nonplastic
oblasti945953oblasti_
orgastic11116213orgastic
papistic1448733papistic
parasitic1349523parasitic
pastie85525523_p_astie
pastil85018323_p_astil
pastis84924323_p_astis
phasic133612053_phas_ic
phatic133014413_pha_tic
plasmatic1547213_plasmatic
plasmid12239553_plasmid
plasmin112410033_plasmin
plaster93318693_plaster
plasticky2043593_plasticky
plasticly1644763_plasticly
plastids11269213_plastids
practic13312243_practic
sarcastic1365693sarcastic
spastics1237503sp_astics
telestic10118953telestic

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.440406115.9
2DLD Change Limit146162997.50019488.3
3Display Results99990.0462152.2
 (SQL Overall)178691997.98622375.5
 
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.