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

372 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
arenite7101771(None) 
arenites8917101arenites
arsenite8119661arsenite
aconite9315472aconite
adenine8311212adenine
agenize172910152agenize
alunite7311632alunite
amenity1238332amenity
arene55329412aren__e
arenose7311372arenose
arete56031352are__te
argentite1047812argentite
arsenate81010482arsenate
arsenide9116332arsenide
arsenites9149162arsenites
crenate93317112crenate
crinite9513632crinite
eremite9312832eremite
galenite91210062galenite
granite82017082granite
kernite1159472kernite
lenite6719982_lenite
preunite1039572preunite
recite83625112_recite
rente54733782_ren_te
resite64128452_resite
reunite7312712_reunite
sienite7312712sienite
syenite1039772syenite
uranite72515692uranite
acerate92818913acerate
acetate92514753acetate
aconites10314353aconites
adenines9310193adenines
adenitis947433adenitis
adnate72913483a_dnate
aedile73716653a_edile
aedine73218393a_edine
aerate64830553a_erate
aerie54634603a_eri_e
aerolite8315053aerolite
agemate101210583agemate
agene65621583agen__e
agenized19257733agenized
agenizes18269743agenizes
agent65829643agen_t_
agented939423agen_ted
agentive1248043agentive
agents74816293agen_ts
agnate73314883a_gnate
agnize16329563a_gnize
agonise83112693agonise
agonize172911403agonize
akene95818663aken__e
alanine7316863alanine
albite8313313a_lbite
alewife1344923alewife
alexine142410543alexine
alienate8311553alienate
allanite8411093allanite
alunites8310703alunites
amanita9310453amanita
amenities11310433amenities
ament76036543amen_t_
amentia9310153amentia
aments85219803amen_ts
aminity12310513aminity
ammonite1249143ammonite
amniote936963a_mniote
amosite9313163amosite
andesite949453andesite
anenst63514983anenst_
anent54931843anen_t_
anile54634463a__nile
anime75423203a__nime
anise55129703a__nise
ankerite1248923ankerite
ante46538903a__n_te
apatite9312963apatite
apelike13310533apelike
aphanite1348773aphanite
aplite8316393a_plite
appetite1258493appetite
arabize1849343arabize
aragonite1046463aragonite
arbiter939933ar_biter
arbute8311043ar_bute
archine125817053archine
archive154610483archive
arcsine94512393arcsine
arcuate9311963arcuate
ardent73022613arden_t_
areae55229743are__ae
areic73219393are_i_c
arena55323813aren__a
arenas65021993aren_as
arenes64928393aren_es
arenous7314183arenous
areolae7811733areolae
areolate81014453areolate
areole61017283are_ole
aretes64425353are__tes
argent74023663argen_t_
argentic1149023argentic
argentine1047893argentine
argentites1147023argentites
argents84014853argen_ts
arginine948563arginine
aridity11510113aridity
ariette7312373ariette
arise56436433ar__ise
armlike1348553armlike
armoire938133armoire
armpit10811093armpit_
armpits1157133armpits
arnica8310443ar_nica
aroint6328153aroint_
arointed939003arointed
aroints7313133aroints
arpent84822093arpen_t_
arpents93613083arpen_ts
arrive91311793ar_rive
arsenates979373arsenates
arsenic939323arseni_c
arsenics1056763arsenics
arsenides1095613arsenides
arsine64021043ar_sine
artiste73813693artiste
asinine7310723asinine
attrite7311833attrite
augite7312613a_ugite
auntie64317703a_untie
aureate72515283aure_ate
austenite945853austenite
autunite856693autunite
avenge1087553aven_ge
avenue957953aven_ue
axenic154210003axeni_c
axite125218253a__xite
azurite1638003azurite
bakelite1447253bakelite
barefit1249723barefit_
barite84224813bar__ite
bornite9311183bornite
braunite1047253braunite
brent75734133bren_t_
brents84717273bren_ts
brevity1534783brevity
carinate103320253carinate
carnie84421093car_ni_e
catenate10312833catenate
cenote83715843_cenote
cerite84724873_cerite
chedite1338863chedite
coesite9713623coesite
craniate10312563craniate
create85126383cre_ate
credit9315193credit_
credited1238253credited
credits1039973credits
cremate113816183cremate
crenated113013913crenated
crevice1436153crevice
crinites10612763crinites
cyanite122710763cyanite
denote74118043_denote
dunite7315013_dunite
dunnite857333dunnite
ebonite9310293ebonite
elite56230183__elite
enate54428153__enate
endite73817593__endite
eremites10312603eremites
erudite838483erudite
euxenite1545443euxenite
evite85317683__evite
ferrite103312753ferrite
finite9316823_finite
gahnite1135973gahnite
galenites10129183galenites
genie66124923_geni_e
granita82111303granita
granites92116363granites
grecize1935663grecize
greenie8310123greeni_e
greige847203gre_ige
grenade938413grenade
gunite7414403_gunite
harelike1539613harelike
herniae1039043herniae
herniate1148113herniate
hyenine1336953hyenine
ichnite1245983ichnite
ignite71410583_ignite
ilmenite1046223ilmenite
irenic8311103ireni_c
irenics937833irenics
ironize16610373ironize
jadeite1546403jade_ite
jarosite1548383jarosite
kainite1149543kainite
kente95821073_ken_te
kernites1269113kernites
kyanite14237313kyanite
laterite8716343laterite
lenited8812433_lenited
lenites7818443_lenites
lenity9612713_lenity
lignite81310303lignite
mannite9312903mannite
marinate103017783marinate
marlite92917073mar_lite
marmite112413993mar_mite
martensite1254413martensite
masonite1049683masonite
nite45943583___nite
oreide7311673ore_ide
ornate6315143or_nate
parakite14410423parakite
parasite10314843parasite
parent83230423paren_t_
parented11912213paren_ted
parents93418123paren_ts
partite9317133par_tite
pelite84323003_pelite
penile82219603_penile
penlite9313243_penlite
perlite9317323perlite
petite84320653_petite
phenate12412203phenate
pinite8321243_pinite
precipe133012123precipe
precise113518173precise
precited133013813precited
predate10616893predate
predive13511083predive
prefile123413183prefile
prefire124012813prefire
preinvite1485443preinvite
prelate9519693prelate
prelife1279943prelife
premie103617993premi_e
premise113818553premise
prename11412643prename
prentice121012353prentice
preside10715613preside
preunited1246803preunited
preunites1138933preunites
previse123713793previse
prewire124311143prewire
pronate9418873pronate
rarebit948423rarebit_
rarebits1045223rarebits
rareripe1045113rareripe
ratite65022423_ratite
rebate84424113_rebate
recipe103414893_recipe
recit75235103_recit_
recited104319103_recited
reciter94117263_reciter
recites93524583_recites
recits83621353_recits
redate74124683_redate
rediae74221993_rediae
refile95122373_refile
refine95225693_refine
refire95419473_refire
refit84230063_refit_
refits94017653_refits
refute95515703_refute
regime95313943_regime
regive104814323_regive
rehire95415863_rehire
reignite947233_reignite
reincite1089703_reincite
reinter73116843_reinter
reinvite1177753_reinvite
reive85522943_re_ive
reknit10312533_reknit_
reknits1137073_reknits
relate64033633_relate
reline65434353_reline
relit55340683_relit_
relive95120783_relive
remate84428683_remate
remise84221953_remise
remit75737223_remit_
remits85622943_remits
remote84222603_remote
rename82718813_rename
renege72713763_renege
renig64518913_reni_g
renigs74314593_renigs
renin54830033_reni_n
renins64526453_renins
renitent8315333_renitent
rennet64624853_rennet
rent46661243_ren_t_
rented74426593_ren_ted
renter64527413_ren_ter
rentes65431193_ren_tes
rentier73618223_rentier
rents55935183_ren_ts
repine85627813_repine
repute84716093_repute
requite162012483_requite
rerise64325633_rerise
reside74224933_reside
resile64627673_resile
resit54241043_resit_
resited85122423_resited
resites74027793_resites
resits64725563_resits
resize154117723_resize
respite9513033_respite
rete44944133_re__te
retie55735303_reti_e
retile65929673_retile
retime85321803_retime
retine66237333_retine
retinite8314853_retinite
retire64927013_retire
retitle73913093_retitle
reunited939713_reunited
reuniter838323_reuniter
reunites8312473_reunites
revile94921613_revile
revise94019743_revise
revive124914823_revive
revote94917453_revote
rewire95421413_rewire
rewrite10311143_rewrite
rexine134719443_rexine
rite45849453_r__ite
saponite10410533saponite
selenite81713113selenite
senate63725173_senate
senile63420213_senile
seniti64317223_seniti
sente56432883_sen_te
serenate81914883serenate
serenity1168963serenity
sienites8311913sienites
sternite8310543sternite
syenites1138943syenites
taconite1049313taconite
taeniae739083taeniae
teniae64517353_teniae
tentie62521183_tentie
tergite8311003tergite
termite9313893termite
ternate7415483ternate
trinity10310843trinity
trite54730033tr__ite
ulexite1445723ulexite
unite54828383__unite
uralite71714103uralite
uranide82212093uranide
uranites82514643uranites
urbanite1097183urbanite
ureide7310363ure_ide
urinate7315363urinate
venine93718433_venine
venire93513693_venire
verite94323443_verite
weenie92612023weeni_e
wienie9229973wieni_e
write85522833wr__ite
yente86220043_yen_te
yperite1249893yperite
zaratite1747793zaratite
zenith1839073_zenith

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 Limit1340273726.76619808.9
3Display Results3723720.1402657.1
 (SQL Overall)1786913727.30924448.1
 
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.