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

376 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
unkent10311605(None) 
unbent83216591unbent
unkend11309221unkend
unkept123710871unkept
unpent83117371unpent
unrent63219781unrent
unsent63820961unsent
anent54931842an_ent
incent83320722incent
indent73021242indent
intent63122772intent
invent93316362invent
junket173815022junke_t
kent86846962__kent
pungent10311232pungent
punkest132611692punkest
sunken103511782sunken_
sunket103721362sunke_t
unbelt83015692unbelt
unbend9269772unbend
unfelt92413462unfelt
unguent839122unguent
unkempt1544762unkempt
unkind113310572unkind
unkink9308712unkink
unknit1068592unknit
unknot1037412unknot
unlet54133332unle_t
unmeant9510902unmeant
unmeet83815742unmeet
unmet74426392unme_t
unpen72913572unpen_
unpens82511012unpens
unrest62918852unrest
unseat64221022unseat
unset54532432unse_t
unspent92610892unspent
unvext1658172unvext
unwept11389812unwept
unwet84423172unwe_t
upsent83314062upsent
urgent73816042urgent
absent84016993absent
accent105116263accent
advent102613753advent
agent65829643_agent
akene95818663_akene
alkene104114003alkene
ament76036543_ament
ancient9514733ancient
anenst63514983an_enst
anklet105618733anklet
anoint6423633anoint
ardent73022613ardent
argent74023663argent
arpent84822093arpent
ascent84519653ascent
askant10412713askant
assent65119953assent
attent62818323attent
audient8312303audient
augment10910203augment
bent67759913__bent
blent76230953_blent
brent75734133_brent
bucket144620733bucke_t
bunked135118373bunke_d
bunker124519373bunke_r
bunkers133715953bunkers
bunking144016193bunking
cadent94120363cadent
candent10417363candent
cement103321663cement
cent67451013__cent
client8316343client
cogent9321003cogent
concent114422513concent
consent93723113consent
content94326153content
convent123919413convent
current9313693current
dankest122611673dankest
decent94023703decent
dement93825143dement
dent57158413__dent
detent73624483detent
docent92918683docent
drunken12263713drunken_
drunkest1334423drunkest
dunked124315283dunke_d
dunker113616463dunke_r
dunkers123512193dunkers
dunking133813263dunking
dunnest83312263dunnest
eluent6315483eluent
entente7412953entente
event85924443_event
extent132714913extent
fluent9313933fluent
foment113718303foment
fulgent1138903fulgent
funest94316863fun_est
funfest13348083funfest
funked144214113funke_d
funker133915763funke_r
funkers143712063funkers
funkiest152810973funkiest
funking154013023funking
funnest102912003funnest
gent56954393__gent
gerent73223093gerent
gunkiest132610573gunkiest
gunmen9348723gunmen_
gunnen7338713gunnen_
hent76656383__hent
hunker133917673hunke_r
hunkers143314333hunkers
hunkey164210883hunke_y
hunkeys17386193hunkeys
hunkiest153812333hunkiest
hutment1239173hutment
incant82418503incant
incents92414533incents
incept102712753incept
incest82918743incest
indene73215373indene
indents83114663indents
inept73622153in_ept
inert53234373in_ert
infant92315133infant
infect113413443infect
infest93315433infest
ingest73119003ingest
inject153210233inject
inked104218523inke_d
inker94421093inke_r
inkers104018833inkers
inkiest113415043inkiest
inking115119053inking
inkjet1737453inkjet
inkpot1237813inkpot
inlet53732403inle_t
insect83916583insect
insert64325253insert
inset54430863inse_t
intend72310373intend
intents72115703intents
invents102812053invents
invert94120083invert
invest93014843invest
junked184311693junke_d
junker174213653junke_r
junkers184010863junkers
junkets18377623junkets
junkiest192610173junkiest
junking193910073junking
junkmen2033633junkmen_
keet85347333__keet
kelt85343193__kelt
ken76343983__ken_
keno87926433__keno
kens85435233__kens
kente95821063__kente
kept106232943__kept
knelt94617683kn_elt
lament85024943lament
lankest112714113lankest
latent64124303latent
lenient7313843lenient
lent46360533__lent
liken911818843liken_
likens105613703likens
likest104914383likest
loment84021473loment
lucent8313823lucent
lunet56835423lun_e_t
luniest73516993luniest
lunker104718343lunke_r
lunkers113414603lunkers
moment103319683moment
muniment1248943muniment
murkest133110203murkest
musket122818203muske_t
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
nuke85920753nuke__
nuked104014183nuke_d
nukes95418123nuke_s
nuking113411253nuking
numen74216793numen_
nutant6316383nutant
oaken95814383oaken_
oncet74626543once_t
onset54730173onse_t
orient6322533orient
outkept1337883outkept
outwent10311363outwent
parent83230423parent
patent84524923patent
pendent10314723pendent
pent66559073__pent
pinken124513283pinken_
pinkens13419643pinkens
pinkest132812623pinkest
ponent82821593ponent
potent84223353potent
puniest92918093puniest
punker123718823punke_r
punkers133714853punkers
punkey154011173punke_y
punkeys16366493punkeys
punkiest149312663punkiest
punkin123611523punkin_
punkins133111113punkins
punnet83518843punne_t
rankest112713813rankest
recent83630853recent
regent74127673regent
relent64431853relent
rent46661243__rent
repent84728873repent
rerent63832453rerent
resent63833623resent
rident7520193rident
ringent8315153ringent
rodent7519243rodent
runlet63821413runle_t
scent75831623_scent
sent46963013__sent
shent85933503_shent
silent64125843silent
skeet95429183_skeet
skene96118123_skene
skint95629223_skint
sklent103614353sklent
spent75532833_spent
splent84720193splent
sprent84522383sprent
stent55634513_stent
subrent9315083subrent
sunbelt939233sunbelt
sunkets113511283sunkets
sunset63723633sunse_t
taken94819143taken_
talent6323323talent
tangent8314993tangent
tent46159863__tent
token95419313token_
tokens104711563tokens
tucket124219483tucke_t
turgent8712393turgent
uke75727293u_ke__
ukes86122813u_ke_s
unadept1046603unadept
unakin10310963unakin_
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_
unfed94614223unfe_d
unfence1239193unfence
unfit84518563un_fit
unfixt16398423unfixt
unfond10149113unfond
ungentle946573ungentle
ungently1256953ungently
ungirt71112713ungirt
ungot61718063un_got
unguenta943713unguenta
unguents945153unguents
unhand10410383unhand
unhang1038443unhang
unhat81119263un_hat
unhelm1136863unhelm
unhewn12285253unhewn
unhung1035283unhung
unhurt9311253unhurt
union54519793union_
unions64216753unions
unit45140073un__it
unjoint1449233unjoint
unjust1337873unjust
unkenned1336183unkenned
unkennel1243833unkennel
unkinks10265413unkinks
unknits1135553unknits
unknots1144303unknots
unlead73312373unlead
unlearnt846403unlearnt
unled64021073unle_d
unless62413073unless
unlink104011013unlink
unlit55025463un_lit
unman72715423unman_
unmans82211993unmans
unmesh1145793unmesh
unmew103610073unme_w
unmews11326523unmews
unmixt15378703unmixt
unopen838913unopen_
unpeg8309363unpe_g
unpegs9256233unpegs
unpin72613243unpin_
unpins82312383unpins
unread73412673unread
unreal64414453unreal
unreel63612933unreel
unrented92413923unrented
unrests7229463unrests
unroot6315553unroot
unseal63315473unseal
unseam83313143unseam
unseats73012853unseats
unseen62012623unseen
unsell63512543unsell
unsets64116163unsets
unsew83912693unse_w
unsewn9298393unsewn
unsews9379363unsews
unsex123512633unse_x
unsexy16296903unsexy
unshut939013unshut
unsilent849603unsilent
unsung736983unsung
unsunk1036333unsunk
unswept1246013unswept
untaken1137643untaken_
untented92613413untented
untune62511603untune
unveil957343unveil
unwed94114873unwe_d
unwell9349443unwell
unwind102610543unwind
unwit84417523un_wit
unwon84512343unwon_
upbeat10911513upbeat
upend85011043u_pend
upkeep1434143upkeep
upsend9356883upsend
upset73222593upse_t
urtext1337433urtext
vent76049053__vent
waken124818473waken_
wakens135012043wakens
went76051873__went
wisent93516343wisent
woken124614973woken_

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 Limit1127163765.00022543.2
3Display Results3763760.1103418.2
 (SQL Overall)1786913765.50032489.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.