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

165 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
silences1031007(None) 
silence9310211silence_
silenced1136271silenced
silencer1036291silencer
silencers1145281silencers
licences12129322licences
saliences11108062saliences
sciences1238772sciences
silanes72517162silan_es
silenter838872silenter
silentest948102silentest
silents73514492silen_ts
silenus7369692silen_us
silexes1438652sile_xes
sixpences2043632sixpences
spences113413922s_pences
valences1388512valences
violences1445492violences
absences1247673absences
alienees8118653alienees
balances1279973balances
bivalences17104343bivalences
blenches153310763_blenches
blendes104713683_blendes
cadences1338473cadences
cilices113814023cil_ices
clenches152910953_clenches
defences1439633defences
desinences1347213desinences
dienes75719903di_en_es
diligences1444333diligences
divalences16114773divalences
eminences1347403eminences
essences1047563essences
evidences1556333evidences
exigences1946323exigences
faiences1337043faiences
fences114617113__fences
fiances12310673fi_ances
filenames1444293filenames
finances1338653finances
fleeces12399643_fleeces
flenches163410533_flenches
flenses1039473_flenses
glances104113143_glances
ileuses738673_ileuses
ilexes134510253_ile_xes
insolences1247113insolences
lances84824103__lances
lenes54738523__len_es
lenses64620893__lenses
licence11119363licence_
licenced13145773licenced
licencee12116463licencee
licencees13134643licencees
licencer12146133licencer
licencers13134643licencers
licenses10118923licenses
lucences12137313lucences
mileages11249693mileages
minces104420803mi__nces
nieces84112713ni_e_ces
offences1645023offences
opulences1345093opulences
pestilences1544693pestilences
pieces104217273pi_e_ces
pierces113411193pi_erces
pinenes93416673pinen_es
plenches153110623_plenches
potences12710693potences
refences13311843refences
residences1368233residences
resiliences1375243resiliences
salience10117903salience_
saliencies1246133saliencies
salines74029413salin_es
sapiences13116423sapiences
scenes84520353s_cen_es
science1138783science_
scoleces1237083scole_ces
sconces113811453s_conces
seances93015343s_eances
selects91912143sele_cts
selenates91611363selenates
selenides10178203selenides
selenites91312093selenites
selenoses947463selenoses
selenous848973selenous
senses63923943s__enses
sentences11610303sentences
sequences2067013sequences
serenes73222903seren_es
sheenies111411543sheenies
sibilances1494413sibilances
sices75637273si___ces
sieges73816833si_e_ges
sienites8311913si_enites
siennas736123si_ennas
sieves93216003si_e_ves
signees83510803si_gnees
silages82514443sil_ages
silane62718053silan_e_
silencing1245053silencing
sileni63312143silen__i
silent64125843silen__t
silently1147483silently
silentness1044573silentness
silesias848523silesias
silicas9310603sil_icas
silicles1037073silicles
siliques1745353siliques
silkies113715693sil_kies
sillies73425083sil_lies
silvexes1843633silvexes
silvics1235563silvic_s
simonies10311113simonies
since75024173si__nce_
sines55954823si__n_es
singes74326853si__nges
sirees64624583sire__es
sirens65318153siren__s
sirventes1244903sirventes
sithence1344793sithence_
sixpence1943543sixpence_
skenes104616633s_ken_es
sklented1335053sklented
sklents11348163sklen_ts
sleaves103813203s_leaves
sleazes162810333s_leazes
sledges94511573s_ledges
sleeves103311343s_leeves
slender83413593s_lender
slices84022853s_l_ices
slieves10378963slie_ves
sluices959073s_luices
solaces93116133sol_aces
soleness8814263soleness
soleuses838073soleuses
solvencies1544803solvencies
sonances10310263sonances
spence103813793s_pence_
spencer113610973s_pencer
spencers12269193s_pencers
spenses92913573s_penses
sphenes123013163sphen_es
splenius1046033splenius
splents93912133splen_ts
splices113914383spl_ices
splines94718893splin_es
stances93715963s_tances
stenches132110293s_tenches
stilbenes1143933stilben_es
stridences1344733stridences
sweenies11148763sweenies
tierces93710453ti_erces
unfences1337933unfences
valances1398763valances
valence1268773valence_
valencies1446413valencies
vileness1139983vileness
violence1345713violence_
virulences1543853virulences
wienies102213683wi_enies
winces114819113wi__nces
xylenes1745093xylen_es

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.406440125.6
2DLD Change Limit1461621657.12620511.1
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.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.