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

200 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
elastic9301339(None) 
clastic113013961clastic
elastics102710881elastics
elastin72611841elastin
plastic112815061plastic
anelastic1147042anelastic
aplastic1249242aplastic
blastie92411392blastie
classic113710112classic
clastics122811412clastics
drastic10310872drastic
ekistic1377842ekistic
elastins82111732elastins
enatic8317562ena_tic
entastic1048552entastic
ergastic11106622ergastic
eristic9814092eristic
euplastic1345462euplastic
inelastic1146462inelastic
lactic10713492_lactic
mastic103119172_mastic
nastic82915972_nastic
plasmic13249112plasmic
plastics122412322plastics
plastid102112522plastid
spastic11310382spastic
telestic10118952telestic
alastor739653alastor
albitic1139133albitic
aloetic9313183aloetic
antic75728863__antic
asdic83814093__asdic
aspic95114733__aspic
astir55517093__astir
atactic11410083atactic
attic75618353__attic
basic96220523_bas_ic
beastie92412433beastie
blast76532573blast__
blasted104213473blasted
blastemic1543663blastemic
blaster94017303blaster
blastier10249493blastier
blasties102113623blasties
blasting114013423blasting
blasts85116773blast_s
blasty115611053blast_y
bustic101012693_bustic
cantic103920543_cantic
caseic103212373_caseic
caustic1139753caustic
chaotic14310043chaotic
chasmic16177983chasmic
chiastic15287483chiastic
cladistic1445683cladistic
classico12386303classico
classics12418873classics
classis93712723classis
clast76030583clast__
clasts84817293clast_s
clitic103315053cl_itic
cystic132710653_cystic
deistic10311173deistic
deltic9312503del__tic
dicastic1347343dicastic
dynastic1445853dynastic
east46659103e_ast__
easter65027983e_aster
easting84924303e_asting
easts57530323e_ast_s
ecesic10369223eces_ic
eclamptic1742613eclamptic
eclectic1156073eclectic
ecliptic1455333ecliptic
ectatic11310123ectatic
edaphic1544243edaphic
egoistic1147103egoistic
eidetic1039743eidetic
ekistics1485703ekistics
elain55324703ela__in
elapid939543ela_pid
elastase845643elastase
elasticity1575383elasticity
elate55335883ela_t_e
elated74725823ela_ted
elater64724203ela_ter
elates65032363ela_tes
elating83423083ela_ting
elation73620453ela_tion
elative10312453ela_tive
electric1249183electric
elenctic1245883elenctic
elliptic1254753elliptic
emetic10614453e_metic
encaustic1343393encaustic
epiblastic1653653epiblastic
epinastic1344953epinastic
ergotic1049723ergotic
eristics10610193eristics
erotic82620273e_rotic
erratic9311113erratic
etic66123953e___tic
euplastics1443653euplastics
exosmic1844373exosmic
exotic153112653e_xotic
felsic1147053fel_s_ic
felsitic1345033felsitic
fistic11812573_fistic
flagstick1942793flagstick
frantic12310363frantic
fustic11910633_fustic
galactic13106533galactic
gastric1038633_gastric
gelati73814533gela_ti_
gelatin83514733gela_tin
gelatis83313513gela_tis
gestic9312773_gestic
glassie8329493glassie
glottic1036653glottic
glyptic1544503glyptic
gnostic1038433gnostic
haptic13511893_haptic
hematic141816743hema_tic
hepatic141712773hepa_tic
hexastich2443343hexastich
holistic13311263holistic
illitic939253illitic
karstic1357983karstic
laic65931563_la__ic
lassi56316853_lassi_
lassie64917743_lassie
lassis65216703_lassis
last46260323_last__
lasted74323603_lasted
laster64830633_laster
lasting84725243_lasting
lastly93310873_lastly
lasts57731263_last_s
lati46438273_la_ti_
lattice938433_lattice
lattin64316223_lattin
least56134883least__
leasts64616413least_s
lentic83515743_lentic
lotic76420673_l_otic
luetic8310383_luetic
lytic104513033_l_ytic
mantic104120903_mantic
mastics112614783_mastics
mastix152310513_mastix
melanic11310403mela_nic
melanistic1445873melanistic
melanitic1346713melanitic
melanotic1345393melanotic
meristic12311253meristic
miasmic1335743miasmic
monastic1249863monastic
mystic132711643_mystic
nematic111713993nema_tic
neoplastic1446773neoplastic
neustic937943neustic
nonelastic1247103nonelastic
oblasti945943oblasti_
orgastic11116213orgastic
pastie85525523_pastie
pastil85018323_pastil
pastis84924323_pastis
pedantic1346583pedantic
pelagic1237863pela_gic
pelitic111814653pel_itic
phasic133612053phas_ic
phatic133014413pha_tic
plasmatic1547213plasmatic
plasmid12239553plasmid
plasmin112410033plasmin
plaster93318693plaster
plasticky2043593plasticky
plasticly1644763plasticly
plastids11269203plastids
practic13312243practic
prelatic12311283prela_tic
quantic18279063quantic
quartic18258473quartic
realistic1148553realistic
rustic8712673_rustic
sebasic1146893sebas_ic
semantic1249553semantic
sematic111716873sema_tic
slapstick1742863slapstick
spastics1237503spastics
static83118683sta_tic
swastica1384153swastica
tactic10612753_tactic
telestich14135323telestich
telestics1196963telestics
uratic83016353ura_tic
vatic10316423_va_tic
venatic12311523vena_tic
veristic1339883veristic
viatic11311453via_tic

Search took 7 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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272005.90622693.4
3Display Results2002000.0633174.6
 (SQL Overall)1786912006.10929250.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.