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

364 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
unpent8311737(None) 
unbent83216591unbent
unkent103116051unkent
unpen72913571unpen_
unpens82511011unpens
unrent63219781unrent
unsent63820961unsent
unspent92610891unspent
anent54931842an_ent
arpent84822092arpent
incent83320722incent
indent73021242indent
intent63122772intent
invent93316362invent
pent66559072__pent
pungent10311232pungent
repent84728872repent
spent75532832_spent
unbelt83015692unbelt
unbend9269772unbend
unfelt92413462unfelt
unguent839122unguent
unkend11309222unkend
unkept123710872unkept
unlet54133332unle_t
unmeant9510902unmeant
unmeet83815742unmeet
unmet74426392unme_t
unopen838912unopen_
unpeg8309362unpe_g
unpegs9256232unpegs
unpin72613242unpin_
unpins82312382unpins
unrest62918852unrest
unseat64221022unseat
unset54532432unse_t
unvext1658172unvext
unwept11389812unwept
unwet84423172unwe_t
upend85011042u_pend
upsent83314062upsent
urgent73816042urgent
absent84016993absent
accent105116263accent
advent102613753advent
agent65829643_agent
ament76036543_ament
anapest9311553anapest
ancient9514733ancient
anenst63514983an_enst
anoint6423633anoint
append1138273append
ardent73022613ardent
argent74023663argent
arpen74418043arpen_
arpens84814823arpens
arpents93613083arpents
ascent84519653ascent
aspect10612823aspect
aspen75216093aspen_
aspens85013353aspens
assent65119953assent
attent62818323attent
audient8312303audient
augment10910203augment
bent67759913__bent
blent76230953_blent
brent75734133_brent
cadent94120363cadent
candent10417363candent
cement103321673cement
cent67451013__cent
client8316343client
cogent9321003cogent
concent114422513concent
consent93723113consent
content94326153content
convent123919413convent
copen94826433copen_
copens106119963copens
current9313693current
decent94023703decent
dement93825153dement
dent57158413__dent
depend103510923depend
detent73624483detent
dipnet91317473dipnet
docent92918683docent
dopant9316133dopant
dunnest83312263dunnest
eluent6315483eluent
entente7412953entente
erumpent1245453erumpent
event85924443_event
expect1758903expect
expend16247503expend
expert15515353expert
extent132714913extent
fluent9313933fluent
foment113718303foment
fulgent1138903fulgent
funest94316863fun_est
funfest13348083funfest
funnest102912003funnest
gent56954393__gent
gerent73223103gerent
gunmen9348723gunmen_
gunnen7338713gunnen_
gunpoint1146673gunpoint
hent76656383__hent
hutment1239173hutment
impend11478793impend
incant82418513incant
incents92414533incents
incept102712753incept
incest82918743incest
indene73215373indene
indents83114663indents
inept73622153in_ept
inert53234373in_ert
infant92315133infant
infect113413443infect
infest93315433infest
ingest73119003ingest
inject153210233inject
inlet53732403inle_t
input7314653inp_ut
insect83916583insect
insert64325253insert
inset54430863inse_t
inspect1138463inspect
intend72310373intend
intents72115703intents
invents102812053invents
invert94120083invert
invest93014843invest
junket173815023junke_t
kent86846963__kent
knelt94617683kn_elt
lament85024943lament
latent64124303latent
lenient7313843lenient
lent46360533__lent
loment84021473loment
lucent8313823lucent
lumpen104010663lumpen_
lumpens11298263lumpens
lunet56835423lun_e_t
luniest73516993luniest
moment103319683moment
muniment1248943muniment
neat46356783_n_eat
nene45932063_n_ene
nest45548733_n_est
net36670293_n_e_t
nett46643233_n_ett
newt76933743_n_ewt
next116631083_n_ext
nocent83217413nocent
nonet54540843_nonet
nudest74113833nudest
numen74216793numen_
nutant6316383nutant
oncet74626543once_t
onset54730173onse_t
open66427003_open_
opens76118553_opens
orient6322533orient
outspent101310213outspent
outwent10311363outwent
pant66061263__pant
parent83230423parent
patent84524923patent
peat65967933__peat
pelt67651083__pelt
pen56558843__pen_
pend75934533__pend
pendent10314723pendent
pens65649643__pens
perpent112318813perpent
pert66759323__pert
pest65555293__pest
pet56477303__pe_t
pint66963173__pint
pipet95533323pipe_t
ponent82821593ponent
potent84223353potent
puniest92918093puniest
punkest132611693punkest
punnet83518843punne_t
punt65747203__punt
puppet93514593puppe_t
recent83630853recent
regent74127673regent
relent64431853relent
rent46661243__rent
repeat85127213repeat
repents93717623repents
rerent63832453rerent
resent63833623resent
rident7520193rident
ringent8315153ringent
ripen75619263ripen_
ripens85012173ripens
ripest84317943ripest
rodent7519243rodent
runlet63821413runle_t
sapient9415333sapient
scent75831623_scent
sent46963013__sent
serpent92916283serpent
shent85933503_shent
silent64125843silent
sklent103614353sklent
spelt75430193_spelt
spend85619333_spend
splent84720193splent
sprent84522383sprent
stent55634513_stent
subpena1136673subpena
subrent9315083subrent
sunbelt939233sunbelt
sunken103511783sunken_
sunket103721363sunke_t
sunset63723633sunse_t
suspect1158513suspect
suspend1036013suspend
talent6323323talent
tangent8314993tangent
tent46159863__tent
turgent8712393turgent
ulpan7310123ulpan_
umped104717273umpe_d
umping114815333umping
unadept1046603unadept
unapt710421593un_apt
unban72114333unban_
unbans81912623unbans
unbe65319273unbe__
unbear889163unbear
unbeing1039373unbeing
unbelts9237663unbelts
unbends10236993unbends
unbind93011433unbind
unblest9411813unblest
unbolt83013893unbolt
unburnt977413unburnt
uncast84215713uncast
uncini8310153uncini
uncleft1257493uncleft
uncut73219173un_cut
unde55825483unde__
undead82711903undead
undee65327273unde_e
undented102313953undented
under64624213unde_r
undine7817263undine
undone7914253undone
undrest8313013undrest
uneven957913uneven_
unexpert1744343unexpert
unfed94614223unfe_d
unfence1239193unfence
unfit84518563un_fit
unfixt16398423unfixt
unfond10149113unfond
ungentle946573ungentle
ungently1256953ungently
ungirt71112713ungirt
ungot61718063un_got
unguenta943713unguenta
unguents945153unguents
unhand10410383unhand
unhang1038443unhang
unhat81119263un_hat
unhelm1136863unhelm
unhewn12285253unhewn
unhung1035283unhung
unhurt9311253unhurt
union54519793union_
unions64216753unions
unipotent1145503unipotent
unit45140073un__it
unjoint1449233unjoint
unjust1337873unjust
unkempt1544763unkempt
unkind113310573unkind
unkink9308713unkink
unknit1068593unknit
unknot1037413unknot
unlead73312373unlead
unlearnt846403unlearnt
unled64021073unle_d
unless62413073unless
unlink104011013unlink
unlit55025463un_lit
unman72715423unman_
unmans82211993unmans
unmesh1145793unmesh
unmew103610073unme_w
unmews11326523unmews
unmixt15378703unmixt
unopened1137023unopened
unpack1457833unpack
unpaid939473unpaid
unpenned1137543unpenned
unpick1446903unpick
unpile81914323unpile
unplait948603unplait
unpliant1047143unpliant
unplug954413unplug
unpretty1343263unpretty
unpure82911533unpure
unread73412673unread
unreal64414453unreal
unreel63612933unreel
unrented92413923unrented
unrests7229463unrests
unripest1046083unripest
unroot6315553unroot
unseal63315473unseal
unseam83313143unseam
unseats73012853unseats
unseen62012623unseen
unsell63512543unsell
unsets64116163unsets
unsew83912693unse_w
unsewn9298393unsewn
unsews9379363unsews
unsex123512633unse_x
unsexy16296903unsexy
unshut939013unshut
unsilent849603unsilent
unspeak1344793unspeak
unspilt938853unspilt
unsplit956563unsplit
unspun865793unspun_
unsung736983unsung
unsunk1036333unsunk
unswept1246013unswept
untented92613413untented
untune62511603untune
unveil957343unveil
unwed94114873unwe_d
unwell9349443unwell
unwind102610543unwind
unwit84417523un_wit
unwon84512343unwon_
upbeat10911513upbeat
upends9438763u_pends
uplit76020803u_plit
upon65817583u_pon_
upped103715163uppe_d
upper93714263uppe_r
uppers102912293uppers
upping114013703upping
upsend9356883upsend
upset73222593u_pset
urped84615283urpe_d
urping93914053urping
urtext1337433urtext
vent76049053__vent
went76051873__went
wisent93516343wisent

Search took 6 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.390458182.1
2DLD Change Limit1127163645.36021029.1
3Display Results3643640.1262888.9
 (SQL Overall)1786913645.87630410.3
 
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.