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 “spent” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

145 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
spent7553283(None) 
pent66559071_pent
scent75831621scent
sent46963011s_ent
shent85933501shent
spelt75430191spelt
spend85619331spend
splent84720191splent
sprent84522381sprent
stent55634511stent
agent65829642agent
ament76036542ament
anent54931842anent
arpent84822092arpent
ascent84519652ascent
aspect10612822aspect
aspen75216092aspen_
aspens85013352aspens
assent65119952assent
bent67759912_bent
blent76230952blent
brent75734132brent
cent67451012_cent
dent57158412_dent
event85924442event
gent56954392_gent
hent76656382_hent
kent86846962_kent
lent46360532_lent
open66427002open_
opens76118552opens
pant66061262_pant
peat65967932_peat
pelt67651082_pelt
pen56558842_pen_
pend75934532_pend
pens65649642_pens
pert66759322_pert
pest65555292_pest
pet56477302_pe_t
pint66963172_pint
punt65747202_punt
rent46661242_rent
repent84728872repent
saint55147072saint
sapient9415342sapient
scant79735072scant
scena74815782scena
scend85516292scend
scene77220572scene
scents85317022scents
seat47575562s_eat
sect67443622s_ect
seen46943122seen_
sen36058522s_en_
send55237292s_end
sene46848052s_ene
sente56432882s_ente
senti56226702s_enti
sept65844362s_ept
serpent92916282serpent
set36681252s_e_t
sett45949052s_ett
sext117338092s_ext
sheet84836962sheet
shend94719972shend
shunt85226512shunt
silent64125842silent
skeet95429182skeet
skene96118122skene
skint95629222skint
sklent103614352sklent
slant55238702slant
sleet55639132sleet
slept75728102slept
smelt74726782smelt
spait75631602spait
span65234662span_
spang84919732spang
spank115919572spank
spans74528732spans
spat66548522sp_at
speak114618672speak
spean74620512spean
speans85417142speans
spear75821062spear
spec85821972spe_c
speck135115652speck
specs96916672specs
sped76031492spe_d
speed85526622speed
speel74420762speel
speer74623902speer
speil75618642speil
speir75315362speir
spell75020302spell
spelts84614642spelts
speltz174010122speltz
spence103813792spence
spends94714472spends
spendy124911142spendy
spense83912432spense
sperm93216022sperm
spew95421872spe_w
spews105015922spews
sphene113412402sphene
spilt75532222spilt
spin66231302spin_
spine76534422spine
spinet85629752spinet
spins75327982spins
spinto8410662spinto
spiny104921302spiny
spirt75032952spirt
spit65545082sp_it
splat76129342splat
splents93912132splents
splint85223282splint
split75729012split
sport75935982sport
spot65540692sp_ot
spout75029632spout
sprat76635972sprat
sprint84526792sprint
sprit76736402sprit
spun66221462spun_
spunk114513402spunk
spurt77227982spurt
steno54716862steno
stents65019452stents
stet45947322ste_t
stint57037662stint
stunt55328172stunt
suet46754822sue_t
suint55638182suint
sweat85628402sweat
sweet85330522sweet
swept105720602swept
tent46159862_tent
unpent83117372unpent
unspent92610892unspent
upend85011042upend
upsent83314062upsent
vent76049052_vent
went76051872_went

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001451.47036598.6
3Display Results1451450.0304833.3
 (SQL Overall)1786911451.79699493.9
 
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.