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

171 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
erratic931112(None) 
erratics1046981erratics
ectatic11310122ectatic
enatic8317562e_natic
ergastic11106622ergastic
ergotic1049722ergotic
eristic9814092eristic
erotic82620272e_rotic
errata639012errat_a
erratas736862erratas
erratical1146902erratical
erratum944512erratum
ferritic1347072ferritic
piratic11314292piratic
uratic83016362_uratic
acmatic13311703acmatic
acrotic112515543acrotic
aerobatic1399003aerobatic
agnatic10310973agnatic
agravic1345893agravic
aortic8316613aor_tic
apractic1448303apractic
apraxic1846293apraxic
aprotic112715243aprotic
aquatic1838113aquatic
arabic10312733_arabic
arctic10313513_arctic
argotic10310283argotic
aromatic12315643aromatic
astatic9514193astatic
atretic9313923atretic
aviatic1239243aviatic
barytic1437823barytic
boracic1338723boracic
caryatic1548503caryatic
ceramic1339823ceramic
ceratin93020163ceratin
cerotic11415063cerotic
comatic131816943comatic
creatin93618133creatin
cretic102816283_cretic
critic103616813_critic
cryptic1646153cryptic
dramatic1369433dramatic
drastic10310883drastic
dryadic1443633dryadic
ecstatic1246153ecstatic
eidetic1039743eidetic
eirenic939003eirenic
ekistic1377843ekistic
elastic93013393elastic
emetic10614453e_metic
empathic1764663empathic
emphatic1747863emphatic
entastic1048553entastic
enuretic1046993enuretic
eremitic1248553eremitic
erethic1257723erethic
ergate7315143ergat_e
ergates8314493ergates
ergative1238973ergative
ergodic1145503ergodic
eristics10610193eristics
erotica92811513e_rotica
erotics91914153e_rotics
errable9312183errable
errancy1256363errancy
errand758793erra_nd
errands847603errands
errant6618733erra_nt
errantly1175793errantly
errantry11113463errantry
errants7410643errants
erraticism1455273erraticism
ersatz1536653ersat_z
etic66123953e___tic
eucritic1247133eucritic
eustatic1047343eustatic
exotic153112653e_xotic
fanatic12610703fanatic
faradic1337693faradic
ferrate103014043ferrat_e
ferrates113013423ferrates
ferric1139993ferr__ic
ferritin1147383ferritin
frantic12310373frantic
geriatric1244403geriatric
germanic1367503germanic
gerontic1147963gerontic
gratin74520583_gratin
gratis74819243_gratis
hematic141816753hematic
hepatic141712773hepatic
heretic12314833heretic
hermetic15310243hermetic
hermitic1539653hermitic
herpetic1547773herpetic
hieratic1349223hieratic
iritic83213823_iritic
karstic1357983karstic
keramic1537233keramic
keratin113314153keratin
leprotic1248583leprotic
leviratic1443723leviratic
lunatic938753lunatic
meristic12311253meristic
necrotic12310053necrotic
nematic111714003nematic
neritic91314333neritic
neumatic1258533neumatic
neuritic1048593neuritic
neurotic1039703neurotic
noritic91213543noritic
operatic1249933operatic
orectic1138823orectic
organic1038313organic
orgastic11116213orgastic
osmatic11179993osmatic
paretic113016673paretic
parotic112518043parotic
periotic12313443periotic
perlitic12310583perlitic
phatic133014413_phatic
phratric1545953phratric
phreatic1548343phreatic
practic13312253practic
prelatic12311293prelatic
priapic1346023priapic
protatic12314753protatic
pruritic1267403pruritic
psoatic1139303psoatic
puranic11410483puranic
pyretic143210783pyretic
pyritic143311313pyritic
quartic18258473quartic
rabic93817403__rabic
ratio55227583__ratio
rhotic112711233_rhotic
rustic8712673_rustic
sciatic11910173sciatic
sematic111716883sematic
seriatim1049223seriatim
serranid947573serranid
serrate73017543serrat_e
serrated92513433serrated
serrates82617023serrates
serrating10513213serrating
serration9414073serration
somatic111916473somatic
soritic91414433soritic
spermatic1548713spermatic
static83118683_static
strati63518903strati_
termitic1249283termitic
terrain7410853terra_in
terrapin1046203terrapin
terraria847023terraria
terrific1344803terrific
tetradic1145813tetradic
tragic93811553_tragic
triadic1037833triadic
tryptic1446003tryptic
uranic82315183_uranic
uretic82914353_uretic
vatic10316423__vatic
venatic12311523venatic
verbatim1545033verbatim
veristic1339883veristic
viatic11311453_viatic
xerotic16410863xerotic
zebraic2044293zebra_ic

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271717.15618729.3
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.60923484.2
 
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.