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

156 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
nascent961052(None) 
ascent84519651_ascent
accent105116262_accent
ascend9429732_ascend
ascents93812552_ascents
assent65119952_assent
descent102616292descent
nascence1256182nascence
nascency1543692nascency
nescient1048712nescient
nocent83217412n_ocent
reascent10411982reascent
renascent1147482renascent
scent75831622__scent
absent84016993_absent
accents113511233_accents
accept123210623_accept
acescent1248013acescent
advent102613753_advent
agent65829643_a_gent
ament76036543_a_ment
ancient9514733ancient
anent54931843_a_nent
ardent73022613_ardent
argent74023663_argent
arpent84822093_arpent
ascends10388203_ascends
ascot76522513_asc_ot
ashen87818673_ashen_
askant10412713_askant
aslant6317753_aslant
aspect10612823_aspect
aspen75216093_aspen_
aspens85013353_aspens
assents74512223_assents
assert64922583_assert
asset55932263_asse_t
attent62818323_attent
basement12311493basement
basest84720493bas_est
basinet9318933basinet
basket125722913baske_t
basset85225383basse_t
bassett94213863bassett
cadent94120363ca_dent
calescent13118223calescent
candent10417363candent
canescent13118763canescent
casement12311953casement
casket124820993caske_t
cassena9287843cassena
cassene93111543cassene
cent67451013___cent
concent114422513concent
crescent12711053crescent
decent94023703_decent
descant104315593descant
descend11248153descend
descents112511203descents
discant103017263discant
discept12310623discept
dissent84018683dissent
distent84120853distent
docent92918683_docent
easement10414163easement
easiest72318773easiest
facet106038523fa_ce_t
fasces114914543fasce_s
fascine12510583fascine
fascist1239213fascist
fasten95114893fasten_
fastens105511753fastens
fastest102413723fastest
faucet115816553fauce_t
garment10315233garment
gascon9339723gascon_
gascons10289103gascons
gashest114813413gashest
gasket114417253gaske_t
gasmen93111563gasmen_
haslet93222713hasle_t
hasten95718563hasten_
hastens106214813hastens
ignescent1245203ignescent
incent83320723_incent
indecent11411273indecent
innocent1048163innocent
lambent113711303lambent
lament85024943la_ment
lancet84223573lance_t
larceny1234853larceny
latent64124303la_tent
lucent8313823_lucent
margent10316693margent
mascon103612743mascon_
mascons113411583mascons
mascot104016073masc_ot
missent94318713missent
naivest10309473naivest
nance74721843nance__
nances83618643nance_s
narcein936293narcein
narceine1046753narceine
narceins1036413narceins
narcist9512443narcist
nascences1346233nascences
nasion63914083nasion_
nasions73112383nasions
nastiest83615953nastiest
natant6318733na_tant
nauseant845743nauseant
navicert1344883navicert
nescients1145103nescients
nicest82315663n_icest
nosiest73415673nosiest
obscene1145243obscene
parent83230423pa_rent
passant9813943passant
patent84524923pa_tent
patient9617073patient
payment14310703payment
percent113520603percent
precent113520263precent
pschent1437413_pschent
raiment9315413raiment
rashest103916873rashest
reaccent1278573reaccent
reascend1145703reascend
reascents1177403reascents
recent83630853_recent
resent63833623res_ent
salient7419763salient
sapient9415333sapient
sarcenet10413313sarcenet
sarment9318763sarment
scant79735073__scant
scena74815783__scena
scend85516293__scend
scene77220573__scene
scents85317023__scents
senescent1167793senescent
sent46963013__s_ent
shent85933503__shent
spent75532833__spent
stent55634513__stent
tacet75840023ta_ce_t
talent6323323ta_lent
tangent8314993tangent
tasset65925313tasse_t
unsent63820963uns_ent
unspent92610893unspent
upsent83314063ups_ent
vacant11415133va_cant
varment12313243varment
vastest102911513vastest
wisent93516343wis_ent

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271565.97022450.1
3Display Results1561560.0602600.0
 (SQL Overall)1786911566.45327691.2
 
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.