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

270 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
arseno631891(None) 
arsino64113511arsino
absent84016992absent
ardent73022612ardent
arena55323812ar_ena
arene55329412ar_ene
argent74023662argent
arisen65316792arisen_
arpen74418042arpen_
arpens84814822arpens
arpent84822092arpent
arse46539272arse__
arsenal739382arsenal
arsenic939322arsenic
arsenous847532arsenous
arses55733872arse_s
arsine64021042arsine
arson55118832arson_
arsons63917212arsons
assent65119952assent
sarsen6314232sarsen_
sarsens7311392sarsens
abseil837183abseil
absence1137703absence
absents93510723absents
accent105116263accent
achene11313813achene
addend9458453addend
admen84516183admen_
advent102613753advent
aeon45634613a__eon
aero45435343a__ero
agene65621583a_gene
agent65829643a_gent
airmen82612353airmen_
akene95818663a_kene
albedo956123albedo
albino839933albino
alien56425583alien_
alienor7116303alienor
aliens65619213aliens
alkene104114003alkene
also46423443als__o
amen66733153a_men_
amend85717753a_mend
amens75624843a_mens
ament76036543a_ment
amino75425503a_mino
ammino1069883ammino
ammono1047373ammono
anent54931843a_nent
append1138273append
apse67725383apse__
apses76823913apse_s
arcana8912583arcana
arcane81216743arcane
arced88224163arce_d
archon11311753archon
arcing95819643arcing
arco68331543ar__co
arcsine94512393arcsine
ardeb8314523arde_b
ardebs937013ardebs
ardency1346483ardency
are37874573ar_e__
area45843393ar_e_a
areae55229743ar_eae
areal55928733ar_eal
areas55935773ar_eas
areca75618633ar_eca
areic73219393ar_eic
arenas65021993ar_enas
arenes64928393ar_enes
arenose7311373ar_enose
arenous7314183ar_enous
arepa75615563ar_epa
ares45871023ar_e_s
arete56031353ar_ete
argents84014853argents
argon65520593argon_
argons75018203argons
ariel55228973arie_l
ariels65119373ariels
arioso64312403arioso
arise56436433arise__
arises65233803arise_s
arising83619973arising
aristo6414033aristo
arles56735743arle_s
armed86324433arme_d
armer76924443arme_r
armers85520273armers
armet76739453arme_t
armets84918353armets
arming94719803arming
aroint6328153aroint
arose55832083arose__
around72712413around
aroynt9312893aroynt
arpents93613083arpents
arrant6623253arrant
arrear6310253arrear
arrest63722633arrest
arroyo936963arroyo
ars37670933ars___
arsenals847733arsenals
arsenate81010483arsenate
arsenics1056763arsenics
arsenide9116333arsenide
arsenious945223arsenious
arsenite8119663arsenite
arshin9312173arshin
arshins10312573arshins
arsines73518813arsines
arsis55722423ars_is
arsonous846393arsonous
artel56122743arte_l
artels66216233artels
artery9911453artery
arvo76023433ar__vo
asana5315483a_sana
ascend9429733ascend
ascent84519653ascent
asea46327183a_se_a
ashen87818673ashen_
aspen75216093aspen_
aspens85013353aspens
assentor865293assentor
assents74512223assents
assert64922573assert
asses55629283asse_s
assess65710463assess
asset55932263asse_t
assets65617663assets
attend7258973attend
attent62818323attent
augend837633augend
ausubo853653ausubo
avens86419333a_vens
axmen145112273axmen_
axseed1456993axseed
barmen105418533barmen_
barren85317613barren_
barrens94414323barrens
bartend1038753bartend
bren65629563br_en_
brens75823363br_ens
brent75734133br_ent
careen84119493careen_
careens94514703careens
carmen104019343carmen_
carse74934333carse__
carses85233653carse_s
carven114716663carven_
casino84317553casino
cassena9287843cassena
cassene93111543cassene
cassino93512433cassino
coarsen93210323coarsen_
coarsens10348123coarsens
credo84815563cr_edo
darken114013443darken_
darkens12409873darkens
erenow937373er_enow
erses55826803erse_s
fraena938063fraena
frena85915273fr_ena
fresco1136473fresco
friend10388933friend
garden84215083garden_
gardens93312093gardens
garment10315233garment
green65522143green_
greens75716873greens
greeny104811453greeny
grego7310523gr_ego
harden105718533harden_
hardens113815023hardens
harken135116343harken_
harkens144112863harkens
harshen1339283harshen_
harshens1437603harshens
hausen9610383hausen_
hausens1077633hausens
hoarsen10367993hoarsen_
hoarsens11306023hoarsens
hosen85623883hosen_
keno87926433__keno
larceny1234853larceny
leno47331393__leno
marengo1035263mar_engo
margent10316693margent
marrano939423marrano
marse76231153marse__
marses84827113marse_s
marten84518263marten_
martens93714953martens
meno66031353__meno
oarsmen938093oarsmen_
orient6322533orient
owsen84210193owsen_
paesano9338793paesano
paisano9429513paisano
parent83230423par_ent
pareo74632603par_e_o
parse75236993parse__
parsec105914483parse_c
parsecs11429923parsecs
parsed96323893parse_d
parser84822373parse_r
parsers94118153parsers
parses85534703parse_s
parsing103819553parsing
parson83817903parson_
parsons93516873parsons
parvenu1247023parvenu
paseo77022513pase_o
preen75925053preen_
preens85020113preens
present94022733present
presto84216203presto
ramen75625193ramen_
rase46149983rase__
rased65033933rase_d
raser55633413rase_r
rasers64526783rasers
rases55447213rase_s
rasing74330833rasing
raven84723443raven_
ravens93916883ravens
redo56029363_r_edo
rend56136573_r_end
rent46661243_r_ent
repo66027543_r_epo
resend75016773resend
resent63833623resent
rhino84614323_rhino
risen54621883risen_
sarment9318763sarment
sarsenet8412943sarsenet
sarsnet7314813sarsnet
segno64814743__segno
sego56525183__sego
sen36058523__sen_
send55237293__send
sene46848053__sene
senor53822793__senor
sent46963013__sent
steno54716863_steno
treen55622753treen_
treens65317873treens
trend64817453tr_end
triene64316383triene
triens65417543triens
unsent63820963unsent
upsend9356883upsend
upsent83314063upsent
uredo65112993ur_edo
urgent73816043urgent
ursine64114123ursine
varment12313243varment
warden104515513warden_
wardens113711903wardens
warren95012853warren_
warrens103810893warrens
wisent93516343wisent
worsen95513873worsen_
worsens104610263worsens
wren78221683wr_en_
wrens85016243wr_ens

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162707.40615219.6
3Display Results2702700.0932903.2
 (SQL Overall)1786912707.63923391.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.