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

149 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
ergotic104972(None) 
argotic10310281argotic
ergodic1145501ergodic
erotic82620271er_otic
cerotic11415062cer_otic
ergastic11106622ergastic
ergot65422892ergot__
ergotism1146272ergotism
ergots74512372ergot_s
eristic9814092eristic
erotica92811512er_otica
erotics91914152er_otics
erratic9311122erratic
exotic153112652e_xotic
periotic12313442periotic
rhotic112711232_rhotic
xerotic16410862xer_otic
zygotic2254662zygotic
abiotic11510463abiotic
acrotic112515543acrotic
aerobic11310213aer_obic
agonic93515143_agonic
aphotic142913123aphotic
aprotic112715243aprotic
arctic10313513ar_ctic
argentic1149023argentic
argot67728653argot__
argots74116033argot_s
arkosic1346063arkosic
augitic1038283augitic
azotic172711633_azotic
biotic103816613_biotic
bromic122412693br_omic
chaotic14310043chaotic
cretic102816283cr_etic
critic103616813cr_itic
cryonic1437833cryonic
cryptic1646153cryptic
demotic12412353demotic
despotic1346533despotic
drastic10310883drastic
ecbolic1345623ecbolic
echoic1339043echo_ic
ectatic11310123ectatic
ectopic1338153ectopic
egoistic1147103e_goistic
egotism1038353e_gotism
egotist8411273e_gotist
eidetic1039743eidetic
eidolic1047063eidolic
ekistic1377843ekistic
elastic93013393elastic
embolic1347423embolic
embryotic1843373embryotic
emetic10614453e_metic
enatic8317563e_natic
energetic1245283energetic
enolic8413353e_nolic
entopic1149953entopic
enzootic1944323enzootic
epidotic1346883epidotic
epigonic1346723epigonic
eremitic1248553eremitic
erethic1257723erethic
ergate7315143ergat_e
ergates8314493ergates
ergative1238973ergative
ergo56420153ergo___
ergogenic1345493ergogenic
ergometric1545993ergometric
ergonomic1444213ergonomic
ergotisms1245303ergotisms
ergotized2044733ergotized
eristics10610193eristics
erogenic111110543erogenic
erotical101911983er_otical
erotism9312303er_otism
erotize16311663er_otize
erratics1046983erratics
etic66123953e___tic
eugenic1038603eugenic
euphotic15117523euphotic
exegetic1844893exegetic
exergonic1943513exergonic
exonic153211413e_xonic
exotica16257603e_xotica
exotics16229193e_xotics
ferritic1347073ferritic
frantic12310373frantic
frolic1149203fr_olic
gerontic1147963gerontic
gothic1237793__gothic
heretic12314833her_etic
hermetic15310243hermetic
hermitic1539653hermitic
heroic113516923her_o_ic
herpetic1547773herpetic
idiotic1037463idiotic
iritic83213823ir_itic
ironic8313773ir_onic
kenotic1359713kenotic
keratotic1545643keratotic
ketotic1348643ketotic
leprotic1248583leprotic
leukotic1444523leukotic
litotic939243litotic
lordotic1144993lordotic
lotic76420673__lotic
meiotic11410933meiotic
meristic12311253meristic
meropic13310263mer_opic
miotic103715753_miotic
mitotic1139713mitotic
mycotic1647713mycotic
myotic133112313_myotic
narcotic1277913narcotic
necrotic12310043necrotic
nepotic11310563nepotic
neritic91314333ner_itic
neurotic1039693neurotic
orectic1138823orectic
organic1038313organic
orgastic11116213orgastic
orgic8311823org__ic
orthotic1348213orthotic
osmotic11127613osmotic
otic66624823___otic
parotic112518043parotic
peridotic1446483peridotic
periodic1348433periodic
perlitic12310583perlitic
photic133316443_photic
practic13312253practic
ptotic102713373_ptotic
rhodic12227233_rhodic
robotic1139223robotic
roti46332933_r_oti_
rotis56327063_r_otis
rustic8712673_rustic
semiotic12710633semiotic
sermonic1248883sermonic
termitic1249283termitic
tropic103014193tr_opic
tryptic1446003tryptic
unerotic1049193uner_otic
uratic83016363ur_atic
uretic82914353ur_etic
veristic1339883veristic
zymotic2345713zymotic

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271497.57617691.0
3Display Results1491490.0463239.1
 (SQL Overall)1786911498.04522211.4
 
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.