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

130 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
enterics1031285(None) 
enteric9314211enteric_
eateries8324312eateries
endemics1346272endemics
enterers82214152enterers
entering91920052entering
enteritis9411302enteritis
enterons8314152enterons
enters64425642enter__s
entries71523162ent_ries
generics11118792gen_erics
icterics1247052icterics
interims101013072interims
neoterics1145692neoterics
anterior8611053anterior
antherids1368723antherids
antics84621453ant__ics
arteries8321483arteries
asterias8317013asterias
centering122915143centering
centerings13247663centerings
centers94420603center__s
centesis1058143centesi_s
centric11312403cent_ric_
centuries11311333centuries
clerics1149333_clerics
coteries10422703coteries
deuteric1146343deuteric_
eaters65535953eater__s
elaterids1046163elaterids
elaterins9410033elaterins
emeries91620023e_meries
emetics11610723e_metics
emperies12314563emperies
empirics1444003empirics
endemic1237893endemic_
endermic1356173endermic_
enders74324053ender__s
endrins8312163en_drins
enemies9313693en_emies
energids1045583en_ergids
energies9310783en_ergies
enrich1138943en__rich
enserfs1035483enser_fs
entails7912823ent_ails
entasias8269143entasias
entasis73012573entasi_s
entellus845173entellus
ententes8312773ententes
enter54726383enter___
entera64216833enter__a
enteral73516443enter_al
entered82718883enter_ed
enterer72015633enter_er
enteron7313333enter_on
entertains1047623entertains
enthetic131110613enthetic_
enthrals11278903enthrals
entice81316863ent__ice
entices91616333ent__ices
entires71517783entir_es
entities8617413entities
entoils7810733ent_oils
entopic1149953entopic_
entrails8310163entrails
entrains8312963entrains
entraps9109763ent_raps
entreats839773entreats
entrees71813773ent_rees
entrench13115723entrench
enuretics1145063enuretics
esoteric1057593esoteric_
esoterica1144273esoterica
esterify1445623esterify
esters64627733ester__s
esthetics14106963esthetics
estrins7315853est_rins
etheric12311783etheric_
ethics11169283e_t_hics
ethnics1236263e_thnics
eugenics1146583eugenics
eutectics1344023eutectics
euthenics1466283euthenics
exoteric1746803exoteric_
exterior1547373exterior
exteriors1647323exteriors
externes1539833externes
externs1438233exter_ns
fluerics1345393fluerics
generic101310753gen_eric_
genetics11128613gen_etics
gentrice1148813gent_rice
gentrices1258913gent_rices
gentries91315263gent_ries
henneries1248643henneries
hysterics1746053hysterics
icteric1138023icteric_
inherits11310103inherits
interact10316463interact
interacts11312123interacts
interdict12410213interdict
interdicts1347083interdicts
interim9912873interi_m
interior8513093interior
interiors9513563interiors
intermits111212203intermits
internes82721233internes
interns73116773inter_ns
inters64328053inter__s
interties9320333interties
lienteries1047563lienteries
metrics11312363met_rics
neoteric1047853neoteric_
niteries8318383niteries
numerics1266283numerics
pterins9812993_pterins
renters74224813renter__s
santerias9311843santerias
sentries81318053sent_ries
sferics1236133_sferics
spherics1537073spherics
steric8317063_steric_
tentering102313203tentering
tenters73921103tenter__s
torics85118353__torics
untrims938613unt_rims
veneries112815033ven_eries
venters103717733venter__s
venturis1138193venturi_s
vitrics12198553vit_rics

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.1561145455.1
2DLD Change Limit1461621308.09318060.3
3Display Results1301300.0632063.5
 (SQL Overall)1786911308.31221498.0
 
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.