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

486 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
terrine7251757(None) 
terrane72814231terrane
terrene72411031terrene
terrines82117551terrines
berline93716852berline
cervine122610802cervine
ermine8416922_ermine
errhine1036592_errhine
erring73816482_erring
ferine96422582fe_rine
ferrite103312752ferrite
heroine103517492heroine
herring113615882herring
murrine9411482murrine
nervine102510632nervine
neurine7311682neurine
serine65432672se_rine
stearine8311902stearine
tacrine9311292tacrine
tarring83318302tarring
taurine7311362taurine
tearing84021492tearing
tergite8311002tergite
terming104016002terming
termini93410812termini
termite9313892termite
terne56426152te_r_ne
terpene92310862terpene
terrace93311842terrace
terrae62915212terr_ae
terrain7410852terrain_
terrains8410322terrains
terranes82514432terranes
terreen7257572terreen
terrenes82212602terrenes
terrible1046642terrible
terrier73414962terrier
terries73425632terries
terrify1336352terrify
territ63421382terri_t
territs72714502territs
trine54734602t__rine
turbine9310302turbine
turdine8310282turdine
uterine7315192ute_rine
versine102515172versine
zebrine1836462zebrine
acarine9316003acarine
aedine73218393ae_dine
aerie54634603ae_ri_e
airline7315033airline
arrive91311793_arrive
arsine64021043_arsine
atabrine1045203atabrine
averring12239063averring
barring104021593barring
bearing103624773bearing
becrime1387053becrime
beeline93314723beeline
befringe1484513befringe
begrime1276553begrime
beguine1068503beguine
benzine1839343benzine
berberine1346523berberine
berime105317333be_rime
berlin83116373berlin_
berlines102315453berlines
berlins93216013berlins
berming123614833berming
berried103714053berried
berries94423553berries
berrying14137383berrying
beryline1337083beryline
betaine9413783betaine
birring103713063birring
brine75132273__brine
burring104016993burring
caprine11314233caprine
carbine112918643carbine
carline93923623carline
carmine112918483carmine
cering94522533ce_ring
cerise84822043ce_rise
cerite84724873ce_rite
chorine123218363chorine
citrine92514023citrine
corrie83621233corri_e
corvine122113643corvine
curarine10610713curarine
currie84317263curri_e
curring103616843curring
dearie73319813deari_e
debride1138593debride
decline103716613decline
define104718143de_fine
delaine8314793delaine
dentine83320243dentine
deprive1338303deprive
deride84420033de_ride
derive103817043de_rive
derrick1435803derrick
derriere936043derriere
derries83124623derries
derringer1144593derringer
derris73615273derri_s
derrises93012783derrises
destine83719953destine
determine1249033determine
deterring1138623deterring
dextrine1688253dextrine
dourine8311453dourine
durrie73713263durri_e
earing75235483_earing
earring83519013earring
eccrine1137283eccrine
eerie55228533_eeri_e
engine71114863_engine
eosine64519413_eosine
equine151711573_equine
ermined10410603_ermined
ermines9416673_ermines
erne46727433_e_r_ne
errand758793_errand
errant6618733_errant
errhines1136413_errhines
eserine7415903eserine
etamine91313073etamine
eterne6311723eter_ne
eternise8119663eternise
eternize17118363eternize
exine125518493_e_xine
extermine1848283extermine
eyrie88117833_eyri_e
fearing113520033fearing
febrile1237153febrile
feirie939553feiri_e
feline94820143fe_line
feriae95618603fe_riae
ferlie92814053ferli_e
ferrate103014043ferrate
ferriage1245463ferriage
ferric1139993ferri_c
ferried113411533ferried
ferries103521083ferries
ferrites112312833ferrites
ferrule1035863ferrule
ferrying15146253ferrying
fertile10311733fertile
furriner11267303furriner
furring114013143furring
garring93116713garring
gearing92818843gearing
genuine838373genuine
germane1049663germane
germina1038503germina
harmine122816193harmine
hearing113324163hearing
heiring113312903heiring
hemline12311073hemline
herding122915123herding
herein93717793herein_
herniae1039043herniae
heroin94420593heroin_
heroines112916573heroines
heroins103518013heroins
heroize193210973heroize
herried113514473herried
herries104025083herries
herrings12379533herrings
herrying15147033herrying
hircine1239143hircine
interline91218013interline
interring10315423interring
jarring153613193jarring
jeering153513043jeering
jerkin17258113jerkin_
jerking19308923jerking
jerkins18358253jerkins
jerrid14259143jerri_d
jerrids15277743jerrids
jerries143817513jerries
kerbing14308483kerbing
kerfing15307533kerfing
kerne94718223ke_r_ne
kerning124010893kerning
kernite1159473kernite
kerosine1238153kerosine
kerria10339923kerri_a
kerrias11289513kerrias
kerries113317913kerries
larine63927043_larine
latrine7715133latrine
leering83417643leering
lemurine1046523lemurine
leonine7311233leonine
leporine1049303leporine
leucine938073leucine
marine84230413_marine
marline93320973marline
marring103319553marring
merging112711763merging
merino8315093me_rino
merlin83916683merlin_
merlins93015813merlins
merocrine1346233merocrine
merrier92612303merrier
merrily1238633merrily
merriness1138293merriness
metring103215293metring
moraine9314573moraine
murine84220023_murine
murrhine1344313murrhine
nardine82712573nardine
narine63422553_narine
nearing83020333nearing
nervines112310463nervines
nerving112910833nerving
neurines8311193neurines
neurone739443neurone
orpine83914483_orpine
orrice81410163_orrice
overmine13313663overmine
override121512523override
overrife14169933overrife
overripe131410383overripe
pardine103616733pardine
parring103222063parring
peerie83617893peeri_e
peering103520353peering
pelerine10313013pelerine
pennine93712953pennine
pepsine11310603pepsine
perdie94718513perdi_e
peregrine1247043peregrine
perinea9313043pe_rinea
perking143716463perking
perlite9317323perlite
perming123416093perming
perries93226603perries
perron83216623perron_
perrons93115483perrons
porcine11312843porcine
prerinse1038633prerinse
pteridine1246743pteridine
pterin81014153pte_rin_
pterins9812993pte_rins
purine85321893_purine
purline93516533purline
purring104515823purring
quercine1964863quercine
rearing83128783rearing
recline94020493recline
redline84218833redline
redrive112410563redrive
refine95225693re_fine
regrind938983regrind
reline65434353re_line
repine85627813re_pine
reprice113212833reprice
reprint9318983reprint
reprise92715043reprise
reraise7316313reraise
rerise64325633re_rise
reshine102816943reshine
retine66237333re_tine
rewrite10311143rewrite
rexine134719443re_xine
sardine83317393sardine
searing83330923searing
seine55732873se__ine
serein63318463serein_
sereins73716123sereins
serene63522353se_rene
serging93416673serging
serin55434443se_rin_
serines74229543se_rines
sering74731813se_ring
serins64029673se_rins
serotine8313573serotine
serrano768463serrano
serrate73017543serrate
serried82513973serried
serries73925353serries
serrying12167703serrying
service1239093service
servile10310643servile
serving113014983serving
sestine73017923sestine
setline7313923setline
shrine94920053_shrine
sordine82515233sordine
spermine12311433spermine
starring92312953starring
stearin7312003stearin_
stearines9311283stearines
stearins8312143stearins
steering93916793steering
sterile7316603ste_rile
sterling93615553sterling
sternite8310543sternite
stirring9299653stirring
taborine102510683taborine
tacrines10310563tacrines
tagline82412453tagline
tardive1136893tardive
taring73932283t_aring
tarre55825633tarr__e
tarriance1144273tarriance
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
tarriness9229253tarriness
tarrying12146723tarrying
tarting84222653tarting
taurines8310553taurines
tealike111111083tealike
teaming103917593teaming
tearier73815613tearier
tearily10311153tearily
teariness9310633teariness
teasing83918513teasing
teatime9310083teatime
techie11511723techi_e
tectite9310583tectite
tedding103210883tedding
teeing73916973te_eing
teeming103513093teeming
tegmina1035243tegmina
teind6213613te__ind
tekkie934203tekki_e
tektite1136883tektite
telling83321093telling
temping122710693temping
tending94419163tending
teniae64517353te_niae
tenorite8311993tenorite
tenpin8310583tenpin_
tenpins9410073tenpins
tensile72612733tensile
tensing84616653tensing
tensive10269913tensive
tentie62521183tenti_e
tenting84621153tenting
tenuring938863tenuring
teosinte845543teosinte
tephrite1346593tephrite
terai53525483terai__
terais64023513terai_s
terbia8311163terbi_a
terbias9310743terbias
terbic10410963terbi_c
terbium1147293terbium
terce75721843te_r_ce
terebene1045363terebene
teredines1049453teredines
terete6319333te_rete
tergites9310543tergites
terminal1039733terminal
terminate11411203terminate
terminus1037393terminus
termites10313693termites
termtime1244773termtime
tern46134803te_r_n_
ternate7415483ternate
ternes65422903te_r_nes
ternion739493ternion
ternions838813ternions
terns55226873te_r_ns
terpenes102111573terpenes
terpineol1142173terpineol
terpinol1044073terpinol
terra54419673terr__a
terraced11318133terraced
terraces102712253terraces
terracing1237703terracing
terrapin1046203terrapin_
terrapins1146183terrapins
terras63516973terr_as
terrases82111483terrases
terreens8246533terreens
terrenely1243853terrenely
terret63425623terr_et
terrets72913583terrets
terribly1344923terribly
terriers84210823terriers
terrific1344803terrific
terrified13147583terrified
terrifier12126603terrifier
terrifies12139723terrifies
terror63811733terr_or
terrorise997173terrorise
terrorize1887083terrorize
terrors73112213terrors
terry84721873terr__y
terse55026823te_r_se
tertial7313863tertial
tertian7511193tertian
tertians839103tertians
terylene1144153terylene
testing86021053testing
tetri52716453tetri__
tetris62816293tetri_s
tetrode839343tetrode
tewing103914823te_wing
textile1437223textile
thebaine1355433thebaine
theine94814923t_heine
theorise1137873theorise
theorize2047073theorize
therein102310353therein_
thermite1339033thermite
thine85026863t__hine
thorite10313443thorite
thrice114311573t_hrice
thrive125313223t_hrive
throne98517603t_hrone
thymine1536643thymine
tiering8315253tiering
tine45855143t___ine
tiring74023093t_iring
tirling83315733tirling
tirrivee1143613tirrivee
tontine72316143tontine
topline92313183topline
torrent7313413torrent
torrid7311853torri_d
torrider936173torrider
torrify1335013torrify
tortile7313193tortile
touring82915193touring
towline102911543towline
toxine133114123t_oxine
train56529113t_rain_
trained84117203t_rained
trainee72817793t_rainee
trainer73316793t_rainer
trains64725343t_rains
treeing83414303treeing
trephine1338933trephine
tribe74420273t__ribe
trice75127493t__rice
triene64316383t_riene
trike95320163t__rike
trined74920713t__rined
trines64132563t__rines
tripe75425383t__ripe
trite54730033t__rite
triune64210183t_riune
trone55131863t__rone
tropine93116653tropine
truing73913933t_ruing
trying104214073t_rying
tsarina736653tsarina
turbines1039903turbines
turfing113010053turfing
turgite837973turgite
turning83713183turning
twine85822363t__wine
tyramine1347303tyramine
tyring104613023t_yring
tyrosine1147043tyrosine
tzarina1635053tzarina
unerring9311273unerring
urine55026603__urine
ursine64114123_ursine
veering113213683veering
venine93718433ve_nine
veratrine1247753veratrine
verbile1249863verbile
verdin103113023verdin_
verdins112812333verdins
verging123812303verging
verite94323443ve_rite
vermin113414523vermin_
versines112213823versines
versing112314193versing
vespine1237903vespine
vitrine102511363vitrine
viverrine1544673viverrine
warring113717973warring
waterline1249663waterline
wearing113318863wearing
yerking15368813yerking
yirring11307763yirring
zebrines1935883zebrines
zeroing1738343zeroing

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.406440125.6
2DLD Change Limit1340274867.86017051.8
3Display Results4864860.1862612.9
 (SQL Overall)1786914868.45221141.9
 
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.