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

147 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
dynasts115510(None) 
dynast1088221dynast_
dynasty1463201dynasty
demasts1089222demasts
dicasts1078702dicasts
dynamists1544092dynamists
dynamos1373852dynamos
dynastic1445852dynastic
dynasties1344062dynasties
gymnasts1442432gymnasts
yeasts96413052_yeasts
angsts738863_angsts
basts75936933__basts
beasts84519723_beasts
blasts85116773_blasts
boasts85017923_boasts
breasts939703breasts
bynames14256243bynames
bypass1345043bypas_s
bypast13117373bypast_
byzants2153223byzants
canasta938363canasta
canastas1037693canastas
casts77237793__casts
cineasts1045543cineasts
clasts84817293_clasts
coasts85719143_coasts
cycases1437533cycases
cysts105912773cy__sts
dadaists1045583dadaists
dalasis8810533dalasis
damasks1435073damasks
darts67635733d__arts
dauts67822243d__auts
dawts97216123d__awts
debases103814133debases
decants103514443decants
defats105114553defa_ts
degases93413103degases
degusts936063degusts
deists74916433d_eists
delists84414173delists
demast9517063demast_
denars74621433dena_rs
dentists939263dentists
dents65031803den__ts
departs104310683departs
derats74625063dera_ts
desalts839573desalts
desists83611723desists
detests83711743detests
devests114410473devests
dicast9315573dicast_
didacts1186063didacts
digests93610613digests
dinars75417563dina_rs
dints67431313din__ts
dismasts1137513dismasts
divests114510933divests
doats65224883d_oa_ts
donas65926473dona__s
donate73619503dona_te
donates83217223donates
donuts7410583don_uts
dopants1038433dopants
downcasts1542913downcasts
drafts105012533d_rafts
drats66628373d_ra_ts
dryness11114783drynes_s
ducats95011763duca_ts
dunams937833duna_ms
dunts65828413dun__ts
durmasts1144093durmasts
dusts65923563d__usts
dyads10549973dy_a_ds
dynamic1545813dynamic
dynamics1644093dynamics
dynamism1643733dynamism
dynamisms1743373dynamisms
dynamist1445343dynamist
dynamite1444813dynamite
dynamites1544623dynamites
dynamo1274163dyna_mo
dyneins1134213dyneins
dynels10536813dyn_els
dynes95917583dyn__es
dynodes1235453dynodes
easts57530323__easts
enacts84012973_enacts
eyases94513683ey_ases
eyass84410783ey_as_s
fantasts1147113fantasts
fasts86429683__fasts
feasts95116093_feasts
flypasts1662433flypasts
gasts66628633__gasts
gnats65217713_gna_ts
gymnast1344163gymnast_
gyrases11368313gyrases
hymnists1644903hymnists
idylists1244123idylists
kinases113511123kinases
kyats125012443ky_a_ts
lasts57731263__lasts
leasts64616413_leasts
lyases95211873ly_ases
lyrists1036963lyrists
manats84623463mana_ts
masts77035763__masts
monists93614783monists
myases113711553my_ases
myasis114010473my_asis
myiases1235493myiases
myiasis1245493myiasis
mynahs14416443myna_hs
mynas105815233myna__s
mysosts1234543mysosts
nasty85717283__nasty
nests55728003__nests
nonarts7311303nonarts
nonpasts1046553nonpasts
oasts56529183__oasts
oblasts947303oblasts
pasts75936503__pasts
qanats154112813qana_ts
recasts93413533recasts
renests74014213renests
repasts93611933repasts
roasts64915413_roasts
sonants7511233sonants
synapses1344713synapses
synapsis1345143synapsis
syndets1136113syndets
synesis1039163synesis
syngases1245073syngases
tanists7313653tanists
tenants7311013tenants
toasts65914993_toasts
typists1236173typists
tyrants1037453tyrants
upcasts11185643upcasts
vasts86423773__vasts
wasts87433673__wasts
xysts15558123xy__sts
yeast85327943_yeast_
yeasty12438693_yeasty
zymases21938333zymases

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.440406115.9
2DLD Change Limit1340271475.61023890.7
3Display Results1471470.0602450.0
 (SQL Overall)1786911476.11029245.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.