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

200 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
silences10310071silences
silenter838871silenter
silentest948101silentest
silents73514491silent_s
selenates91611352selenates
selenites91312082selenites
sienites8311912si_enites
silanes72517162silan_es
silence9310212silence_
silenced1136272silenced
silencer1036292silencer
silencers1145282silencers
silent64125842silent__
silently1147482silently
silentness1044572silentness
silenus7369692silen_us
silexes1438652sile_xes
sirventes1244902sirventes
sklented1335052sklented
sklents11348162sklent_s
splents93912132splent_s
ailments1039433ailment_s
alienates9310683alienates
alienees8118653alienees
atlantes838553atlantes
blendes104713683_blendes
boletes9316063bole_tes
celestes10310013celestes
ciliates10413453ciliates
clients938093client_s
deletes83117933dele_tes
detentes92712873detentes
dienes75719903di_en_es
dilates83220663dil_ates
diluents946053diluent_s
dilutes82911973dil_utes
dinettes9310193dinettes
ententes8312773ententes
filenames1444293filenames
fileted1159093file_ted
filets94718953file_t_s
filiates11412663filiates
flenses1039473_flenses
galenites10129183galenites
galettes93111153galettes
gentes75324163__gentes
gillnets934733gillnets
ideates8313733_ideates
ileitis738063_ileitis
ileuses738673_ileuses
ilexes134510253_ile_xes
illites72415013_illites
ilmenites1146103_ilmenites
isleted837523isle_ted
islets64513083isle_t_s
kentes105118653__kentes
lenes54738523__len_es
lenites7818443__lenites
lenses64620893__lenses
lenten6312883__lenten
lentos65317403__lentos
licences12129323licences
licenses10118923licenses
licente91210893licente_
lisente71210703lisente_
maleates103316343maleates
mileages11249693mileages
misenter10310833misenter
misenters1139533misenters
oleates7417833_oleates
palettes103112833palettes
pileate93815923pileate_
pileated112711133pileated
pimentos1246233pimentos
pinenes93416673pinen_es
pipettes1237563pipettes
plenties10314693_plenties
polentas1038743polentas
relented92614943relented
relents74018503relent_s
rentes65431193__rentes
rillettes946533rillettes
saliences11108063saliences
salients839563salient_s
salines74029413salin_es
salutes73716253sal_utes
scenes84520353s_cen_es
scented102811883s_cented
scents85317023s_cent_s
sciences1238773sciences
sclerites1139443sclerites
seicentos1144553seicentos
selected1159783selected
selectee10910493selectee
selectees1147013selectees
selects91912143select_s
selenate81712523selenate_
selenides10178193selenides
selenite81713103selenite_
selenoses947463selenoses
selenous848973selenous
senates73322613s__enates
senses63923943s__enses
sente56432883s__ente_
serenes73222903seren_es
sevenths1444793sevenths
seventies1249673seventies
sheenies111411543sheenies
siderites10410433siderites
sidestep1144243sidestep
sidesteps1243623sidesteps
sieges73816833si_e_ges
sienite7312713si_enite_
siennas736123si_ennas
siestas738813si_estas
sieves93216003si_e_ves
signees83510803si_gnees
signeted1035973signeted
signets83311503signet_s
silages82514443sil_ages
silane62718053silan_e_
sileni63312143silen__i
silesias848523silesias
silicates11311523silicates
silicles1037073silicles
siliques1745353siliques
silkies113715693sil_kies
sillies73425083sil_lies
silted74020013sil__ted
silts55330823sil__t_s
silvexes1843633silvexes
simonies10311113simonies
sines55954823si__n_es
singes74326853si__nges
sinter63625923si__nter
sinters74024083si__nters
sinuates8310963sinuates
sirees64624583sire__es
sirens65318153siren__s
sirvente1145023sirvente_
sites56045433si___tes
situates8310373situates
sixpences2043633sixpences
sixtes133612403si__xtes
skenes104616633s_ken_es
sklent103614353sklent__
slanted83514743s_lanted
slants64819083s_lant_s
slates64934063s_l_ates
sleaves103813203s_leaves
sleazes162810333s_leazes
sledges94511573s_ledges
sleeted83113223s_leeted
sleets64318873s_leet_s
sleeves103311343s_leeves
slender83413593s_lender
sleuths1034743s_leuths
slieves10378963slie_ves
solates73523853sol_ates
soleness8814263soleness
solerets839693solerets
soleuses838073soleuses
solonets838233solonets
solutes73515263sol_utes
solvates11249673solvates
solvents1136763solvent_s
spences113413923s_pences
spenses92913573s_penses
sphenes123013163sphen_es
splenius1046033splenius
splent84720193splent__
splines94718893splin_es
splinted11369253splinted
splinter10329703splinter
splinters11277923splinters
splints94511743splint_s
stents65019453s_tent_s
stilbenes1143933stilben_es
stilbites1144833stilbites
stilettoes1052583stilettoes
stilettos943443stilettos
sulfates11310793sulfates
sulfites1139903sulfites
sweenies11148763sweenies
syenites1138943s_yenites
sylvites14225843sylvites
syrettes1136963syrettes
talented938423talented
talents7312013talent_s
tillites8312833tillites
toilettes946023toilettes
trientes82812123trientes
valences1388513valences
videttes1266333videttes
vileness1139983vileness
violences1445493violences
wienies102213683wi_enies
wisents10249063wisent_s
xylenes1745093xylen_es
yentes95517603__yentes

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622007.09320606.5
3Display Results2002000.0762631.6
 (SQL Overall)1786912007.59223536.7
 
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.