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

112 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
ectopic133815(None) 
ectopia1147691ectopia
entopic1149951entopic
atopic103514142_atopic
ecbolic1345622ecbolic
echoic1339042echo_ic
ecotypic1744412ecotypic
ectatic11310122ectatic
ectopias1248272ectopias
entropic1249682entropic
metopic1339762metopic
octopi1036532octopi_
scotopic1446512scotopic
tectonic1248452tectonic
topic95721502__topic
acetonic1238733acetonic
acronic112814693acronic
acrotic112515543acrotic
actinic111810553actinic
atomic104115603_atomic
atonic83420473_atonic
atypic13337653_atypic
autopsic1246063autopsic
biopic123710673_biopic
canopic1338803canopic
cecropia1455153cecropia
cerotic11415063cerotic
chopin132712193_chopin
choric133515903_choric
clonic104914673_clonic
colic95726173_c_olic
comic114721813_c_omic
conic95329793_c_onic
ecbolics1444003ecbolics
ecesic10369223ec_esic
ecliptic1455333ecliptic
ecologic1349563ecologic
economic1447863economic
ecstatic1246153ecstatic
ectasis9249613ectasis
ectogenic1446193ectogenic
ectomeric1546163ectomeric
ectoproct1552903ectoproct
ectosarc1243133ectosarc
ectozoa1843143ectozoa
ectypal1442773ectypal
ectype1334283ectyp_e
ectypes1434803ectypes
eidolic1047063eidolic
embolic1347423embolic
enchoric1547103enchoric
enolic8413353e_nolic
enteric9314213enteric
entoil6912493ento_il
entozoic1944573entozoic
epic86921303e___pic
epitomic1446783epitomic
ergodic1145503ergodic
ergotic1049723ergotic
erotic82620273e_rotic
esotropic13126793esotropic
estop74312103estop__
estops84011223estop_s
ethic101511223e_t_hic
ethnic1148853e_thnic
etic66123953e_t__ic
eurytopic1653093eurytopic
eutrophic1646403eutrophic
excitonic2043253excitonic
exonic153211413e_xonic
exotic153112653e_xotic
exotoxic1645153exotoxic
exotropic20116263exotropic
geotropic1467013geotropic
hectic132311523hect__ic
iconic10411593ic_onic
icteric1138023icteric
ictic9311803ict__ic
isotopic12187293isotopic
ketonic1349923ketonic
ketotic1348643ketotic
lactonic1248043lactonic
leptonic1247703leptonic
litotic939243litotic
meropic13310263meropic
mitotic1139713mitotic
motoric11312223motoric
myopic15308463_myopic
necrotic12310043necrotic
nektonic1445723nektonic
neotropic1367713neotropic
octadic1245713octadic
octopod1244893octopod
octopus1144813octopus
pectic122913873pect__ic
pentomic1448143pentomic
peptonic1448833peptonic
photopic17411093photopic
ptotic102713373_ptotic
scotopia1245733scotopia
stoic7317253_sto_ic
subtopic1445073subtopic
tectonics1345953tectonics
tonic74727653__tonic
topi67830393__topi_
topics104714583__topics
topis76025833__topis
toric76529313__toric
toxic145315623__toxic
tropic103014193_tropic
typic124511963__typic
utopia8107883_utopia

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.406440125.6
2DLD Change Limit1340271126.11021935.7
3Display Results1121120.0303733.3
 (SQL Overall)1786911126.54627297.7
 
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.