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

422 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
incent8332072(None) 
incant82418501incant
incents92414531incents
incept102712751incept
incest82918741incest
indent73021241indent
intent63122771intent
invent93316361invent
accent105116262accent
ancient9514732ancient
anent54931842an_ent
ascent84519652ascent
cent67451012__cent
concent114422512concent
decent94023702decent
docent92918682docent
incants92012802incants
incense92410302incense
incented112412542incented
incenter102212092incenter
incepts11238282incepts
incests92711382incests
incident11410202incident
incony1139082incony
incult82414772incult
indecent11411272indecent
indene73215372indene
indents83114662indents
inept73622152in_ept
inert53234372in_ert
infant92315132infant
infect113413442infect
infest93315432infest
ingest73119002ingest
inject153210232inject
inlet53732402inle_t
innocent1048162innocent
insect83916582insect
insert64325252insert
inset54430862inse_t
intend72310372intend
intents72115702intents
invents102812052invents
invert94120082invert
invest93014842invest
lucent8313822lucent
nicest82315662nicest
nocent83217412nocent
oncet74626542once_t
recent83630852recent
ringent8315152ringent
scent75831622_scent
unbent83216592unbent
unkent103116052unkent
unpent83117372unpent
unrent63219782unrent
unsent63820962unsent
absent84016993absent
accents113511233accents
accept123210623accept
advent102613753advent
agent65829643_agent
ailment9314233ailment
ament76036543_ament
ancients1098973ancients
ancon75718233ancon_
ancone83916953ancone
anenst63514983an_enst
anoint6423633anoint
ardent73022613ardent
argent74023663argent
arpent84822093arpent
ascend9429733ascend
ascents93812553ascents
assent65119953assent
attent62818323attent
bent67759913__bent
blent76230953_blent
brent75734133_brent
cadent94120363cadent
candent10417363candent
cant66362033__cant
celt65646713__celt
cement103321663cement
cento76625173__cento
cents74730333__cents
centu76119413__centu
client8316343client
cogent9321003cogent
coinvent1348183coinvent
conceit113218073conceit
concents122516603concents
concept133314443concept
concert113325223concert
consent93723113consent
content94326153content
convent123919413convent
cunt66243673__cunt
decant93524223decant
deceit93018213deceit
dement93825143dement
dent57158413__dent
descent102616293descent
detent73624483detent
diluent8310263diluent
discant103017253discant
discept12310623discept
dissent84018683dissent
distent84120853distent
docents102810803docents
eluent6315483eluent
eminent9313843emin_ent
enceinte1046263enceinte
enchant12313113enchant
encina8310443encina
encyst1136203encyst
entente7412953entente
eocene8311613eocene
event85924443_event
except1797653except
extent132714913extent
facet106038523face_t
figment1379743figment
finest94321733fin_est
fitment12710303fitment
fluent9313933fluent
foment113718303foment
gent56954393__gent
gerent73223093gerent
ginseng933433ginseng
hent76656383__hent
ice56737243i_ce__
iced78721893i_ce_d
ices66129643i_ce_s
iciest82914743iciest
icing86017753i_cing
icon66922043i_con_
icons76516493i_cons
idlest74014863idlest
ignescent1245203ignescent
illest63615723illest
impend11478793impend
inane52820343in_ane
inaner62213543inaner
inanes62519803inanes
inanest72115363inanest
inapt73522693in_apt
inbeing1038333inbeing
incage93513623incage
incanted11259543incanted
incase83615283incase
incensed11277953incensed
incenses102411003incenses
incenters112510303incenters
incenting12912063incenting
incentive1489603incentive
incepted13177773incepted
inceptor1246023inceptor
incessant1146093incessant
inch95420823inc__h
inched124514483inched
incher114114033incher
inchers123912523inchers
inches114419673inches
inching134414323inching
incidents1246803incidents
incipient1347763incipient
incipit1158923incipit
incise83515333incise
incitant10810083incitant
incite83618733incite
inclement1349913inclement
incline9314643incline
inclip1036823inclip
incog838253inc_og
incogs937903incogs
income10712093income
inconnu945053inconnu
increate10312203increate
increment13411683increment
incrust949203incrust
incubi1035113incubi
incumbent1545633incumbent
incur72212253inc_ur
incurrent1147123incurrent
incurs83012283incurs
incus73315053inc_us
incuse83513573incuse
indeed83913563indeed
indenes82916253indenes
indented101811733indented
indenter92311443indenter
indentor9288513indentor
index13310983inde_x
indicant11410343indicant
indict93115573indict
indigent102911613indigent
indolent91311683indolent
induct93212743induct
indult73614033indult
indwelt1146513indwelt
inerts64517023in_erts
infanta10237253infanta
infante101910883infante
infants102210773infants
infects12279713infects
infer84215033infe_r
inferno1045603inferno
infers93615443infers
infests10279793infests
inflect1249223inflect
influent1147623influent
ingenue847133ingenue
ingesta8357863ingesta
ingests83210983ingests
ingot61221063in_got
inhere9313713inhere
inherent11412793inherent
inherit10312973inherit
inion54620183inion_
inions64417003inions
injects16257453injects
inked104218523inke_d
inker94421093inke_r
inkers104018833inkers
inkiest113415043inkiest
inking115119053inking
inkjet1737453inkjet
inkpot1237813inkpot
inland7310313inland
inlets63915573inlets
inmesh1134863inmesh
inmost8411363inmost
inn36727433in__n_
inned64118423inne_d
inner54920633inne_r
inners63919353inners
inning73617633inning
innocents1145313innocents
inns46920933in__ns
input7314653in_put
inquest1638603inquest
inrun52911373inrun_
inruns6359513inruns
insane6314883insane
inseam8329993inseam
insects93710843insects
inserts74013993inserts
insets64016133insets
insist6314513insist
insolent81311553insolent
inspect1138463inspect
instant7815343instant
insult62813673insult
inswept1245733inswept
intact8314663intact
intends8239963intends
intense72511903intense
intently1149823intently
inter55028493inte_r
intern64016543intern
interne73218143interne
interns73116773interns
inters64328053inters
intine61021983intine
intone61115433intone
intort6418923intort
intrant7318753intrant
intreat7416303intreat
intuit6314083intuit
inurn53712863inurn_
inurns63310983inurns
invented122510663invented
inventer112410843inventer
inventor11298153inventor
inverts103211953inverts
invests10319683invests
inwind10268413inwind
islet54527553isle_t
kent86846963__kent
kindest12311503kindest
knelt94617683kn_elt
lament85024943lament
lancet84223573lance_t
latent64124303latent
lenient7313843lenient
lent46360533__lent
licente91210893licente
linden7411453linden_
lindens839413lindens
linecut997983linecut
linen55728723lin_en_
linens64818393lin_ens
lineny94011443lin_eny
liniest73321153liniest
liniment1049533liniment
linnet6419423linne_t
loment84021473loment
mince95325233mince__
minced114114913mince_d
mincer104017363mince_r
mincers113714853mincers
minces104420803mince_s
minciest122913103minciest
mincing123314333mincing
minuend1035383minuend
minuet82621033minue_t
miocene1147923miocene
missent94318713missent
moment103319683moment
nascent9610523nascent
neat46356783_n_eat
nene45932063_n_ene
nest45548733_n_est
net36670293_n_e_t
nett46643233_n_ett
newt76933743_n_ewt
next116631083_n_ext
nice65534713nice__
nicely1139493nicely
nicer74618293nice_r
nicety1138433nicety
nonet54540843_nonet
ointment1069233ointment
once65423083once__
onset54730173onse_t
orient6322533orient
parent83230423parent
patent84524923patent
pendent10314723pendent
pent66559073__pent
percent113520603percent
pigment12510733pigment
pincer104019173pince_r
pincers113916503pincers
pinene82915643pin_ene
piniest93121133piniest
pinken124513283pinken_
pinkens13419643pinkens
pinkest132812623pinkest
ponent82821593ponent
potent84223353potent
precent113520263precent
pschent1437413pschent
pungent10311233pungent
recant83228683recant
recept103319073recept
regent74127673regent
reinvent1138903reinvent
relent64431853relent
rent46661243__rent
repent84728873repent
rerent63832453rerent
resent63833623resent
rident7520193rident
rodent7519243rodent
scant79735073_scant
scena74815783_scena
scend85516293_scend
scene77220573_scene
scents85317023_scents
secant84023293secant
sent46963013__sent
shent85933503_shent
silent64125843silent
since75024173since__
sincere9310553sincere
sklent103614353sklent
spent75532833_spent
splent84720193splent
sprent84522383sprent
stent55634513_stent
tacet75840023tace_t
talent6323323talent
tangent8314993tangent
tent46159863__tent
tinct76126233tinc__t
tiniest73020123tiniest
tinmen82310403tinmen_
unbelt83015693unbelt
unbend9269773unbend
uncast84215713uncast
uncini8310153uncini
uncleft1257493uncleft
uncut73219173unc_ut
unfelt92413463unfelt
unguent839123unguent
unkend11309223unkend
unkept123710873unkept
unlet54133333unle_t
unmeant9510903unmeant
unmeet83815743unmeet
unmet74426393unme_t
unpen72913573unpen_
unpens82511013unpens
unrest62918853unrest
unseat64221023unseat
unset54532433unse_t
unspent92610893unspent
unvext1658173unvext
unwept11389813unwept
unwet84423173unwe_t
upsent83314063upsent
urgent73816043urgent
vacant11415133vacant
vent76049053__vent
viniest103216613viniest
violent102110813violent
went76051873__went
wince105220883wince__
winced124415343wince_d
wincer115018193wince_r
wincers123415363wincers
winces114819113wince_s
wincey144110383wince_y
winceys15395523winceys
wincing133413903wincing
winiest103419693winiest
wisent93516343wisent
yince105214253yince__
zinced18419413zince_d
zincing192910283zincing

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.1401276364.3
2DLD Change Limit1127164225.34321096.0
3Display Results4224220.1403014.3
 (SQL Overall)1786914225.62331778.6
 
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.