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

197 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
silenter83887(None) 
silencer1036301silencer
misenter10310832misenter
silence9310222silence_
silenced1136282silenced
silencers1145292silencers
silences10310082silences
silent64125842silent__
silentest948102silentest
silently1147482silently
silents73514492silent_s
sinter63625922si__nter
sklented1335052sklented
slender83413602s_lender
splinter10329702splinter
absenter1086773absenter
alerter72111513_alerter
aliener71011193alien_er
assenter867713assenter
bilander1136673bilander
billeter1037563billeter
bimester1236163bimester
bleater94515303_bleater
blender104613853_blender
blunter94512043_blunter
calender1138273calender
cementer1239193cementer
center84421413__center
decenter112412163decenter
diester83013683di_ester
dieter73516773di_e_ter
digester10258433digester
dilater83515653dil_ater
diluter8319663dil_uter
dimeter10411893dime_ter
directer1137583directer
disinter9310673disinter
dissenter1059133dissenter
diverter12238623diverter
enter54726383___enter
epicenter1395503epicenter
figeater1236953figeater
fileted1159093file_ted
filister1137403filister
filter94517633fil__ter
fleeter103210363_fleeter
flenser1036783_flenser
fomenter1339263fomenter
hinter94021303hi__nter
incenter102212093incenter
indenter92311443indenter
inter55028493_i__nter
inventer112410843inventer
islander946103islander
isleted837523isle_ted
jilter133512513jil__ter
kiester11329973ki_ester
kilter103714343kil__ter
lamenter1038863lamenter
lefter93613433__lefter
lender73921283__lender
lenten6312883__lenten
letter63722583__letter
licencer12146143licencer
licenser10155883licenser
licente91210893licente_
lientery1134883li_entery
linter64625343__linter
lisente71210703lisente_
livener10278943liven_er
milter84921233mil__ter
minter84425103mi__nter
misenters1139543misenters
misinter1038833misinter
molester1099373molester
orienter838313orienter
pilaster1038163pilaster
pileate93815923pileate_
pileated112711133pileated
pilsener1044753pilsen_er
pilsner935343pilsn_er
planter94017813_planter
pleater93916333_pleater
recenter102715443recenter
reenter73217793_reenter
relented92614943relented
reletter81311023reletter
renter64527413__renter
repenter102813863repenter
rimester1037813rimester
ripener937913ripen_er
riveter10208753rive_ter
salter64325083sal__ter
saluter73512453sal_uter
saunter72913453s_aunter
scanter94215183s_canter
scented102811893s_cented
scepter1138373s_cepter
seater64534163s__eater
selected1159783selected
selectee10910493selectee
selector1048623selector
selenate81712533selenate_
selenates91611363selenates
selenite81713113selenite_
selenites91312093selenites
semester1038903semester
sender73824413s__ender
sente56432883s__ente_
serener73415763seren_er
setter64023723s__etter
sheenier11167423sheenier
sheeter103814913s_heeter
shelter103214963s_helter
shunter103611733s_hunter
sickener1436603sicken_er
sidestep1144243sidestep
sienite7312713si_enite_
sienites8311913si_enites
sifter94516233si__fter
sighter113412113si_ghter
signer74015633si_gn_er
signeted1035973signeted
silane62718053silan_e_
silanes72517163silan_es
sileni63312143silen__i
silentness1044573silentness
silenus7369693silen_us
silexes1438653sile_xes
silkier114411643sil_kier
siller64026063sil__ler
sillier74017593sil_lier
silted74020013sil__ted
siltier73413863sil_tier
silver93815813sil__ver
silverer11216733silverer
singer74227313si__nger
sinister838583sinister
sinker103620903si__nker
sinner64320603si__nner
sinters74024083si__nters
sirvente1145023sirvente_
sirventes1244913sirventes
sister64421583si__ster
sitter63323383si__tter
skeeter113410413s_keeter
skelter113610003s_kelter
sklent103614353sklent__
sklents11348163sklent_s
slander84015453s_lander
slanted83514743s_lanted
slater64429183s_l_ater
sledder9399203s_ledder
sleeker11339823s_leeker
sleeper93211563s_leeper
sleeted83113223s_leeted
sleetier837883s_leetier
slighter1257823slighter
slinger83413833s_linger
slitter73615873s_litter
slotter73314453s_lotter
smelter93311913s_melter
solander948123solander
solemner1045053solemner
specter113111733s_pecter
spelter94113703s_pelter
spencer113610973s_pencer
spender103713693s_pender
splatter10348883splatter
spleenier1143863spleenier
splendor1143753splendor
splent84720193splent__
splents93912133splent_s
splinted11369253splinted
splinters11277923splinters
splintery14264793splintery
splitter10348443splitter
splutter10357443splutter
sprinter103810813sprinter
squinter1747363squinter
stentor739383s_tentor
stinter73614513s_tinter
subcenter1347083subcenter
sullener857243sullen_er
svelter10359673s_velter
sweater103712723s_weater
sweeter103212003s_weeter
swelter103711173s_welter
tailender1044073tailender
talented938423talented
tenter64623933__tenter
tilter63417693til__ter
tinter63923643ti__nter
venter94218723__venter
widener11318693widen_er
wiener94513543wi_en_er
winter94222803wi__nter

Search took 9 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.436409841.7
2DLD Change Limit1461621978.04618165.8
3Display Results1971970.0802462.5
 (SQL Overall)1786911978.56220870.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.