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

214 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
descant10431559(None) 
decant93524221de_cant
descants112910141descants
descent102616291descent
discant103017261discant
decane93818872de_cane
decants103514442de_cants
decent94023702de_cent
defiant11311922defiant
desalt7518312des_alt
desand84812632des_and
descanted1336672descanted
descanter1246442descanter
descend11248152descend
descents112511202descents
desiccant1444192desiccant
desman9311692desman_
desmans1039002desmans
deviant11311312deviant
discants112912022discants
distant83519952distant
jessant1438442jessant
peccant13311732peccant
recant83228682re_cant
scant79735072__scant
secant84023292se_cant
vesicant1347502vesicant
acescent1248013acescent
ascent84519653_ascent
askant10412713_askant
aslant6317753_aslant
bezant17814543be_zant
bezzant1746893bezzant
cant66362033___cant
cosecant12410683cosecant
crescent12711053crescent
deacon9510423deacon_
deacons10310393deacons
dealt65234283de__alt
dean56039483de__an_
deans66131393de__ans
debutant1146183debutant
decade104216163de_cade
decadent1249003de_cadent
decaf114919443de_ca_f
decafs124010883de_cafs
decal85523233de_ca_l
decals93717713de_cals
decamp1338453de_camp
decanal1038113de_canal
decanes103118913de_canes
decanted122310493de_canted
decanter112510793de_canter
decare93919153de_care
decay114718483de_ca_y
decays124612913de_cays
deceit93018213de_ceit
decoct11313783de_coct
dedans85915073de_dans
deewan10267553deewan_
deewans11306903deewans
defang1137753de_fang
defat95426693de_fa_t
defeat103817163defea_t
dehiscent1545493dehiscent
deicing11312193deicing
demand104314253de_mand
demast9517063de_mast
demean9510563demean_
demeans1039723demeans
dement93825153de_ment
demount1049743demount
dent57158413de___nt
deodand1035713deodand
depaint10314593depaint
depart94720563de_part
deplane10311413deplane
derat65044083de_ra_t
desalts839573des_alts
desands94810163des_ands
descanters1345013descanters
descanting1446923descanting
descendant1454063descendant
descends12266983descends
descry1256183desc_ry
desert72725493des_ert
desiccants1542663desiccants
design8408933design_
designs9328313designs
desinent9312963desinent
desist74818813des_ist
deskman1444323deskman_
despair1045463despair
despond1137513despond
despot93413293des_pot
dessert82916453dessert
destain8412083destain
destains9311813destains
destine83719953destine
destiny113111463destiny
detent73624483de_tent
detract101414633detract
deucing1139393deucing
deviants1236733deviants
dewan95718043de_wan_
dewans105215143de_wans
dicast9315573d_icast
disband1138243disband
discanted1339333discanted
discard11310213discard
discase102912863discase
discept12310623discept
discing113914593discing
discount11811313discount
dismast10311233dismast
dispart101115283dispart
displant11412223displant
dissent84018683dissent
distent84120853distent
docent92918683d_ocent
dogcart1148043dogcart
dopant9316133d_opant
dormant102814373dormant
ducat86225903d_uca_t
eluant6315093_eluant
enchant12313123_enchant
errant6618733_errant
escape103811663_escape
escar74011993_esca_r
escarp10449003_escarp
escars83913133_escars
escort84616483_escort
escot75320083_esc_ot
etchant1249823_etchant
exsecant1794753exsecant
extant132714753_extant
gelant72821673ge_lant
gellant83214053gellant
gestalt8411173gestalt
hepcat13611823hepca_t
hesitant1149083hesitant
incant82418513_incant
instant7815353instant
issuant748263issuant
leant56737783le__ant
levant9314493le_vant
meant76537213me__ant
mediant103516703mediant
medicant13910833medicant
merchant1548823merchant
mescal104113493mesca_l
mescals112911573mescals
mesian84315503mesian_
messan83912063messan_
messans92710463messans
miscast11312423miscast
muscat10314663musca_t
nascent9610523nascent
nescient1048713nescient
newscast1343433newscast
passant9813943passant
peasant9314923peasant
pecan91919033pe_can_
pecans101515833pe_cans
pedant9319493pe_dant
penchant1549583penchant
pendant10314853pendant
pennant9312493pennant
percent113520603percent
pissant91012503pissant
reactant10311433reactant
reascent10411983reascent
reboant9315093reboant
recane83022873re_cane
recants93217093re_cants
recast83422773re_cast
recent83630853re_cent
regnant8312843regnant
regrant8317323regrant
reliant7319243reliant
remnant9312643remnant
replant93318533replant
reptant92817073reptant
resat55139683res_a_t
rescale93215473rescale
rescind10410393rescind
reseat64131493resea_t
resent63833623res_ent
resonant8410813resonant
restart7320033restart
scan65530453__scan_
scans74625103__scans
scants85219723__scants
scanty114014663__scanty
scart76139773__scart
scat65848373__sca_t
scatt76030093__scatt
scent75831623__scent
sealant73118303sealant
seawant103613413seawant
secants93413893se_cants
sejant133114483se_jant
sejeant1489723sejeant
servant10313633servant
sextant142911963sextant
slant55238703__slant
teacart91113193teacart
tenant6322473te_nant
vacant11415133_vacant
verdant11313293verdant
versant10313833versant
vesicants1444753vesicants
webcast1445553webcast
wessand1144833wessand

Search took 9 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.406440125.6
2DLD Change Limit1340272148.18616372.7
3Display Results2142140.0932301.1
 (SQL Overall)1786912148.68520574.7
 
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.