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

157 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
eccrine113728(None) 
acarine9316002acarine
eserine7415902eserine
eucaine939242eucaine
eucrite939902eucrite
exocrine1745992exocrine
tacrine9311292tacrine
acarines10314343acarines
accrete1137843accrete
accrue1035823accr_ue
accruing1344033accruing
apocrine1246933apocrine
archine125817053archine
arcsine94512393arcsine
ascribe1147743ascribe
becrime1387053becrime
brine75132273__brine
canine83826703_canine
caprine11314233caprine
carbine112918643_carbine
caribe103416753_caribe
carina84325333_carina
carinae94318593_carinae
caring95137993_caring
carline93923613_carline
carmine112918483_carmine
carnie84421093_carnie
cering94522533_cering
cerise84822043_cerise
cerite84724873_cerite
cervine122610803cervine
chaine115119223_chaine
chine105231723__chine
chorine123218363chorine
cine66242943__c_ine
citrine92514023citrine
cline76428533__cline
cocaine111315173cocaine
conine84528553_conine
coring94433963_coring
corvine122113643_corvine
cosine83823513_cosine
crane75331603__crane
crime94822693__crime
cringe93515483__cringe
cripe95521143__cripe
crone75231333__crone
curiae84518373_curiae
curie74533043_curi_e
curing94824783_curing
curite85222943_curite
decline103716613decline
describe1346243describe
dextrine1688253dextrine
doctrine1146733doctrine
dourine8311453dourine
earing75235483e_aring
earring83519013earring
ecarte84313503ecar_te
eching126315563e_ching
echini114710433e_chini
echoing1358613echoing
ecocide1246743ecocide
ecotone938583ecotone
eerie55228533e_eri_e
elapine9310673elapine
emetine9712943emetine
emprise11310723emprise
emprize2038843emprize
enamine91214313enamine
enceinte1046263enceinte
encina8310443enc_ina
encoring11312173encoring
encrinite1146043encrinite
endocrine1246183endocrine
endrin7312403endrin_
endrins8312163endrins
engine71114863e_ngine
enshrine1147263enshrine
entwine1039143entwine
enuring8813883enuring
eocene8311613eoc_ene
eosine64519413e_osine
epergne1046143epergne
equine151711573e_quine
ermine8416923e_rmine
erne46727433e__r_ne
errhine1036593errhine
erring73816483e_rring
eserines8413743eserines
estrin6315923estrin_
estrins7315853estrins
estrone7413953estrone
etamine91313073etamine
etching134511843etching
eterne6311723eter_ne
eucaines1038513eucaines
euchring1436613euchring
eucrites1049483eucrites
examine161510033examine
excide1638423exc_ide
excise1538553exc_ise
excite15310883exc_ite
excrete1667163excrete
exine125518493e__xine
exocrines1845483exocrines
eyrie88117833e_yri_e
ferine96422583_ferine
hircine1239143hircine
incline9314643incline
larine63927043_larine
latrine7715133latrine
lemurine1046523lemurine
leporine1049303leporine
leucine938073leuc_ine
machine14313493machine
marine84230403_marine
merocrine1346233merocrine
murine84220023_murine
murrine9411483murrine
narine63422553_narine
neckline1496363neckline
nectarine1146983nectarine
neurine7311683neurine
ocarina948033ocarina
ochring13156673ochring
oscine8311563osc_ine
pecorini1246553pecorini
pecorino1246633pecorino
pelerine10313013pelerine
picrite111911313picrite
porcine11312843porcine
purine85321893_purine
recline94020493recline
sacring103115983sacring
scaring103421973scaring
sciurine1045233sciurine
scoriae9310903scoriae
scoring103117213scoring
scribe104613533_scribe
scrive115414943_scrive
securing11310413securing
serine65432673_serine
shrine94920053_shrine
tacrines10310563tacrines
taurine7311363taurine
terrine72517573terrine
trine54734603__trine
urine55026603__urine
uterine7315193uterine
vaccine1437323vaccine
vitrine102511363vitrine
zebrine1836463zebrine
zecchin2343703zecchin_
zecchini2442383zecchini
zecchino2442663zecchino
zecchins2443533zecchins

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 Limit1340271576.28021341.9
3Display Results1571570.0503140.0
 (SQL Overall)1786911576.73626527.8
 
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.