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

257 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
sienite731271(None) 
sienites8311911sienites
syenite1039771syenite
arenite71017712arenite
finite9316822fi_nite
ignite71410582_ignite
lenite6719982_lenite
lignite81310302lignite
pinite8321242pi_nite
selenite81713102selenite
senate63725172s_enate
senile63420212s_enile
seniti64317222s_eniti
sente56432882s_en_te
siderite9411362siderite
sternite8310542sternite
stibnite1044072stibnite
syenites1138942syenites
wienie9229972wieni_e
aconite9315473aconite
adenine8311213adenine
agenize172910153agenize
alienate8311553alienate
alunite7311633alunite
amenity1238333amenity
arenites8917103arenites
arsenite8119663arsenite
asinine7310723asi_nine
austenite945853austenite
binate8419773bi_nate
binit76431583bi_nit_
binits85716673bi_nits
biotite9311033biotite
bornite9311183bornite
cenote83715843_cenote
cerite84724873_cerite
chedite1338863chedite
coesite9713623coesite
crenate93317113crenate
crinite9513633crinite
cyanite122710763cyanite
denote74118043_denote
diene65720133dien__e
dignity1236453dignity
dinette8310013dinette
diorite8314913diorite
disunite999303disunite
dunite7315013_dunite
dunnite857333dunnite
ebonite9310293ebonite
elite56230183__elite
enate54428153__enate
endite73817593__endite
eremite9312833eremite
essonite845733essonite
euxenite1545443euxenite
evite85317683__evite
finites10315923fi_nites
finito9310303fi_nito
gahnite1135973gahnite
galenite91210063galenite
genie66124923_geni_e
granite82017083granite
gunite7414403_gunite
heinie92512663heini_e
hiddenite1442803hiddenite
hyenine1336953hyenine
ichnite1245983ichnite
ignited9137623_ignited
igniter8147673_igniter
ignites81310583_ignites
illite63414923_illite
ilmenite1046223ilmenite
incite83618733_incite
indite73520323_indite
innate63917313_innate
invite93715033_invite
iolite63221983_iolite
ionise63516943_ionise
ionize154613873_ionize
kainite1149543kainite
kente95821073_ken_te
kernite1159473kernite
kyanite14237313kyanite
lenited8812433_lenited
lenites7818443_lenites
lenity9612713_lenity
licente91210893licen_te
lignites9129613lignites
limonite1048163limonite
lineate7815153lineate
lionise7310373lionise
lionize1668823lionize
lisente71210703lisen_te
mannite9312903mannite
meinie82614523meini_e
mimetite1247603mimetite
minute83414293mi_nute
miscite11314383miscite
niobite937953niobite
nite45943583___nite
nitrite72314463nitrite
olivenite1243563olivenite
pelite84323003_pelite
penile82219603_penile
penlite9313243_penlite
petite84320653_petite
phenate12412193phenate
picrite111911313picrite
pigeonite1244183pigeonite
pinites9319533pi_nites
pinnate93613743pinnate
preunite1039573preunite
recite83625113_recite
reignite947233reignite
reincite1089703reincite
reinvite1177753reinvite
rente54733783_ren_te
resite64128453_resite
reunite7312713reunite
samite83020603s_amite
sanity9316203s_anity
saponite10410533saponite
scene77220573scen__e
scenic10510513sceni_c
scenics1137773scenics
scent75831623scen_t_
scented102811883scen_ted
scents85317023scen_ts
science1138783scien_ce
scientize2044373scientize
sclerite10410713sclerite
sedate73019813s_edate
sedile73517233s_edile
seine55732873s_e_ine
seining84020773seining
seise54727853s_e_ise
seize143819503s_e_ize
selenate81712523selenate
selenide9158863selenide
selenites91312083selenites
senates73322613s_enates
sene46848053s_en__e
seniles72618023s_eniles
senior63214053s_enior
sennet64224143s_ennet
sennit63117923sennit_
sennits73811283sennits
sensate7311893s_ensate
sense55526823s_en_se
sent46963013s_en_t_
senti56226703s_en_ti
serenate81914883serenate
serenity1168963serenity
seriate73722473s_eriate
serine65432673s_erine
sheenie10159493sheeni_e
sheltie10109913sheltie
shent85933503shen_t_
sickie123715743sicki_e
sideline91011093sideline
siderites10410433siderites
sidewise1245353sidewise
siege66718443sie__ge
sieging92613203sieging
sienna647193sien_na
siennas736123siennas
siesta639503sie_sta
sieve84918843sie__ve
sieving112311233sieving
sigmate10710143sigmate
signage937773signage
signee73617233sign_ee
signet73621153signet_
signeted1035973signeted
signets83311503signets
signify1444853signify
signing92713963signing
signior835043signior
signore8329093signore
silence9310213silen_ce
sileni63312143sileni__
silent64125843silen_t_
silenter838873silen_ter
silents73514493silen_ts
silkie103313403silki_e
simile83115633si_mile
simonize1947813simonize
since75024173si_n_ce
sine46560623si_n__e
singe65731133si_n_ge
single74520603si_ngle
sinister838583si_nister
sinning83918443sinning
sinter63625923si_n_ter
sinuate7412163sinuate
sirenian845783sirenian
sirvente1145023sirven_te
site47052413s___ite
situate7410783situate
sixte126216583si__xte
skene96118123sken__e
skite95120053s__kite
slainte738543slainte
smectite1245773smectite
smite75224873s__mite
snide64318723s__nide
snipe75320573s__nipe
snit46342473s__nit_
snits54124833s__nits
somite84519373s_omite
sopite84917713s_opite
speciate12209583speciate
specie10412223speci_e
speise84614253spe_ise
spence103813793spen_ce
spense83912433spen_se
spent75532833spen_t_
spinate93114813spinate
spite75430663s__pite
sprite84421773s_prite
stanine73417073stanine
stannite847583stannite
steatite8310583steatite
stellite839533stellite
stent55634513sten_t_
stents65019453sten_ts
sterile7316603sterile
sternites9310073sternites
stibnites1144043stibnites
stilbite1045423stilbite
stylite10219613stylite
subsite9412873subsite
suite54829563s__uite
sulfite10310473sulfite
svelte9319753sve_lte
sweetie10157873sweetie
syenitic1346743syenitic
sylvite13266353sylvite
taeniae739083taeniae
teniae64517353_teniae
tentie62521183_tentie
tillite7313563tillite
titanite898433titanite
ulexite1445723ulexite
unite54828383__unite
uranite72515693uranite
venine93718433_venine
venire93513693_venire
verite94323443_verite
weenie92612023weeni_e
wienies102213683wienies
yente86220043_yen_te
yperite1249893yperite
zenith1839073_zenith
zincite1837233zincite
zinkenite2242743zinkenite

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.403443402.0
2DLD Change Limit1340272576.70619986.1
3Display Results2572570.0932763.4
 (SQL Overall)1786912577.20224811.3
 
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.