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

256 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
dynast108822(None) 
dynasts1155101dynasts
dynasty1463201dynasty
bypast13117372bypast
demast9517062demast
dicast9315572dicast
donas65926472donas_
dynamist1445342dynamist
dynamo1274162dynamo
dynastic1445852dynastic
dynes95917582dynes_
gymnast1344152gymnast
mynas105815232mynas_
yeast85327942_yeast
aghast105711373aghast
anas46649863_anas_
angst6415493_angst
annas55824883annas_
avast85519363_avast
bast66362413__bast
beast76338643_beast
blast76532573_blast
boast75935703_boast
breast8319633breast
bunas75126573bunas_
byname13256363byname
bypass1345043bypass
byzant2096813byzant
canasta938363canasta
canst74932213can_st
cast67159903__cast
cineast9310523cineast
clast76030583_clast
coast75236273_coast
cyans105714813cyans_
cycas126513823cycas_
cymas126417883cymas_
cyst96322813cy__st
dadaist9310103dadaist
dadas75819863dadas_
daft85537253d__aft
dalasi7610623dalasi
damask1335843damask
dangs75623203dangs_
danish101513793danish
dankest122611673dankest
dans56748153dan_s_
dart55857873d__art
dash87031633d__ash
daut56443563d__aut
dawt85435943d__awt
dealt65234283d_ealt
deans66131393deans_
deash95617243d_eash
debase94014473debase
decant93524223decant
defat95426693defa_t
defats105114553defats
degas75119163degas_
degust8310253degust
deist64633593d_eist
delist74625053delist
demasts1089223demasts
denar65223293dena_r
denari710917353denari
denars74621433denars
denary105316863denary
denes65639723denes_
dens55945073den_s_
dense65923503den_se
densest83112473densest
dent57158413den__t
dentist8316743dentist
dents65031803dents_
depart94720563depart
derat65044083dera_t
derats74625063derats
desalt7518313desalt
desist74818813desist
detest74122843detest
devas96218883devas_
devest104418703devest
dicasts1078703dicasts
didact10711203didact
didst74619613d_idst
digest84019623digest
dinar66319893dina_r
dinars75417563dinars
dines66449153dines_
dings76331403dings_
dinks105927953dinks_
dinos65428063dinos_
dins56652043din_s_
dint56759053din__t
dints67431313dints_
direst75024243direst
dismast10311233dismast
ditas65923673ditas_
divas95418583divas_
divest106820073divest
doat56947673d_oa_t
doats65224883d_oats
doest65829523d_oest
dona55529633dona__
donate73619503donate
dongas84914613dongas_
dongs76525813dongs_
donnas75511323donnas_
dons56048703don_s_
donsy96414683don_sy
donut6324513don_ut
donuts7410583donuts
dopant9316133dopant
dopas85019063dopas_
dost57248353d__ost
downcast1445003downcast
draft95526683d_raft
drat56247833d_ra_t
drats66628373d_rats
dreamt94615713dreamt
drest65530343d_rest
driest74722753driest
dryest104811123dryest
dryness11114783dryness
ducat86225903duca_t
ducats95011763ducats
dumas85420433dumas_
dunam8313733duna_m
dunams937833dunams
dunes65332173dunes_
dungs75821973dungs_
dunks105621193dunks_
dunnest83312263dunnest
duns55140433dun_s_
dunt55746873dun__t
dunts65828413dunts_
duras65727723duras_
durmast1037623durmast
durst66125173d_urst
dust57142533d__ust
dyad96415453dy_a_d
dyads10549973dy_ads
dyers96617133dyers_
dyes85331893dy_es_
dyings11478133dyings_
dykes135215573dykes_
dynamic1545813dynamic
dynamism1643733dynamism
dynamists1544093dynamists
dynamite1444813dynamite
dynamos1373853dynamos
dynasties1344063dynasties
dyne85320933dyn__e
dynein1035563dynein
dynel9569853dyn_el
dynels10536813dynels
dynode1135023dynode
east46659103__east
enact73525363_enact
etnas54713933etnas_
eyas76427433ey_as_
eyass84410783ey_ass
eyras84715923eyras_
fantast10311703fantast
fast77052313__fast
feast85932723_feast
finest94321733finest
flypast1583753flypast
funest94316863funest
gast56052563__gast
ghast95621223_ghast
gnash9449833_gnash
gnat56034433_gna_t
gnats65217713_gnats
gymnasts1442433gymnasts
gyrase10508773gyrase
hast76259483__hast
honest94822423honest
hyenas1288953hyenas_
hylas114815903hylas_
hymnist1546633hymnist
idylist1146653idylist
inapt73522693_inapt
kanas95326913kanas_
kinas95626913kinas_
kinase104210653kinase
kyat116025523ky_a_t
kyats125012443ky_ats
last46260323__last
least56134883_least
lunas55025013lunas_
lyart85121883ly_art
lyase85512413ly_ase
lyrist9312293lyrist
manas76240433manas_
manat76039993mana_t
manats84623463manats
mast65959963__mast
minas75434113minas_
monas74732153monas_
mongst93512603mongst
monist84324983monist
myna95815303myna__
mynah13569563myna_h
mynahs14416443mynahs
mysost1138263mysost
nanas55928633nanas_
nasty85717283__nasty
nest45548733__nest
nonart6319193nonart
nonas55126653nonas_
nonpast939033nonpast
oast47156323__oast
oblast8613663oblast
past65959013__past
pinas75434453pinas_
punas74826753punas_
pyas96225703py_as_
qanat144426843qana_t
qanats154112813qanats
recast83422773recast
renest64529713renest
repast83520633repast
roast56230143_roast
ryas77224613ry_as_
rynds9569973rynds_
sanest64426693sanest
snash84815673_snash
sonant6621953sonant
sunfast1038503sunfast
synapse1234133synapse
syncs104610173syncs_
syndet10311963syndet
syngas10368913syngas_
tanist6324593tanist
tenant6322473tenant
toast55831013_toast
tunas54224123tunas_
tynes85920303tynes_
typist1139823typist
tyrant9315333tyrant
ulnas55716533ulnas_
unapt710421593_unapt
uncast84215713uncast
upcast102710093upcast
vast75045123__vast
vinas85126343vinas_
wast75655853__wast
wynds126310373wynds_
wynns11517473wynns_
wyns105717033wyn_s_
xyst144714073xy__st
yeas78638423_yeas_
yeasts96413053_yeasts
yeasty12438693_yeasty
zymase201997483zymase

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 Limit1127162565.31321215.1
3Display Results2562560.0803200.0
 (SQL Overall)1786912565.53332295.5
 
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.